Re: _allow_resetlogs_corruption

Yes, but you would be required to rebuild the entire database via export. Oracle will not support a database opened with _allow_resetlogs_corruption for anything other than export.

Jared

On Monday 27 January 2003 17:43, Sujatha Madan wrote:
> 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: Jared Still
  INET: jkstill_at_cybcon.com

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