Home » RDBMS Server » Backup & Recovery » Archive logs deleted (Oracle 10g R2 Windows 2003)
Archive logs deleted [message #552779] Sat, 28 April 2012 05:12 Go to next message
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 #553147 is a reply to message #552779] Wed, 02 May 2012 04:59 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
hi,
You have deleted the O1_MF_1_1554_7SMBB5Y6_.ARC and O1_MF_1_1555_7SMBBDQD_.AR,so it can not found the archive log when revover database.
Re: Archive logs deleted [message #553448 is a reply to message #553147] Fri, 04 May 2012 09:51 Go to previous message
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.


Previous Topic: RMAN
Next Topic: ORA-27102: out of memory
Goto Forum:
  


Current Time: Thu Mar 28 08:29:05 CDT 2024