Re: URGENT Recovery Question

This may be a little late, but...

I was testing backup on a Netware file server and received something similar to this. Oracle was asking for a archived redo log that was not there. After a little investigation, I realized that Oracle was asking for one of the online redo logs. I have two with the database. Either a log switch occured and the redo log was not archived yet, or it is the current redo log. I never go that far. Anyway, I got solved the problem by entering:

alter database recover logfile 'sys:oranw732\database\redo01a.log'

Oracle applied the log and I was able to open the database.

I would be interested if anyone knows whether this is the current redo log or one that was not archived yet.

Jim Anderson

> Andreas Hess wrote:
> >
> > Hi All
> >
> > I have a problem - production is down - and help will be appreciated.
> >
> > Oracle 7.1.6 on AIX.
> >
> > - The system datafile needed recovery.
> > - Applied all available archived redo logs
> > ( RECOVER DATABASE UNTIL CANCEL - Then entered AUTO )
> > - Recovery asks for archived log file 2845 - last available
> > archived log file was 2844 !
> > - Queried the v$log_history table - yep - last available arc is 2844
> > - Change no 2203026 required to recover datafile
> > - Queried the online redo logs - current log starts at change number
> > 2203026 !
> > - Q: Can I do a log switch to archive the current online redo log and
> > recover
> > the last archived log and might this sort out my problem ?
> > - Q2: Shouldn't Oracle detect the online redo log files ?
> >
> > Thanks in advance,
> >
> > Andreas
Received on Wed Jan 14 1998 - 00:00:00 CST