Re: URGENT Recovery Question

Hmm...Strange problem ! According to the book, Oracle should have detected that suggested change is in the online redo logs and applied them automatically. This would be part of the crash recovery rather than media recovery. Seems like only option now is to perform a log switch and give it the log file needed. However you might need to CANCEL the recovery and perform a backup at this point, before continuing. Let us know what happens please.

Roy Varghese

Andreas Hess wrote in message <01bd1f5c$f641c680$300610ac_at_trahe>...
>
>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 Mon Jan 12 1998 - 00:00:00 CST