Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: _allow_resetlogs_corruption question ...

Re: _allow_resetlogs_corruption question ...

From: Domenic <domenicg_at_hotmail.com>
Date: 5 Oct 2004 07:27:18 -0700
Message-ID: <c7e08a19.0410050627.75e2824c@posting.google.com>


This was an experiment -- the restored datafiles were SCN consistent except one. Every once in a while I like to practice these stupid recovery scenarios.

Domenic.

bdbafh_at_gmail.com (Paul Drake) wrote in message news:<910046b4.0410042132.4bbdac8d_at_posting.google.com>...
> domenicg_at_hotmail.com (Domenic) wrote in message news:<c7e08a19.0410041327.698379d8_at_posting.google.com>...
> > Whenever I try doing a cancel based recovery using an old controlfile,
> > ie:
> >
> > recover database using backup controlfile until cancel;
> >
> > the database complains that file 1 is not consistent, even though
> > v$datafile and v$recover_file show consistent SCNs across the board
> > after the last archive log has been fed in.
>
> did you apply any archived redo logs during recovery, or did you just
> cancel?
>
> any chance that the system tablespace's datafile(s) was in backup mode
> from a hot backup?
>
> SQL> select * from v$backup where status='ACTIVE';
>
> > Before starting recovery, I did a shutdown abort and blew away the
> > online logs.
>
> perhaps renaming/moving them next time would be sufficient.
>
> > Is this error because it thinks there may be uncommitted
> > changes in the datafiles that need to be reversed by scanning the last
> > online log?
>
> logminer might provide some information.
> you could dump the current online redo log, if its still on the
> server's filesystem.
>
> > Of course _allow_resetlogs_corruption does the trick, but I was
> > wondering if my understanding of this is right or wrong.
>
> > Thanks in advance!
>
> > Domenic.
>
> -bdbafh
>
> ----------------------------------------------------------
> boycott kodak
> http://www.groklaw.net/article.php?story=20041003041632172
> ----------------------------------------------------------
Received on Tue Oct 05 2004 - 09:27:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US