RE: RAC One Node - Instances not open at the same time!
- From: "Ethan Post" <post.ethan@xxxxxxxxx>
- To: <martin.klier@xxxxxxxxxxxxxxxxx>, "'Martin Berger'" <martin.a.berger@xxxxxxxxx>
- Date: Mon, 3 Jul 2017 09:22:22 -0500
2 cents
My recommendation would be to set up an alert that opens ticket, sends
email/message etc…when two instances are running with an explanation of the
reasons both should not be open unless the potential for problems is truly high
risk issue.
The “trigger” solution is good but if you are in a high turnover environment,
moving to cloud someday, cloning, replicating system, doing upgrades etc…there
is a chance this will come back to bite someone someday. It isn’t obvious
enough, whereas the alert would be very obvious.
So if you have big data/job corruption issue then it needs to be enforced
strictly, otherwise go with an notify solution.
Thanks
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On ;
Behalf Of Martin Klier - Performing Databases GmbH
Sent: Monday, July 3, 2017 5:53 AM
To: Martin Berger <martin.a.berger@xxxxxxxxx>
Cc: Oracle-L oracle-l <oracle-l@xxxxxxxxxxxxx>
Subject: Re: RAC One Node - Instances not open at the same time!
Martin,
sounds very cool. Thanks!
--
Martin Klier | Performing Databases GmbH
Managing Partner | Senior DB Consultant
Oracle ACE
martin.klier@xxxxxxxxxxxxxxxxx <mailto:martin.klier@xxxxxxxxxxxxxxxxx> |
https://www.performing-databases.com
_____
Von: "Martin Berger" <martin.a.berger@xxxxxxxxx
<mailto:martin.a.berger@xxxxxxxxx> >
An: "Martin Klier" <martin.klier@xxxxxxxxxxxxxxxxx
<mailto:martin.klier@xxxxxxxxxxxxxxxxx> >
CC: "Oracle-L oracle-l" <oracle-l@xxxxxxxxxxxxx <mailto:oracle-l@xxxxxxxxxxxxx>
Gesendet: Freitag, 30. Juni 2017 14:32:00
Betreff: Re: RAC One Node - Instances not open at the same time!
Hi Martin,
as this is an open discussion what's about this concept:
you write a startup trigger which immediately set
alter system enable restricted session;
then it spools gv$instance until it's sure the other instance is gone,
at the end do
alter system disable restricted session;
that's maybe not a very elegant method, but it might solve your request?
(everything is untested right now on my side)
Martin
2017-06-30 13:22 GMT+02:00 Martin Klier - Performing Databases GmbH
<martin.klier@xxxxxxxxxxxxxxxxx <
mailto:martin.klier@xxxxxxxxxxxxxxxxx> >:
Why? It's an open concept discussion, no system was configured yet.
--
Martin Klier | Performing Databases GmbH
Managing Partner | Senior DB Consultant
Oracle ACE
martin.klier@xxxxxxxxxxxxxxxxx <
mailto:martin.klier@xxxxxxxxxxxxxxxxx> |
https://www.performing-databases.com
_____
Von: "Mladen Gogala" <gogala.mladen@xxxxxxxxx <
mailto:gogala.mladen@xxxxxxxxx> >
An: oracle-l@xxxxxxxxxxxxx <
mailto:oracle-l@xxxxxxxxxxxxx>
Gesendet: Freitag, 30. Juni 2017 00:21:30
Betreff: Re: RAC One Node - Instances not open at the same time!
On 06/29/2017 07:24 AM, Martin Klier - Performing Databases GmbH wrote:
Hi Listers,
when running Oracle RAC One Node, is there a way to avoid both instances being
open at the same time?
Background:
I have an application that's by no way ready for RAC (using dbms_jobs and much
more). But they want to use the benefits of One Node for operating the cluster.
All that's needed is a failover cluster.
Please post the output of srvctl config db -d <DB name>.
--
Mladen Gogala
Oracle DBA
Tel: (347) 321-1217
Other related posts:
