Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Many Records in V$DATABASE_BLOCK_CORRUPTION

misterimranJul 17 2017 — edited Jul 22 2017

Dear All,

My database is 11gR2 (11.2.0.4) on Windows 2012 Standard Edition. I have a physical standby server as a disaster recovery solution.

Recently when I switched [switchover] from my production to standby database, I started getting the following error:

ORA-26040: Data block was loaded using the NOLOGGING

When I checked in details one of the index was affected and dropping the index fixed the issue and everything was all right.

Now, when I query V$DATABASE_BLOCK_CORRUPTION I can still see many records, although all the tables and indexes reported are VALID and in use.

I was under the impression that FULL RMAN backup will fix these corrupt blocks, it didn't.

Than I though that as the tables and indexes will be accessed, they will eventually removed from this view.

Still the number of records is the same, no affect on the database but I am not comfortable because if a switchover is required, my database is not ready for it.

I tried rebuilding the indexes, but rather than getting removed from block corruption view, they records got multiplied.

Need to know what impact this situation have on SWITCH OVER process, if required in any emergency situation and how to remove records from block corruption table without affecting the running database.

Will appreciate your kind help

Regards,

Imran

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 19 2017
Added on Jul 17 2017
7 comments
861 views