Oracle-L: Re: _allow_resetlogs

From: <Jared.Still_at_radisys.com>
Date: Mon, 27 Jan 2003 17:48:45 -0800
Message-ID: <F001.0053BAF5.20030127174845@fatcity.com>

If you use _allow_resetlogs_corruption, I believe that Oracle support will require you to rebuild the entire database if you wish to have support in the future. See MetaLink Doc 166181.1 for that.

They will not support your database for anything other than an export used to rebuild the database.

It sounds like a bad idea in light of the fact that you do have the log file on tape. I would suggest waiting for the tape.

Jared

Sujatha Madan <Sujatha.Madan_at_cmc.optus.net.au> Sent by: root_at_fatcity.com
01/27/2003 04:13 PM
Please respond to ORACLE-L

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        _allow_resetlogs_corruption

Hi,

DB: 8.1.5.0.0
O/S: Solaris 2.7

This database is the recovery catalog database. It is in noarchivelog mode and is backed up cold.
Unfortunately, something happened on Thursday and the database does not startup. I receive the following errors:

SQL> startup
ORACLE instance started.

Total System Global Area 25410960 bytes

Fixed Size                    64912 bytes
Variable Size               8388608 bytes
Database Buffers           16777216 bytes
Redo Buffers                 180224 bytes

Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

SQL> recover database;

ORA-00283: recovery session canceled due to errors
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 78 change 1113558 time 01/24/03

01:51:40
ORA-00312: online log 2 thread 1: '/nsr/u02/oradata/RCVCATDB/log2a.rdo'

SQL> recover database until time '2003-01-24:00:00:00'; ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1: '/nsr/u02/oradata/RCVCATDB/system01.dbf'

Is this the "perfect" time where I can use the _allow_resetlogs_corruption parameter??? I know I have the cold backups ... but they have sent the tapes
off site and it is going to take a while for the tapes to be located and sent to the data center and we need this catalog database up and running asap.

Thanks
Sujatha

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Sujatha Madan
INET: Sujatha.Madan_at_cmc.optus.net.au

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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

Author:
INET: Jared.Still_at_radisys.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

Re: _allow_resetlogs_corruption