Re: Automated standby - swapping roles

From: Sybrand Bakker <sybrandb_at_hccnet.nl>
Date: Fri, 09 Jul 2004 20:22:09 +0200
Message-ID: <3gote09pcavs3334cl0g19l7qn89cm3lqr@4ax.com>

On 9 Jul 2004 07:29:27 -0700, seismo_at_elvis.com (B. Jones) wrote:

>I was thinking that I could just export the database from server2 to
>server1, build my standby controlfile from server2 and ftp to server1.
>Will this work at all?
>Ideas appreciated.

No. You would need to make a *hot* backup, bring the files over to the former primary server and recover.

In fact RMAN can do this quite nicely for you. It is described in the Oracle 8.1.7 documentation addendum.

--
Sybrand Bakker, Senior Oracle DBA

Received on Fri Jul 09 2004 - 13:22:09 CDT