| Problem with Recovery [message #286592] |
Sat, 08 December 2007 13:02  |
kaustubh
Messages: 26
Registered: June 2007
|
Junior Member |
|
|
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
|
|
|
|
|
|
| Re: Problem with Recovery [message #286659 is a reply to message #286604] |
Sun, 09 December 2007 10:15  |
kaustubh
Messages: 26
Registered: June 2007
|
Junior Member |
|
|
Hi,
Please find the following steps that I perform while restore and recover:
First I delete all the database files (datafiles, control files, redo logs, archived redo) as the intention is to go in time when the backup was taken.
Second step is to Restore the control file and validate the database:
SET DBID $DBID;
RESTORE CONTROLFILE FROM '$dir/control_primary';
ALTER DATABASE MOUNT;
RESTORE DATABASE VALIDATE;
Third step is to restore the database:
RESTORE DATABASE;
Fourth step is to perform Recovery:
RECOVER DATABASE;
Fifth step is to open database with resetlogs option:
alter database open resetlogs;
Is the above procedure correct? Please let me know.
Thanks and regards,
Kaustubh Kane.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
