Getting error while applying arc files on standby database

greenspun.com : LUSENET : DBAzine : One Thread

We have made a standby database from our live database on a separate server. At every specifies interval of time, arc files of live db gets applied onto standby db. Sometimes, we get the following error while applying arc on standby db. Following is the contents of alert log file from bdump path of standby db. ===== Media Recovery Log /ucpl1/oradata/stbyacbdlive/arch_log/arch29630.arc Mon Nov 17 21:08:03 2003 Errors in file /ora734/app/oracle/admin/stbyacbdlive/udump/ora_5217.trc: ORA-00273: media recovery of direct load data that was not logged Mon Nov 17 21:08:03 2003 ==

And the content of above trc file (ora_5217.trc) from udump path of standby db looks like below. ====== *** SESSION ID:(7.1) 2003.11.17.21.08.03.683 kcbrrr: range redo application failure at dba 0x18002d2c RANGE DBA: 0x18002d2c BLKS: 0x00000003 INC: 0x001c5a18 OPCODE 19.2 Direct Loader invalidate block range redo entry ORA-00273: media recovery of direct load data that was not logged =====

FYI, we are not using sql loader to load data.

Looking forward for the fast response.

Thanks, Mohan.

-- Mohan (smohan@voltas.com), November 17, 2003


Moderation questions? read the FAQ