| Archive logs deleted [message #552779] |
Sat, 28 April 2012 05:12  |
mody82
Messages: 1
Registered: April 2012
Location: KSA
|
Junior Member |
|
|
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
|
|
|
|
|
|
| Re: Archive logs deleted [message #553448 is a reply to message #553147] |
Fri, 04 May 2012 09:51  |
 |
BeefStu
Messages: 208
Registered: October 2011
|
Senior Member |
|
|
If your archive logs were backuped up with RMAN you can try retoring them first with this syntax.
restore archivelog from logseq 1 until logseq 10;
You can recover groups at time and apply them until you see a message like "media recovery cancelled". That means you dont need to apply any more logs.
|
|
|
|
] 
Search
Help
Members
Register
Login
Home
