Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h9VN0qJ01112 for ; Fri, 31 Oct 2003 17:00:52 -0600 X-ClientAddr: 66.27.56.213 Received: from www2.fatcity.com (rrcs-west-66-27-56-213.biz.rr.com [66.27.56.213]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h9VN0pc01107 for ; Fri, 31 Oct 2003 17:00:51 -0600 Received: (from root@localhost) by www2.fatcity.com (8.11.6/8.11.6) id h9VJi7n23481 for oracle-l@orafaq.net; Fri, 31 Oct 2003 11:44:07 -0800 Received: by fatcity.com (05-Jun-2003/v1.0g-b73/bab) via fatcity.com id 005D5375; Fri, 31 Oct 2003 11:39:26 -0800 Message-ID: Date: Fri, 31 Oct 2003 11:39:26 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: Paul Drake Sender: ml-errors@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: Paul Drake Subject: Re: Redo log corruption Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 73; ListGuru (c) 1996-2003 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="0-254253406-1067628940=:59162" --0-254253406-1067628940=:59162 Content-Type: text/plain; charset=us-ascii Shibu, > How can i check the "health" of archive logs ?? apply them to a standby database. daily. grep the alert logs for errors. If you have 2 servers with adequate storage space, have standby databases for each database on the other server. use one set of scripts, all using environment variables, so that you can handle an arbitrary number of standby databases on either host. Unfortunately, I can't cut loose my scripts at this point, due to intellectual property issues with my employer. Pd "Daniel W. FInk" wrote: Shibu, What version of Oracle? There is a 7.x bug where mismatches in asynch i/o read/write corrupted the logs. I don't recall if I encountered it in 8i as well, but there is something in the back of my mind saying it may still exist in later releases. Daniel Fink Shibu MB wrote: > Hi all , > > While applying archive logs to my standby database i got theerror > > ORA-00353: log corruption near block 207725 change 111482169731153 time > 10/25/2003 12:14:01 > > Can anybody tell me how archive logs can get corrupted ?? How can i avoid > oracle from generating corrupted archive logs ??How can i check the "health" > of archive logs ?? > > > Please help !. > > TIA > > Shibu > Alphawest Disclaimer > > --------------------------------------------------------------------------- > If this communication is not intended for you and you are not an authorised > recipient of this email you are prohibited by law from dealing with or > relying on the email or any file attachments. This prohibition includes > reading, printing, copying, re-transmitting, disseminating, storing or in > any other way dealing or acting in reliance on the information. > If you have received this email in error, we request you contact Alphawest > > immediately by returning the email to postmaster@alphawest.com.au and > destroy the original. This email is confidential and may contain privileged > client information. Alphawest has taken reasonable steps to ensure the > accuracy and integrity of all its communications, including electronic > communications, but accepts no liability for materials transmitted. > --------------------------------------------------------------------------- > > DISCLAIMER: > This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. > > ------------------------------------------------------------------------ > Name: winmail.dat > winmail.dat Type: application/ms-tnef > Encoding: 7bit -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel W. FInk INET: Daniel.Fink@Sun.COM Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@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). --------------------------------- Do you Yahoo!? Exclusive Video Premiere - Britney Spears --0-254253406-1067628940=:59162 Content-Type: text/html; charset=us-ascii
Shibu,
 
> How can i check the "health" of archive logs ??
 
apply them to a standby database. daily. grep the alert logs for errors.
 
If you have 2 servers with adequate storage space, have standby databases for each database on the other server. use one set of scripts, all using environment variables, so that you can handle an arbitrary number of standby databases on either host.
 
Unfortunately, I can't cut loose my scripts at this point, due to intellectual property issues with my employer.
 
Pd

"Daniel W. FInk" <Daniel.Fink@Sun.COM> wrote:
Shibu,

What version of Oracle? There is a 7.x bug where mismatches in asynch i/o read/write corrupted the logs. I don't recall if I encountered it in 8i as well, but there is something in the back of my mind saying it may still exist in later releases.

Daniel Fink

Shibu MB wrote:

> Hi all ,
>
> While applying archive logs to my standby database i got theerror
>
> ORA-00353: log corruption near block 207725 change 111482169731153 time
> 10/25/2003 12:14:01
>
> Can anybody tell me how archive logs can get corrupted ?? How can i avoid
> oracle from generating corrupted archive logs ??How can i check the "health"
> of archive logs ??
>
>
> Please help !.
>
> TIA
>
> Shibu
> Alphawest Disclaimer
>
> ---------------------------------------------------------------------------
> If this communication is not intended for you and you are not an authorised
> recipient of this email you are prohibited by law from dealing with or
> relying on the email or any file attachments. This prohibition includes
> reading, printing, copying, re-transmitting, disseminating, storing or in
> any other way dealing or acting in reliance on the information.
> If you have received this email in error, we request you contact Alphawest
>
> immediately by returning the email to postmaster@alphawest.com.au and
> destroy the original. This email is confidential and may contain privileged
> client information. Alphawest has taken reasonable steps to ensure the
> accuracy and integrity of all its communications, including electronic
> communications, but accepts no liability for materials transmitted.
> ---------------------------------------------------------------------------
>
> DISCLAIMER:
> This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission.
>
> ------------------------------------------------------------------------
> Name: winmail.dat
> winmail.dat Type: application/ms-tnef
> Encoding: 7bit

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Daniel W. FInk
INET: Daniel.Fink@Sun.COM

Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@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).

Do you Yahoo!?
Exclusive Video Premiere - Britney Spears --0-254253406-1067628940=:59162-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Drake INET: discgolfdba@yahoo.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@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).