This discussion is archived
3 Replies Latest reply: Sep 29, 2013 12:16 PM by Baris Yildirim RSS

unable to find archived log

Habib Explorer
Currently Being Moderated

Hi

 

I am restoring a hot backup taken through RMAN using following commands:

 

 

configure controlfile autobackup on;

BACKUP DATABASE ;

BACKUP ARCHIVELOG ALL DELETE INPUT;

 

 

 

 

Now I am going to restore that using following commands:

 

restore spfile from autobackup;

restore controlfile from autobackup;

shutdown immediate;

startup mount;

restore database;

RECOVER DATABASE;

ALTER DATABASE OPEN RESETLOGS;

 

 

But it goes fine till restore database. At recover database I get following errors:

 

 

archived log for thread 1 with sequence 2461 is already on disk as file /u01/app/oracle/fast_recovery_area/XE/onlinelog/o1_mf_1_8fbs9bvt_.log

archived log for thread 1 with sequence 2462 is already on disk as file /u01/app/oracle/fast_recovery_area/XE/onlinelog/o1_mf_2_8fbs9chb_.log

unable to find archived log

archived log thread=1 sequence=545

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 09/11/2013 20:41:43

RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 545 and starting SCN of 25891726

 

 

I have checked the backup folder and there are only empty date wise folders under archivedlog folders.

 

 

If I write RMAN> ALTER DATABASE OPEN RESETLOGS; I get:

 

 

 

 

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of alter db command at 09/11/2013 20:43:01

ORA-01190: control file or data file 1 is from before the last RESETLOGS

ORA-01110: data file 1: '/u01/app/oracle/oradata/XE/system.dbf'

 

 

If I write RMAN> recover database until sequence 545; I get

 

Starting recover at 11-SEP-13

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=695 device type=DISK

 

starting media recovery

unable to find archived log

archived log thread=1 sequence=545

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 09/11/2013 21:09:34

RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 545 and starting SCN of 25891726

 

 

 

I don't mind if some data is lost. Will be really thankful if someone can help me get my database open;

 

Habib

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points