| Recovery interrupted. [message #500924] |
Thu, 24 March 2011 09:35  |
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 #500927 is a reply to message #500926] |
Thu, 24 March 2011 09:47  |
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 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
