RE: Urgent! Online redo log files corruption

From: Satar Naghshineh <Satar.Naghshineh_at_irvine.mellesgriot.com>
Date: Mon, 23 Oct 2000 09:34:40 -0700
Message-Id: <10658.119979@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_01C03D0F.246AF280
Content-Type: text/plain

I thought that Kay's reply was a valid one. He did not imply that Oracle Support told her "horse hockey", he merely stated that one could use the hidden parameter without any problems if one's database was shutdown with immediate or normal.

Furthermore, it is ok for Winnie to perform a recovery scenario that will place her database in unsupported mode as long as she performs the necessary tasks to get her database supported again, which can be done (by her own words) with an Export.

I'll give you the benefit of doubt by assuming that you haven't had your morning coffee. ;)

Regards,
Satar

> -----Original Message-----
> From: Sent: Sunday, October 22, 2000 7:26 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Urgent! Online redo log files corruption
>
> NO!!!!!!!!!!!!!!!!!!!!!!!!
>
> Oracle Support stated very clearly that the database would not be in a
> supported state (meaning they have the option of NOT answering any future
> problem questions) if the hidden parameter is used.
>
> So you are telling Winnie that what support told her is a load of horse
> hockey. Now, maybe it's true that the database will be fine if she has
> done
> a shutdown normal or immediate (but if the online logs are lost the odds
> are
> high she had to do a shutdown abort to close the database in any case).
> But
> whether or not it's true, support said that Oracle's policy is that the
> database is no longer in a supported state.
>
> It's TOTALLY irresponsible to tell someone that they do not have to do
> what
> Support told them in this case.
>
> I'll give you the benefit of doubt and assume that the "too much travel
> this
> week" meant that you were tired and not thinking clearly when you said
> that.
>
>
> Rachel
> >From: K Gopalakrishnan <kaygopal_at_yahoo.com>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >Subject: RE: Urgent! Online redo log files corruption
> >Date: Sun, 22 Oct 2000 07:40:45 -0800
> >
> >Hi Winne !
> >
> >There is absolutely no problem in using the hidden
> >parameter if your database is shutdowned using
> >NORMAL/IMMEDIATE options.
> >
> >The problem comes only when you have shutdowned using
> >ABORT (with different scn in datafiles and system
> >files). The parameter internally takes the LOWEST SCN
> >and ignores the other changes after that.
> >
> >One typical example can be SYSTEM tablespace is with
> >scn x and data tabelspce with checkpoint scn > x. In
> >this case (after opening the database with the hidden
> >parameter) you may have the definition about the
> >table in the dictionary but the table will not exist
> >in the data tablespace.
> >
> >Too much of travel in this week. have a nice weekend..
> >!
> >
> >
> >
> >
> >
> >=====
> >Warm Regards,
> >K Gopalakrishnan
> >Bangalore, INDIA
> >
> >__________________________________________________
> >Author: K Gopalakrishnan
> > INET: kaygopal_at_yahoo.com
> >
> >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> >San Diego, California -- Public Internet access / Mailing Lists
> Author: Rachel Carmichael
> INET: carmichr_at_hotmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
>

------_=_NextPart_001_01C03D0F.246AF280
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: Urgent! Online redo log files corruption</TITLE>
</HEAD>
<BODY>

I thought that Kay's = reply was a valid one. He did not imply that Oracle Support told her = "horse hockey", he merely stated that one could use the = hidden parameter without any problems if one's database was shutdown = with immediate or normal.

Furthermore, it is = ok for Winnie to perform a recovery scenario that will place her = database in unsupported mode as long as she performs the necessary = tasks to get her database supported again, which can be done (by her = own words) with an Export.

I'll give you the = benefit of doubt by assuming that you haven't had your morning = coffee.  ;)

Regards, Satar

</P>
<UL>
<P><FONT SIZE=3D1 FACE=3D"Arial">-----Original Message-----</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"Arial">From:&nbsp;&nbsp; =

Sent:   Sunday, = October 22, 2000 7:26 PM
 To:     Multiple recipients of list ORACLE-L Subject:       = RE: Urgent! Online redo log files = corruption

<P><FONT SIZE=3D2 FACE=3D"Arial">NO!!!!!!!!!!!!!!!!!!!!!!!!</FONT>

Oracle Support stated very clearly = that the database would not be in a supported state (meaning they have = the option of NOT answering any future problem questions) if the hidden = parameter is used.

So you are telling Winnie that what = support told her is a load of horse hockey. Now, maybe it's true that the = database will be fine if she has done a shutdown normal or immediate (but = if the online logs are lost the odds are high she had to do a shutdown abort = to close the database in any case). But whether or not it's true, support = said that Oracle's policy is that the database is no longer in a supported = state.

It's TOTALLY irresponsible to tell = someone that they do not have to do what Support told them in this = case.

I'll give you the benefit of doubt and = assume that the "too much travel this week" meant that you were tired = and not thinking clearly when you said that.

Rachel >From: K Gopalakrishnan = <kaygopal_at_yahoo.com>
 >Reply-To: = ORACLE-L_at_fatcity.com
 >To: Multiple recipients of list = ORACLE-L <ORACLE-L_at_fatcity.com> >Subject: RE: Urgent! Online redo = log files corruption
 >Date: Sun, 22 Oct 2000 07:40:45 = -0800

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;Hi Winne !</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;There is absolutely no problem in =

using the hidden
 >parameter if your database is = shutdowned using

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;NORMAL/IMMEDIATE options.</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;The problem comes only when you =

have shutdowned using
 >ABORT (with different scn in = datafiles and system
 >files). The parameter internally = takes the LOWEST SCN
 >and ignores the other changes = after that.
 > >One typical example can be SYSTEM = tablespace is with
 >scn x and data tabelspce with = checkpoint scn > x. In
 >this case (after opening the = database with the hidden
 >parameter) you may  have the = definition about the
 >table in the dictionary but the = table will not exist

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;in the data tablespace.</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;Too much of travel in this week. =

have a nice weekend..

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;!</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;=3D=3D=3D=3D=3D</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;Warm Regards,</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;K Gopalakrishnan</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;Bangalore, INDIA</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;</FONT>
<BR><FONT SIZE=3D2 =
FACE=3D"Arial">&gt;__________________________________________________</F=
ONT>

>Author: K Gopalakrishnan >   INET: = kaygopal_at_yahoo.com
 > >Fat City Network = Services    -- (858) 538-5051  FAX: (858) = 538-5051
 >San Diego, = California        -- Public Internet = access / Mailing Lists
 Author: Rachel Carmichael   INET: = carmichr_at_hotmail.com

Fat City Network = Services    -- (858) 538-5051  FAX: (858) = Received on Mon Oct 23 2000 - 11:34:40 CDT