[prev in list] [next in list] [prev in thread] [next in thread] 

List:       veritas-ha
Subject:    RE: [Veritas-ha] Clustering a primary and standby database... any
From:       Jim Senicka <jsenicka () veritas ! com>
Date:       2001-10-12 19:10:12
[Download RAW message or body]

Darren,
you are on the right track.
We have come to the same conclusions to run a SharePlex copy inside
a cluster.
You need an SQL script to change the database instance name.


-----Original Message-----
From: Darren Dunham [mailto:ddunham@taos.com]
Sent: Friday, October 12, 2001 11:36 AM
To: veritas-ha@mailman.eng.auburn.edu
Subject: Re: [Veritas-ha] Clustering a primary and standby database...
anyone?


> 
> Hi Darren,
> 
> I am slightly confused.  What if you can get VCS to work without any
> problems under your configuration and the node running primary database
> dies, VCS will try to failover (unless you set AutoFailOver to 0) and see
> that an instance is already running.  (In fact, Oracle will not come up
even
> outside VCS control as database with the same SID is running on the node).
> 
> Can you not give a different name to the ORACLE_SID on the other node
(keep
> the db_name same)?  

That seems to be the trick.  Initially, our DBA said that it wouldn't be
possible, but after trying some things he got it to work.  So now, we
can start the standby database with a different SID.  That does keep all
the VCS monitors happy.

We're not done yet, but things look promising now.  :-)

-- 
Darren Dunham                                           ddunham@taos.com
Unix System Administrator                    Taos - The SysAdmin Company
Got some Dr Pepper?                           San Francisco, CA bay area
          < How are you gentlemen!! Take off every '.SIG'!! >
_______________________________________________
Veritas-ha maillist  -  Veritas-ha@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-ha

[prev in list] [next in list] [prev in thread] [next in thread]