Re: 9i Standby Database & Production Online Redo

From: Jeroen Gouma <jeroen.leest.dit.niet_at_hccnet.nl>
Date: Wed, 17 Sep 2003 20:32:03 +0200
Message-ID: <11ahmvsu2785qb7810dbh7r9nn86jdb3sd@4ax.com>

Tom,

As long as your standby database is in standby mode, just put the archive-log files in the same directory as the normaly are stored by yout primary database. The standby-database will automaticly apply them.

After applying all the archive-log files, shutdown the standby database and restart it in primary role (I have a different init.ora file for this)

Regards,

Jeroen

On 16 Sep 2003 21:32:18 -0700, tomk_at_projectx.com.au (Tom K) wrote:

>I have a quick question on Physical Standby Databases (the 9i
>version). I have configured a physical standby database (STDBY) in
>Maximum Performance mode. All the archive logs are being transported
>from production (PROD) to STDBY.
>
>In the event of a catastrophic failure on PROD, given that I can save
>the online redo logs from PROD, and I copy them to the STDBY node, how
>can I "feed" then into STDBY?
>
>I have tried to register the redo by renaming them to arc_985.log, but
>this has not worked.
>
>Any ideas? Has anyone been able to do this?
>
>Cheers
>Tom K
Received on Wed Sep 17 2003 - 13:32:03 CDT