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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
