-
Archivelog deleted
Dear all,
I have a production DB which is backed up daily including archives , and will be deleted from the server using " delete input " command after backued up.
The problem is when I tried to do restore , I faced those two error ( Rman-6053 - Rman-6025 )
--> RMAN 6053 unable to perform media recovery because of missing log
--> RMAN 6025 no backup of log thread 1 sequence 1554 lowscn ......
and when I checked the alert log file , I found thouse archives deleted ,
Deleted Oracle managed file D:\ARCHIVE\mydb\ARCHIVELOG\2012_04_26\O1_MF_1_1554_7SMBB5Y6_.ARC
Deleted Oracle managed file D:\ARCHIVE\mydb\ARCHIVELOG\2012_04_26\O1_MF_1_1555_7SMBBDQD_.AR
So how it's possible , since I have good space in the FRA
What the reasons & assumptions that deleted this file ?
Alert Log :
Starting control autobackup
Fri Apr 27 18:22:57 2012
Errors in file c:\oracle\product\10.2.0\admin\mydb\udump\mydb_ora_3020.trc:
Fri Apr 27 18:22:57 2012
Errors in file c:\oracle\product\10.2.0\admin\mydb\mydb_ora_3020.trc:
Fri Apr 27 18:22:57 2012
Errors in file c:\oracle\product\10.2.0\admin\mydb\udump\mydb_ora_3020.trc:
Control autobackup written to SBT_TAPE device
comment 'API Version 2.0,MMS Version 1.2.0.0',
media 'DD860HQ1.001.RO'
handle 'c-921460516-20120427-00'
Fri Apr 27 18:23:11 2012
Thread 1 advanced to log sequence 1586
Current log# 1 seq# 1586 mem# 0: C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\mydb\ONLINELOG\O1_MF_1_7OVXNPSF_.LOG
Thread 1 advanced to log sequence 1587
Current log# 3 seq# 1587 mem# 0: C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\mydb\ONLINELOG\O1_MF_3_7OVXO0SF_.LOG
Fri Apr 27 18:23:13 2012
Deleted Oracle managed file D:\ARCHIVE\mydb\ARCHIVELOG\2012_04_26\O1_MF_1_1554_7SMBB5Y6_.ARC
Deleted Oracle managed file D:\ARCHIVE\mydb\ARCHIVELOG\2012_04_26\O1_MF_1_1555_7SMBBDQD_.ARC
Fri Apr 27 18:24:31 2012
Best Regards
-
did you check if the missing archive logs are available in RMAN catalog using 'list archive log ' command? Please run the list archive log command and post the output.
Regards,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
Dear Vijay Tummala ,
Thanks for your reply
I already issued this command & it doesn't show me the missing archives , it's deleted from there also.
Regards
-
would you mind to run the same commad and post the output?
Regards,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|