Home » Server Options » Data Guard » Recovery interrupted. (Oracle 9i, 9.2.0.1.0, RHEL 2.1 AS)
Recovery interrupted. [message #500924] Thu, 24 March 2011 09:35 Go to next message
jimit_shaili
Messages: 237
Registered: June 2006
Location: India, Ahmedabad
Senior Member
Dear Friends

Suddenly I got following error on my physical standby database, so please suggest me how get rid of this error. Meanwhile my primary site is working ok. herewith i'm giving some detail from my log file which can be helpful to you.
As soon as i run following commands, got below error.

SQL> startup nomount;
ORACLE instance started.

Total System Global Area  823202612 bytes
Fixed Size                   451380 bytes
Variable Size             570425344 bytes
Database Buffers          251658240 bytes
Redo Buffers                 667648 bytes
SQL> alter database mount standby database;

Database altered.

SQL> alter database recover managed standby database disconnect from session;

Database altered.


error snap from alert.log file
Thu Mar 24 19:58:31 2011
MRP0: Background Media Recovery terminated with error 600
Thu Mar 24 19:58:31 2011
Errors in file /ora9isoft/odb/OH1/admin/wbdata/bdump/wbdata_mrp0_2770.trc:
ORA-00600: internal error code, arguments: [3020], [75497477], [1], [5459], [35678], [72], [], []
ORA-10567: Redo is inconsistent with data block (file# 18, block# 5)
ORA-10564: tablespace WBTAB
ORA-01110: data file 18: '/ora9idb/odb/OH1/oradata/wbdata/wbtab04.dbf'
ORA-10560: block type 'KTFB Bitmapped File Space Bitmap'
Recovery interrupted.
Recovered data files restored to a consistent state at change 805614094.
MRP0: Background Media Recovery process shutdown


Regards

Jimit
Re: Recovery interrupted. [message #500925 is a reply to message #500924] Thu, 24 March 2011 09:40 Go to previous messageGo to next message
Michel Cadot
Messages: 67295
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support
Have a look at alert.log and trace files.

Regards
Michel
Re: Recovery interrupted. [message #500926 is a reply to message #500924] Thu, 24 March 2011 09:40 Go to previous messageGo to next message
BlackSwan
Messages: 26730
Registered: January 2009
Location: SoCal
Senior Member
ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support

It appears OS problem exists.

run dbv against '/ora9idb/odb/OH1/oradata/wbdata/wbtab04.dbf'
Re: Recovery interrupted. [message #500927 is a reply to message #500926] Thu, 24 March 2011 09:47 Go to previous messageGo to next message
jimit_shaili
Messages: 237
Registered: June 2006
Location: India, Ahmedabad
Senior Member
Dear Blackswan

on which site i've to run dbv utility on primary site or standby site, and one more thing that if i want to remove standby from the configuration. Please suggest me some steps for doing this. Still after removing standby from config, i want up and running my primary database.
Please suggest me something.

Regards

Jimit
Re: Recovery interrupted. [message #500946 is a reply to message #500927] Thu, 24 March 2011 10:56 Go to previous message
jimit_shaili
Messages: 237
Registered: June 2006
Location: India, Ahmedabad
Senior Member
hi blackswan

as you say i tried dbv and no block curruption found.
please suggest me the steps of removal of dataguard.
i m using physical standby database.

Regards
jimit
Previous Topic: ORACLE BACKUP
Next Topic: Sudden lost to a standby box
Goto Forum:
  


Current Time: Wed Aug 12 05:16:03 CDT 2020