| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Redo log corruption
3 Options
1) Apply to a standby 2) Use for a test recovery 3) Issue the undocumented command "alter system dump logfile'logfile_name';" for each archive log generated.
Daniel
Paul Drake wrote:
> 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_at_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_at_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_at_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_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).
>
> -----------------------------------------------------------------------
> Do you Yahoo!?
> Exclusive Video Premiere - Britney Spears
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel W. FInk INET: Daniel.Fink_at_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_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).Received on Fri Oct 31 2003 - 14:14:24 CST
 |
 |