|Recover Database failure [message #265542]
||Thu, 06 September 2007 11:14
Registered: June 2007
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:
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,