Re: _ALLOW_RESETLOGS_CORRUPTION = TRUE

try to issue RECOVER DATABASE and when oracle prompts for the logs provide the full path and full file name to the online redo logs on at a time. In this manner we can trick oracle to read the on line redo logs, hopefully all of your changes in are in the redo logs, otherwise, email Mike for that paper on how to pop open the db.

steve

ocpdba_at_yahoo.com (Luis Moreno Campos) wrote in message news:<ab246eda.0206190940.5ee89bdd_at_posting.google.com>...
> Failure Scenario:
> Disk damaged until a point that we can't figure out. All datafiles,
> redo logs and control files are there. I'm operating in NOARCHIVELOG
> mode.
> Steps taken:
> 1. Startup - can't open database unless with RESETLOGS
> 2. ALTER DATABASE OPEN RESETLOGS gives a message saying that database
> needs recovery using backup controlfile
> 3. RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE gives the
> following messages:
> 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: '/ora2/oradata/URS/urs_sys01.dbf'
>
> 4. Somewhere in METALINK I saw that if this happens the following line
> should be added to the init.ora:
> _ALLOW_RESETLOGS_CORRUPTION = TRUE
>
> 5. I did it all over again now with this hidden parameter set to true
> and my alert.log has given me 2 ORA-600 so far, the SVRMGRL process is
> taking 99.9% of machine resources, and controlfiles are beeing touched
> or so it seems by their date.
>
> 6. I've waited more than I think I should wait, and now what do I do?
> Kill the process, or what?
>
> Has anyone ever been throught the same situation (or similar)???
>
> I have Linux Red Hat 7.0, with Oracle 8.1.6.1.0 on it, and my 600
> datafiles sum up to 265 GB.
>
> NOARCHIVE MODE, no offline backup... just my pens in my hands!
>
> Help me out if you can.
>
> Luis M. Campos
> ocpdba_at_yahoo.com.nospam
Received on Wed Jun 26 2002 - 16:50:44 CDT