| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: _allow_resetlogs_corruption question ...
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
 |
 |