Home » Server Options » Data Guard » standby db ORA-0112
standby db ORA-0112 [message #61207] Mon, 05 April 2004 12:32 Go to next message
Erin
Messages: 17
Registered: October 2001
Junior Member
Open standby database for recovery is failing.

Made a cold backup of production. Copied all the database files and redo logs to new server. Altered the init parameters. Had forgotten to create a standby db control file so I did it a day later. Could that cause this problem?

SQL> alter database mount standby database;

Database altered.

SQL> recover standby database;
ORA-00279: change 342964558 generated at 04/05/2004 11:44:45 needed for thread
1
ORA-00289: suggestion : /u04/archive_logs/prod_69090.arc
ORA-00280: change 342964558 for thread 1 is in sequence #69090

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
AUTO
ORA-00283: recovery session canceled due to errors
ORA-00600: internal error code, arguments: [[3020]], [[8391650]], [[1]], [[69090]],
[[7447]], [[16]], [[]], [[]]

ORA-01112: media recovery not started

The archive log files are all in the location specified.

If I try:

SQL> recover database until cancel  ;
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

SQL> recover database until cancel using backup controlfile;
ORA-00283: recovery session canceled due to errors
ORA-01666: controlfile is for a standby database

 

Not sure why getting these errors unless it's because I made the standby db control file the next day, even though no structural changes or anyhting had been made.

Any ideas on how to get the server back into proper standby db mode?

Thanks. Erin

 

 

 
Re: standby db ORA-0112 [message #61220 is a reply to message #61207] Tue, 06 April 2004 01:32 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Hi,

You have an inconsistency between the information stored in the redo and the information stored in the database blocks being recovered.

See Metalink Note:30866: ORA-600 [[3020]] "Stuck Recovery" for some solutions.

Best regards.

Frank
Re: standby db ORA-0112 [message #61233 is a reply to message #61207] Tue, 06 April 2004 10:21 Go to previous message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
Also creating the Standby controlfile,the next day shouldnt cause a problem, as long as you have all the required archivelogs to make the database consistent.

You can always make a fresh backup,create the standby controlfile and start over ...

-Thiru
Previous Topic: Standby DB puzzle
Next Topic: Standby Database Ready - Need some help
Goto Forum:
  


Current Time: Thu Mar 28 05:37:59 CDT 2024