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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: Kevin Lange
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Reply via email to