Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: HELP HELP
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">
<TITLE>RE: HELP HELP </TITLE> </HEAD> <BODY>
<P><FONT COLOR=3D"#0000FF" SIZE=3D2 =
FACE=3D"Arial">mellesdb:/home/oracle:>oerr ora 368</FONT>
<BR><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">00368, 00000, =
"checksum error in redo log block"</FONT>
<BR><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">// *Cause: =
The redo block indicated by the accompanying error, is not</FONT>
<BR><FONT COLOR=3D"#0000FF" SIZE=3D2 =
FACE=3D"Arial">// =
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">// =
recovery up to the indicated time. If this happens when =
archiving,</FONT>
<BR><FONT COLOR=3D"#0000FF" SIZE=3D2 =
FACE=3D"Arial">// =
archiving of the problem log can be skipped by clearing the log</FONT>
<BR><FONT COLOR=3D"#0000FF" SIZE=3D2 =
FACE=3D"Arial">// =
with the UNARCHIVED option. This must be followed by a backup of</FONT>
<BR><FONT COLOR=3D"#0000FF" SIZE=3D2 =
FACE=3D"Arial">// =
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:></FONT>
</P> <UL> <P><FONT SIZE=3D1 FACE=3D"Arial">-----Original Message-----</FONT> <BR><B><FONT SIZE=3D1 FACE=3D"Arial">From: </FONT></B> <FONT =SIZE=3D1 FACE=3D"Arial">Hamid Alavi =
<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"><SNIP></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>