Sporadic block corruption occurrence after adding adatafile in ADG side (Doc ID 2460725.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

You might see the following errors in alert.log in ADG side after adding datafile in Primary db.

-----------------------------------------------------------------------------------------------------------------

 Tue Oct 17 00:08:47 2017
Archived Log entry 22058 added for thread 7 sequence 36816 rlc 947951382 ID 0x9c04a367 dest 2:
RFS[32]: Opened log for thread 7 sequence 36819 dbid 2609092932 branch 947951382
RFS[27]: Selected log 63 for thread 8 sequence 25127 dbid 2609092932 branch 947951382
RFS[28]: Selected log 62 for thread 7 sequence 38576 dbid 2609092932 branch 947951382
Tue Oct 17 00:08:51 2017
Archived Log entry 22059 added for thread 7 sequence 38575 ID 0x9c04a367 dest 1:
Tue Oct 17 00:08:55 2017
Successfully added datafile 3442 to media recovery
Datafile #3442: '+DATA_DG/AAAAA/DATAFILE/MYTABLESPACE.3967.957571725'
Tue Oct 17 00:08:57 2017
Hex dump of (file 3442, block 2) in trace file /u01/app/oracle/diag/rdbms/AAAAA/AAAAA1/trace/AAAAA1_pr0k_4351.trc <<<<<<<<<<<<<<<<<<<<<

Reading datafile '+DATA_DG/AAAAA/DATAFILE/MYTABLESPACE.3967.957571725' for corruption at rdba: 0x5d400002 (file 3442, block 2)
Read datafile mirror 'DATA_DG_CD_04_ABCDEFG6R' (file 3442, block 2) found same corrupt data (logically corrupt)
Read datafile mirror 'DATA_DG_CD_04_ABCDEFG4R' (file 3442, block 2) found same corrupt data (logically corrupt)
Read datafile mirror 'DATA_DG_CD_04_ABCDEFG5R' (file 3442, block 2) found same corrupt data (logically corrupt)
ERROR: ORA-00756 detected lost write of a data block <<<<<<<<<<<<<<<<<<<<<<<<
Worker exiting with ORA-756 exception
Tue Oct 17 00:08:57 2017
Errors in file /u01/app/oracle/diag/rdbms/AAAAA/AAAAA1/trace/AAAAA1_pr0k_4351.trc:
ORA-00756: recovery detected a lost write of a data block
ORA-10567: Redo is inconsistent with data block (file# 3442, block# 2, file offset is 16384 bytes)
ORA-10564: tablespace MYTABLESPACE
ORA-01110: data file 3442: '+DATA_DG/AAAAA/DATAFILE/MYTABLESPACE.3967.957571725'
ORA-10560: block type '0'
Tue Oct 17 00:08:57 2017
Recovery Worker PR0K previously exited with exception 756
Tue Oct 17 00:08:57 2017
Errors with log +RECO_DG/AAAAA/ARCHIVELOG/2017_10_16/thread_8_seq_23406.16239.957558953
MRP0: Background Media Recovery terminated with error 448
Tue Oct 17 00:08:57 2017
Errors in file /u01/app/oracle/diag/rdbms/AAAAA/AAAAA1/trace/AAAAA1_pr00_397022.trc:
ORA-00448: normal completion of background process
Tue Oct 17 00:08:57 2017
Managed Standby Recovery not using Real Time Apply
Tue Oct 17 00:08:59 2017
Recovery interrupted!

-----------------------------------------------------------------------------------------------------------------

Changes

Adding datafile in Primary db

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.