Re: Recover the online redologs

akush wrote:

> Hi !
>
> i evaluate what to do when the oracle server crashes and try to figure
> out what to to with the online redo logs.

Nothing. By definition, the control files already know where to find the online logs, and therefore they are never prompted for during recovery.

> its not a problem to recover
> to database with the backups i have to a new fresh oracle instance. but
> it recovers only to the last archive log.

No, it *prompts* you only to the last archive log, but it then goes off automatically to find the contents of the online logs. It doesn't prompt you for them, because they can only be where the control file knows them to be. Unlike the archive logs, which can be moved anywhere you feel like once they've been written.

> but what is with the online
> redo logs? Is there are mechanism that checks if the online redo log is
> ok and recovers it?

Yes. It's called database and instance recovery.

> The only way to bringt the database online is to
> type in rman: alter database open RESETLOGS but this will create new
> online redologs and deletes the old if i had them copies from the
> backup. So my question: how do i recover the online redo logs?

It must be something in the air.

You *don't* recover online redo logs. Recovery means 'roll forward in time, replaying transactions'. You do that to data files, not redo logs. Logs are the source of the information needed to recover data files, but they don't get recovered themselves.

If you have a specific recovery scenario, then post it. But there's too much vagueness here to give any meaningful reply. The RESETLOGS option is an option of last resort, and it is unlikely that you will either need or want to use it.

Regards
HJR
> thk for help
> akush
Received on Thu Sep 02 2004 - 16:50:33 CDT