Home » Server Options » Data Guard » Recover Database failure
Recover Database failure [message #265542] Thu, 06 September 2007 11:14
Messages: 26
Registered: June 2007
Junior Member
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.
Previous Topic: The Best form to make Backup DATA GUARD
Next Topic: About tnsnames.ora and listener
Goto Forum:

Current Time: Tue May 21 04:49:57 CDT 2024