Re: URGENT Recovery Question

Andreas,

I might need to say that you got a little mix up about Oracle recovery. You should re-visit the Oracle DBA menu for full detail - or you could worsen your situation unnecessary.

First, to answer yourlast question, Oracle will automatically perform instance recovery using online redologs on every startup-open. So not too much concern here.

However what you're heading on is media recovery which genearly will not include online redologs recovery (because you have to reset redologs on opening a media recovered database). The reason you are asked for a wrong redolog is likely because you are using a wrong CONTROL FILE. You have to use that one that was generated by "alter database backup controlfile ..." (when the DB was still alive) or otherwise you'll never get your database running again without data loss. (Too bad ?!)

Hope this helps.

Regards,

Andy

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