| standby db ORA-0112 [message #61207] |
Mon, 05 April 2004 12:32  |
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  |
Frank Naude
Messages: 4587
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 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
