Re: Urgent! Online redo log files corruption

Hi Tom

Could you show any example, any details? I think that even licence policy is a paper agreement only and there are no such internal program checks. Are you talking about additional 'direct internal logs' which could show dba's actions? Or you meant some oblique data which enable to determine exact sequence of unsupported steps?

Thanks

Ed

> 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
Received on Sun Oct 22 2000 - 14:17:47 CDT