Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Recover Instance Problem
I believe that Oracle just copies the redo log file to the archived file name. BMC's
DB-Log Master for Oracle can read both te on-line and the archived files. Of course,
it is possible that Oracle adds some kind of header while copying to the archive.
I also believe it is correct to apply the current redo log file after the archived files if you really want to get back to 'current'.
Michael Pelzelmeyer wrote:
> John P. Higgins wrote:
> >
> > I think you could:
> >
> > recover database until ___________ using backup controlfile
> >
> > _________ could be cancel, time or change
> >
> > If you were recovering to current:
> >
> > recover database until cancel using backup controlfile
> >
> > just type cancel when Oracle asks for a log sequence number beyond what was ever
> > created.
> >
> I used your solution in some recovery scenarios on test instances. As
> far as
> ARCHIVED redo logs are applied to the DB, there are no problems. But
> what's
> about the last redo log, the ONLINE redo log. Oracle accepts it too and
> the
> DB comes up. Is that correct? I don't know whether the ONLINE redo log
> is
> modified when its archived. Does someone know more about that?
> TIA
> Michael
Received on Thu Jun 18 1998 - 08:11:44 CDT