Re: URGENT Recovery Question

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

Why did you do a cancel-based recovery? A complete recovery 'alter database
recover database' does use also the necessary online-redo log. (I tried this unter NT with an 7.3.2 oracle)
yours sincerely,
Michael Received on Tue Jan 13 1998 - 00:00:00 CST