On Feb 9, 9:50 pm, fae..._at_tampabay.rr.com wrote:
> Oracle 9.2.0.6 running on Sun Solaris 10
> Hi, I have a production primary server replicating to two standby
> servers. I want to break replication on one of the two standby
> servers for the purpose of having a database that is a copy of the
> production primary database open for read/write operations. The copy
> of the primary will never be a part of the data guard configuration
> anymore. I have done this failover procedure before on a 'proof of
> concept' environment following the documentation and it worked very
> well. However at that time the primary was shut down with a 'shutdown
> abort' to simulate a real failure. But this time the production
> server must be available at all times.
>
> My question is this. When I execute the commands for the failover
> operation on one of the secondary servers, must the primary server be
> down? I am worried there might be some communication from the
> secondary to the primary during the failover commands causing the main
> production instance to shut down. I hope I made sense, I am very
> paranoid.
>
> -- Steve
For what you describe (I want to have a copy of a production database)
Rman duplicate database would have sufficed. No standby database
required.
The main feature of a failover (as opposed to switchover) is that it
occurs when the primary database has crashed.
Time to rearchitecture your solution, and to create your copy/
duplicate using RMAN, instead of misusing Dataguard.
--
Sybrand Bakker
Senior Oracle DBA
Received on Tue Feb 13 2007 - 03:47:40 CST
