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
