ORA-00752 on standby and DB_ULTRA_SAFE parameter
January 11, 2010 1 Comment
Alert file from standby database got following messages:
ORA-00752: recovery detected a lost write of a data block
ORA-10567: Redo is inconsistent with data block (file# 8, block# 351475)
ORA-10564: tablespace TD_DATA
ORA-01110: data file 8: ‘+TD_DATA/test/datafile/test01.dbf’
ORA-10561: block type ‘TRANSACTION MANAGED DATA BLOCK’, data object# 105684
and second part
ORA-10877: error signaled in parallel recovery slave PR00
ORA-00752: recovery detected a lost write of a data block
MRP0: Background Media Recovery process shutdown (test1)
The alert file shows that an ORA-00752 error is raised on the standby database
and the managed recovery is cancelled:
The recommended procedure to recover from such errors is a failover to the physical standby!!!
If you read Oracle Documentation
http://download.oracle.com/docs/cd/B28359_01/server.111/b28294.pdf
Chapter 13.6
During media recovery in a Data Guard configuration, a physical standby database
can be used to detect lost-write data corruption errors on the primary database. This is
done by comparing SCNs of blocks stored in the redo log on the primary database to
SCNs of blocks on the physical standby database. If the SCN of the block on the
primary database is lower than the SCN on the standby database, then there was a
lost-write error on the primary database. Read more of this post
Recent Comments