OraFAQ Forum: Data Guard » Problem while recovering standby db

Home » Server Options » Data Guard » Problem while recovering standby db

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problem while recovering standby db [message #377570]

Tue, 23 December 2008 09:42

fortheppl
Messages: 9
Registered: January 2008

Junior Member

Hi
im configuring dataguard

last week i took the cold backup and copied that to standby server.
today i took the trace of standby control file and after successful mount,when i tried to recover the standby database it is throwing the following error

SQL> recover standby database
ORA-00283: recovery session canceled due to errors
ORA-01110: data file 1: 'E:\ORACLE\PRODDATA\SYSTEM01.DBF'
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: 'E:\ORACLE\PRODDATA\SYSTEM01.DBF'
ORA-01206: file is not part of this database - wrong database id

i checked the DBID it is same for prod & Standby

is this error coming because of old backup & recent standby control file?

shall i have to take the cold backup again?

how to resolve
please advice

Report message to a moderator

Re: Problem while recovering standby db [message #377574 is a reply to message #377570]

Tue, 23 December 2008 10:06

Michel Cadot
Messages: 68749
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

The error is that the file comes from another database backup.
How did you check the DBID?

Regards
Michel

[Updated on: Tue, 23 December 2008 10:06]

Report message to a moderator

Re: Problem while recovering standby db [message #377576 is a reply to message #377570]

Tue, 23 December 2008 10:11

fortheppl
Messages: 9
Registered: January 2008

Junior Member

Hi
ichecked the DBID from v$DATABASE;

i am able to mount the STANDBY DB.

i verified the same in PROD DB.
both the DBID's are same.

Actually i cloned the Prod E-Business Suite to Standby.
i checked whether the clone was successful or not by opening the STANDBY DB.Clone was successful.

so i shut down the application tier and the Database and i configured the same DB for Standby database.

but the backup was of last week Production's database and today i created the standby control file in production and im using that control file for the standby database.

while recovering im getting the above error

Report message to a moderator

Previous Topic:	Data Guard Broker CLI
Next Topic:	Recover Standby database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 12 03:12:00 CDT 2025