Simpler Navigation coming for Servers and Operating Systems
Coming soon: a much simpler Servers and Operating Systems section of the Community. We will combine many of the older boards, and you won't have to click through so many levels to get at the information you need. If you are looking for an older board and do not find it, check the consolidated boards, as the posts are still there.
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
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.
Steven E. Protter
Exalted Contributor

Re: Recover Database Failing


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

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.

Steven E Protter
Owner of ISN Corporation

Re: Recover Database Failing

Hi Steven,
Thanks for your quick reply.

The RMAN commands used are:
# To restore

# To Recover

Waiting for your kind reply.

Thanks and regards,
Kaustubh Kane.
Volker Borowski
Honored Contributor

Re: Recover Database Failing


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
- restore log number #26 to the give location (no good choice)
- 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)