Re: applying online redo log to standby db

First, please post the version of Oracle you are talking about as well as OS, so that the rest of may try to give some insight to your question.

To answer it, it really depends on the version. With 9i, you could have this setup in 'Instant Protection' mode, whereby I would worry about trying to apply online redo logs. That's because the updates happening to the primary database happen to the standby at the same time. The same is true for 'Guaranteed Protection'.

Now for 8i, from what I recall from postings on Metalink. Oracle Analysts have recommended that any unarchived redo log not be applied.  Plus, to just apply the archive logs that you have, activate the standby and open it.

HTH
Pete's

The comments or ideas from my post are mine and do not reflect the views of my employer or Oracle Corporation.

cgrammes_at_gmx.net (Carsten Grammes) wrote in message news:<3e535767.74340405_at_gandalf.dialogika.de>...
> Hello world,
>
> I have a question on promoting a standby database to a primary one.
> Say I have a standby database with all archived redo logs running in
> automatic recover. Now the primary database crashes but I still have
> the possibility to access the filesystem and copy the online redo logs
> to the standby machine.
>
> What should I then do with those, how to apply them to the standby
> database?
>
> Thanks,
> Carsten.
>
> ---
> I want to die peacefully in sleep like my grandfather.
> Not screaming in terror like his passengers!
Received on Wed Feb 19 2003 - 10:39:33 CST