Re: 9i Standby Database & Production Online Redo

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Wed, 17 Sep 2003 12:25:00 GMT
Message-ID: <woY9b.108256$bo1.12077@news-server.bigpond.net.au>

"Tom K" <tomk_at_projectx.com.au> wrote in message news:b6b81b29.0309162032.7df0dfd5_at_posting.google.com...
> 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?
>

Hi Tom,

Been there, done that :)

There are a number of things you could do.

As it's a catastrophic failure scenario, possibly the easiest thing would be to cancel managed recovery (assuming you're currently in managed recovery mode) and simply perform a "manual" recovery: note that Oracle could also then "look" for the redo log in a different location, the archive_log_dest_n location rather than the standby_archive_dest.

Good Luck

Richard Received on Wed Sep 17 2003 - 07:25:00 CDT