cancel
Showing results for 
Search instead for 
Did you mean: 

Recover Database Failing

Recover Database Failing

Hi All,
I have system with Oracle database in redundant configuration. The Active side has the Oracle as Primary and Inactive side has Oracle as Physcical standby.

I turned off the redundancy of the Oracle database. Then I took a backup on the Active side and then restored as PRIMARY on the Inactive side (there's some reason why I need to restore as PRIMARY).

I have my own restore tool with which I restore. The tool Restores the database and then Recovers. Following are the commands used in tool:

Restore Database;
Recover Database;

When it's trying to Recover the database it' failing giving the following error:

RMAN-03002: failure of recover command at 09/05/2007 12:11:22
RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile '/opt/cems/db/oracle/u02/oradata/CEMSDB/r
edo3_1.log'
ORA-00310: archived log contains sequence 23; sequence 26 required
ORA-00334: archived log: '/opt/cems/db/oracle/u02/oradata/CEMSDB/redo3_1.log'

I serached for this error on web but could not get much info.
Could you please help me understand the error and it's root cause?

Is there something wrong with the archived logs or the Backup image?

Waiting for your kind reply.

Thanks and regards,
Kaustubh Kane.
3 REPLIES
Steven E. Protter
Exalted Contributor

Re: Recover Database Failing

Shalom,

Kind of hard to speculate on why your tool is failing.

http://forums.oracle.com/forums/thread.jspa?messageID=1131209
http://www.error-code.org.uk/view.asp?e=ORACLE-RMAN-11003

The ORA errors I've seen before. The archive log's are out of sequence. The database thinks it needs #26 and its finding 23.

I'd really need to see what rman command your utility issues to speculate further on the cause.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com

Re: Recover Database Failing

Hi Steven,
Thanks for your quick reply.

The RMAN commands used are:
# To restore
RESTORE DATABASE;

# To Recover
RECOVER DATABASE

Waiting for your kind reply.

Thanks and regards,
Kaustubh Kane.
Volker Borowski
Honored Contributor

Re: Recover Database Failing

Hi,

this looks to me liek you recover an ONLINE log (not an archived log) or you recover an archived log which has been restored to the location of the online log.

Anyway, you need to recover log number 26 but it only finds log number 23 at the given location.

So you need to
- change the path to the correct #26 archive logfile
or
- restore log number #26 to the give location (no good choice)
or
- if you cannot do on of the above due to missing log number 26 you'll need to do accept loss of data and "open restelogs" the database (But before doing so, check if you really have no backup of log#26)

Volker