Hi Winnie,
I did step 2 once : open the db with the hidden
parameters, export and rebuild the db and import the
data back. We had some glitches in the data.
Good luck!
Stephane
- Winnie_Liu_at_infonet.com a écrit : > 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).
>
Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com
Do You Yahoo!?
Received on Mon Oct 23 2000 - 02:00:02 CDT
