Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: HELP HELP

RE: HELP HELP

From: Satar Naghshineh <Satar.Naghshineh_at_irvine.mellesgriot.com>
Date: Thu, 9 Nov 2000 12:44:39 -0800
Message-Id: <10675.121634@fatcity.com>


This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C04A8D.E5198C70
Content-Type: text/plain

mellesdb:/home/oracle:>oerr ora 368
00368, 00000, "checksum error in redo log block"

// *Cause:  The redo block indicated by the accompanying error, is not
//          vaild. It has a checksum that does not match the block contents.
// *Action: Do recovery with a good version of the log or do time based
//          recovery up to the indicated time. If this happens when
archiving,
//          archiving of the problem log can be skipped by clearing the log
//          with the UNARCHIVED option. This must be followed by a backup of
//          every datafile to insure recoverability of the database.
// *Action: Restore correct file or reset logs. mellesdb:/home/oracle:>

> -----Original Message-----
> From: Hamid Alavi [SMTP:HamidA_at_aimdirect.co.nz]
> Sent: Thursday, November 09, 2000 8:28 PM
> To: Multiple recipients of list ORACLE-L
> Subject: HELP HELP
>
> Derar DBA's
> Today i have got the following msg in my alert.log is any body have
> idea????
> How can i just open the database for a full backup or full export:

        <SNIP>

> APPRECIATE any help.....
>
>
> Hamid Alavi
> DDI 3610148
> FAX 3610102
> 111 Franklin RD Freemans Bay Auckland
>
>
>

------_=_NextPart_001_01C04A8D.E5198C70
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3DUS-ASCII">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12">
<TITLE>RE: HELP HELP </TITLE>
</HEAD>
<BODY>

<P><FONT COLOR=3D"#0000FF" SIZE=3D2 =
FACE=3D"Arial">mellesdb:/home/oracle:&gt;oerr ora 368</FONT> <BR><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">00368, 00000, = &quot;checksum error in redo log block&quot;</FONT> <BR><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">// *Cause:&nbsp; = The redo block indicated by the accompanying error, is not</FONT> <BR><FONT COLOR=3D"#0000FF" SIZE=3D2 =
FACE=3D"Arial">//&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = vaild. It has a checksum that does not match the block contents.</FONT> <BR><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">// *Action: Do = recovery with a good version of the log or do time based</FONT> <BR><FONT COLOR=3D"#0000FF" SIZE=3D2 =
FACE=3D"Arial">//&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = recovery up to the indicated time. If this happens when = archiving,</FONT>
<BR><FONT COLOR=3D"#0000FF" SIZE=3D2 =
FACE=3D"Arial">//&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = archiving of the problem log can be skipped by clearing the log</FONT> <BR><FONT COLOR=3D"#0000FF" SIZE=3D2 =
FACE=3D"Arial">//&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = with the UNARCHIVED option. This must be followed by a backup of</FONT> <BR><FONT COLOR=3D"#0000FF" SIZE=3D2 =
FACE=3D"Arial">//&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = every datafile to insure recoverability of the database.</FONT> <BR><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">// *Action: Restore = correct file or reset logs.</FONT>
<BR><FONT COLOR=3D"#0000FF" SIZE=3D2 =
FACE=3D"Arial">mellesdb:/home/oracle:&gt;</FONT>

</P>
<UL>
<P><FONT SIZE=3D1 FACE=3D"Arial">-----Original Message-----</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"Arial">From:&nbsp;&nbsp;</FONT></B> <FONT =
SIZE=3D1 FACE=3D"Arial">Hamid Alavi =
[SMTP:HamidA_at_aimdirect.co.nz]</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"Arial">Sent:&nbsp;&nbsp;</FONT></B> <FONT = SIZE=3D1 FACE=3D"Arial">Thursday, November 09, 2000 8:28 PM</FONT> <BR><B><FONT SIZE=3D1 =
FACE=3D"Arial">To:&nbsp;&nbsp;&nbsp;&nbsp;</FONT></B> <FONT SIZE=3D1 = FACE=3D"Arial">Multiple recipients of list ORACLE-L</FONT> <BR><B><FONT SIZE=3D1 =
FACE=3D"Arial">Subject:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</FONT>= </B> <FONT SIZE=3D1 FACE=3D"Arial">HELP HELP </FONT> </P>

<P><FONT SIZE=3D2 FACE=3D"Arial">Derar DBA's</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">Today i have got the following msg in = my alert.log is any body have idea????</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">How can i just open the database for = a full backup or full export:</FONT>
<BR><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">&lt;SNIP&gt;</FONT> </P>

<P><FONT SIZE=3D2 FACE=3D"Arial">APPRECIATE any help.....</FONT>
</P>
<BR>

<P><FONT SIZE=3D2 FACE=3D"Arial">Hamid Alavi</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">DDI 3610148</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">FAX 3610102</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">111 Franklin RD Freemans Bay = Auckland</FONT>
</P> Received on Thu Nov 09 2000 - 14:44:39 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US