RE: Error Applying Archive Log to Standby Database after Archive

From: Kevin Lange <kgel_at_ppoone.com>
Date: Wed, 13 Jun 2001 13:00:06 -0700
Message-ID: <F001.00328614.20010613130545@fatcity.com>

Trouble is .... its the Databae that generated the corrupt log, its not the transfer between file-systems. It would not help if we generated checksums on the files before and after transport.

-----Original Message-----
Sent: Wednesday, June 13, 2001 3:42 PM
To: Multiple recipients of list ORACLE-L Archive

compute checksums (MD5?) on files before and after transport?

there was a paper presented at IOUG-A 2001 Orlando that explained error checking on the handling of archived redo logs between primary and (disaster recovery) standby.

hth,

Paul

-----Original Message-----
Sent: Wednesday, June 13, 2001 3:07 PM
To: Multiple recipients of list ORACLE-L Disk

Has anyone heard of Oracle corrupting the Archive Logs when the Archive Area fills up ??

After we clean up the space issue we try and bring the standby up to date. Here is the message we get when trying to recover the Standby Database:

SVRMGR> recover automatic standby database until cancel;

ORA-00283: recovery session canceled due to errors
ORA-00368: checksum error in redo log block
ORA-00353: log corruption near block 3328 change 3854699 time 06/13/01

07:37:33
ORA-00334: archived log: '/u09/app/oracle/admin/ENCP/arch/arch19235.log'

We are running 8.0.5 on Solaris.

As it is, we have to rebuild the standby database. This is a pain, but not the end of the world. We would like to find out if there is some kind of patch for this problem (hopefully, someone else had done the leg work on tracking it down in the past .... otherwise, its out to the oh-so-lovely Metalink.)

Thanks

Kevin
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Kevin Lange
INET: kgel_at_ppoone.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Paul Drake
INET: drake_at_psscorp.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------