-
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,
-
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,