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