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 _______________________________________________ Ocfs2-users mailing list [email protected] http://oss.oracle.com/mailman/listinfo/ocfs2-users
