cancel
Showing results for 
Search instead for 
Did you mean: 

Recovery issue

Recovery issue

Hi All,
I am performing a restore and recovery from a database image. Before performing a recovery I am deleting all the database files (datafiles, control files, redo log files, archived redo etc) to go in time to point when backup was taken.

My restore was successful but I recieved an error while recovery. The error is as follows:
unable to find archive log
archive log thread=1 sequence=82
Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 2 needs more recovery to be consistent
ORA-01110: data file 2: '/db/oracle/u05/oradata/DB/undotbs01.dbf'

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 12/07/2007 16:02:13
RMAN-06054: media recovery requesting unknown log: thread 1 scn 629113


Then I checked the backup sets but found that archived redo of thread 1 sequence 82 is present in the backup i m restoring.
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
76 27M DISK 00:00:02 07-DEC-07
BP Key: 57 Status: AVAILABLE Tag: TAG20071207T132102
Piece Name: /tmp/BACKUP_2007_12_07_13:18:37/archivelogs_76_640704062

List of Archived Logs in backup set 76
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 81 609697 07-DEC-07 629080 07-DEC-07
1 82 629080 07-DEC-07 629196 07-DEC-07
1 83 629196 07-DEC-07 629203 07-DEC-07

Eventhough the archived log is backed up why is it having issues while recovery. Why does it say unable to find archived log?
Could someone help me understand the issue?

Best Regards,
Kaustubh Kane
1 REPLY
skt_skt
Honored Contributor

Re: Recovery issue

could you explain a little more on your backup strategy(hot,cold,consistent split) and db status during the whole backup process.