[Ocfs2-users] Lost write in archive logs: has it ever happened?

[Silviu Marin-Caea]

On Wednesday 03 December 2008 18:05:49 Luis Freitas wrote:
>    Depending on your configuration, dataguard will transfer the
> modifications on the online log directly to the standby, so that the
> archived logs are recreated there. It doesnt transfer the archivedlogs from
> disk, instead it transfers the redo log entries directly to the other host,
> as they are generated, and the archivelogs are recreated there.

We had the transport method of dataguard set to log writer.  So what you're 
saying was expected.  Then we have changed the transport to ARCH.  We thought 
that this would copy archives from production to standby after they're closed 
on production.  They it would apply them on standby.

>    So the remote copy is created independently from the local copy.

Even if the transport is set to ARCH?

>    The problem could be on the process writing the archivelog to disk or on
> the operating system/hardware.

Well, on the production system we're multiplexing the archives on two 
completely separate physical devices: a shared storage with OCFS2 and local 
storage with reiserfs.  Both archives are identical (same MD5sum) and both not 
good.

>     Can you post the error that appears when applying the archivelog?

From the standby:

Wed Dec  3 16:46:35 2008
Errors in file /opt/oracle/admin/prod/bdump/prod_p002_21384.trc:
ORA-00600: internal error code, arguments: [3020], [24], [1805967], [2], 
[16452], [250046], [60], []
ORA-10567: Redo is inconsistent with data block (file# 24, block# 1805967)
ORA-10564: tablespace USR_DATA_TS
ORA-01110: data file 24: '/srv/database/datafiles/usr_data_d14.dbf'
ORA-10561: block type 'TRANSACTION MANAGED DATA BLOCK', data object# 93147
Wed Dec  3 16:46:37 2008
Errors in file /opt/oracle/admin/prod/bdump/prod_p002_21384.trc:
ORA-00600: internal error code, arguments: [3020], [24], [1805967], [2], 
[16452], [250046], [60], []
ORA-10567: Redo is inconsistent with data block (file# 24, block# 1805967)
ORA-10564: tablespace USR_DATA_TS
ORA-01110: data file 24: '/srv/database/datafiles/usr_data_d14.dbf'
ORA-10561: block type 'TRANSACTION MANAGED DATA BLOCK', data object# 93147
Wed Dec  3 16:46:40 2008
Errors with log /srv/database/logfiles/archives/2_16452_638208433.dbf
MRP0: Background Media Recovery terminated with error 12801
Wed Dec  3 16:46:40 2008
Errors in file /opt/oracle/admin/prod/bdump/prod_mrp0_21378.trc:
ORA-12801: error signaled in parallel query server P002
ORA-00600: internal error code, arguments: [3020], [24], [1805967], [2], 
[16452], [250046], [60], []
ORA-10567: Redo is inconsistent with data block (file# 24, block# 1805967)
ORA-10564: tablespace USR_DATA_TS
ORA-01110: data
Recovery interrupted!
Wed Dec  3 16:47:08 2008
Recovered data files to a consistent state at change 5884178777
Wed Dec  3 16:47:08 2008
Errors in file /opt/oracle/admin/prod/bdump/prod_mrp0_21378.trc:
ORA-12801: error signaled in parallel query server P002
ORA-00600: internal error code, arguments: [3020], [24], [1805967], [2], 
[16452], [250046], [60], []
ORA-10567: Redo is inconsistent with data block (file# 24, block# 1805967)
ORA-10564: tablespace USR_DATA_TS
ORA-01110: data