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 -----
From: <Winnie_Liu_at_infonet.com>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Sent: Sunday, October 22, 2000 4:20 AM
Subject: Urgent! Online redo log files corruption
> 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).
Received on Sun Oct 22 2000 - 11:13:24 CDT
