Home » RDBMS Server » Backup & Recovery » Problem with Recovery (Oracle 10g)
Problem with Recovery [message #286592] Sat, 08 December 2007 13:02 Go to next message
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 #286604 is a reply to message #286592] Sat, 08 December 2007 22:07 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Before restore did you performed restore controlfile from autobackup?
Re: Problem with Recovery [message #286659 is a reply to message #286604] Sun, 09 December 2007 10:15 Go to previous messageGo to next message
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.
Re: Problem with Recovery [message #286697 is a reply to message #286592] Sun, 09 December 2007 22:11 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Correct until you get error.
Previous Topic: FILE LOCK
Next Topic: Disaster Recovery
Goto Forum:
  


Current Time: Mon Dec 05 21:20:23 CST 2016

Total time taken to generate the page: 0.08192 seconds