| 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
Dan ,
The problem was only in one log file .Now I took a cold backup and is trying to bring my standby up. After bringing the standby ......i am planning to monitor it closely for somedays ...to see if any corrupted files are getting generated or not .....
Thanks a lot
Shibu
-----Original Message----- From: Daniel Fink [mailto:Daniel.Fink_at_Sun.COM] Sent: Mon 11/3/2003 8:09 PM To: Multiple recipients of list ORACLE-L Cc: Subject: Re: Redo log corruption Shibu, I'd go ahead and check your system according to the bug (it may ormay not be present, my memory is a little foggy on the issue). If it is only 1 log, I would look to some other cause (disk), but if you find the corruption in several logs, it points to something inside the db (not always, but a good place to start).
Daniel
Shibu MB wrote:
> Dan ,
>
> My oracle version is as given below
>
> BANNER
> ----------------------------------------------------------------
> Oracle8i Enterprise Edition Release 8.1.7.3.0 - 64bit Production
> PL/SQL Release 8.1.7.3.0 - Production
> CORE 8.1.7.0.0 Production
> TNS for IBM/AIX RISC System/6000: Version 8.1.7.3.0 - Production
> NLSRTL Version 3.4.1.0.0 - Production
>
> I saw one document in metalink which says about bug in
7.3 but i
> did not see anything for 8i .
>
>
> Thanks
> Shibu
>
> -----Original Message-----
> From: Daniel W. FInk [mailto:Daniel.Fink_at_Sun.COM]
> Sent: Fri 10/31/2003 10:09 PM
> To: Multiple recipients of list ORACLE-L
> Cc:
> Subject: Re: Redo log corruption
>
>
>
> 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).
>
>
> 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 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).
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.
Content-Type: text/plain; name="ReadMe.txt"; charset="us-ascii" Content-Transfer-Encoding: 7bit
The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail.
This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact Postmaster_at_fatcity.com for clarification.
------_=_NextPart_001_01C3A2AF.95CFEBB7--
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Shibu MB INET: muhammed_basheershibu_at_mindtree.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 Tue Nov 04 2003 - 02:44:28 CST
- application/ms-tnef attachment: winmail.dat
 |
 |