Oracle-L: RE: _allow_resetlogs

From: Sujatha Madan <Sujatha.Madan_at_cmc.optus.net.au>
Date: Mon, 27 Jan 2003 17:43:53 -0800
Message-ID: <F001.0053BAD8.20030127174353@fatcity.com>

Ok... I have the tapes now so I don't have to bother...but would this scenario have been fixed by using the _allow_resetlogs_corruption parameter and following the associated steps????

Sorry for the bother

Sujatha

-----Original Message-----
Sent: Tuesday, 28 January 2003 11:14 AM
To: Multiple recipients of list ORACLE-L

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: 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
---------------------------------------------------------------------

RE: _allow_resetlogs_corruption