Re: _ALLOW_RESETLOGS_CORRUPTION = TRUE

Make sure your datafiles aren't in backup mode. I realize you have said that you are in noarchive mode so technically you shouldn't be able to put them in backup mode, but who knows. I have a paper on using this parameter if you would like it email me.

Mike Ault

"K Gopalakrishnan" <kaygopal_at_yahoo.com> wrote in message news:<3d10dbb7_at_news.mhogaming.com>...
> Hi:
>
> I guess you are getting the ORA-600 [2662]. In this case you need to bump
> the SCNs to higher numbers to open the database. This happens because of the
> SCN mismatch in the system tablespace and other tablespaces. You need to
> trace the instance recovery using the event 10015 and work accordingly.
>
>
> Best Regards,
> K Gopalakrishnan
> Bangalore, INDIA
>
>
> "Luis Moreno Campos" <ocpdba_at_yahoo.com> 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 Fri Jun 21 2002 - 06:44:29 CDT