RE: Urgent! Online redo log files corruption

From: Rajesh Dayal <Rajesh_at_ohitelecom.com>
Date: Sun, 22 Oct 2000 13:39:09 +0400
Message-Id: <10657.119918@fatcity.com>

Hi Winnie,

Another option could be to clear the online redolog files (in nomount/mount state). But you are very much likely to lose some (uncommitted) data...

I had done this once successfully to give a demo of Backup restore procedure where the Full cold backup was restored to a diff Machine and the backup didn't had online redolog files.

Of course you have to backup after opening the DB.

HTH,
Rajesh
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Winnie_Liu_at_infonet.com
Sent: Sunday, October 22, 2000 1:21 PM
To: Multiple recipients of list ORACLE-L 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.

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 - 04:39:09 CDT