Re: Urgent! Online redo log files corruption

Hi Winnie !

Thanks for sharing the info. As i have said in my earlier mail it just checks the SCN and resets the rest of the SCN with the lowest SCN.

So your BUMP_SCN would have bumped the SCN (at what level??) probably some billions..

Thanks

• Winnie_Liu_at_infonet.com wrote:
  >
  >
  > Hey.. thanks for all the post concerning this
  > subject. And like what Tom
  > and Rachel suggest, I better follow the Oracle
  > support this time and do a
  > pure Cancel based recovery. And btw, he is almost
  > one of the best support I
  > ever got on the phone with. After doing a cold
  > backup on the database
  > (before restore and recovery), he actually taught me
  > some strange method to
  > "increase" the SCN on the system manually! :P Even
  > though it does not work
  > the way we want it, but it was quite an experience.
  >
  > Thanks everyone!
  >
  > Winnie
  > :)
  >
  >
  >
  >
  >
  > "Tom Pall" <tom_at_cdproc.com>@fatcity.com on
  > 10/22/2000 10:15:21 AM
  >
  > Please respond to ORACLE-L_at_fatcity.com
  >
  > Sent by: root_at_fatcity.com
  >
  >
  > To: Multiple recipients of list ORACLE-L
  > <ORACLE-L_at_fatcity.com>
  > cc:
  >
  >
  >
  > Oracle has idiot checks inside the database and does
  > record when we do
  > unsupported
  > things. If you want to have an Oracle supported
  > database, you must follow
  > their instructions.
  > Using the hidden parameter and not
  > exporting/importing into a new database
  > may not
  > reveal at first any problems. However the fact that
  > you did so IS
  > recorded.
  > ----- Original Message -----
  > To: Multiple recipients of list ORACLE-L
  > <ORACLE-L_at_fatcity.com>
  > Sent: Sunday, October 22, 2000 4:20 AM
  >
  >
  > > Hi everyone,
  > >
  > > I am not sure if there are any people in this list
  > at this hour of the
  > day.
  > > But we are facing a terrible situation here on the
  > production system. And
  > I
  > > will need some advice.
  > >
  > > For whatever reason, the production database
  > crashed with online redo log
  > > file corruption. Oracle support told me that there
  > is only two option:
  > > 1) restore and recover the database using the full
  > backup
  > > 2) force the database open with the hidden
  > paramter but HAVE TO export
  > the
  > > database and rebuild it afterward as the database
  > will NO LONGER under
  > > support license after the database open this way.
  > >
  > > We are currently performing a cold backup on the
  > database before we move
  > on
  > > to either option. I was thinking about several
  > different possible ways as
  > > well. But wondering if they are possible.
  > >
  > > 1) can I force the database open with that hidden
  > parameter, but instead
  > of
  > > rebuilding the whole database from export/import.
  > I just mount the
  > > database, change it to noarchivelog, do several
  > log switches, then change
  > > it back to archivelog? It is suppose to clear out
  > the corrupted online
  > redo
  > > log file
  > >
  > > Had anyone in the lists have some experience or
  > comment to share?
  > >
  > > Winnie
  > >
  > >
  > > --
  > > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.com
  > > --
  > > Author:
  > > INET: Winnie_Liu_at_infonet.com
  > >
  > > Fat City Network Services -- (858) 538-5051
  > FAX: (858) 538-5051
  > > San Diego, California -- Public Internet
  > access / Mailing Lists
  > >
  >

  ---

  
  > > 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).
  > >
  >
  > --
  > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.com
  > --
  > Author: Tom Pall
  > INET: tom_at_cdproc.com
  >
  > Fat City Network Services -- (858) 538-5051 FAX:
  > (858) 538-5051
  > San Diego, California -- Public Internet
  > access / Mailing Lists
  >

  ---

  
  > 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).
  >
  >
  >
  >
  > --
  > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.com
  > --
  > Author:
  > INET: Winnie_Liu_at_infonet.com
  >
  > Fat City Network Services -- (858) 538-5051 FAX:
  > (858) 538-5051
  > San Diego, California -- Public Internet
  > access / Mailing Lists
  >

  ---

  
  > 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).