Re: dataguard and operators

  • From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
  • To: nmjamaleddin@xxxxxxxxxxxxxxxx
  • Date: Tue, 22 Sep 2015 07:50:01 -0500

If properly configured, data guard broker is absolutely the way to go. The
commands are simply 'switchover to standbyname;', 'failover to standbyname;'
I don't have a good email here at the office, but I have doc I put together on
this that I can send this evening if you want.

Sent from my iPhone

On Sep 22, 2015, at 7:16 AM, Nabil Jamaleddin <nmjamaleddin@xxxxxxxxxxxxxxxx>
wrote:

1st level support doing a DG switchover….RAC might be a better solution. And
I am pretty sure that if I was the DBA I would want to be awake for this
unless 1st level support really knows what they are doing, but if they did,
would they still be 1st level support?



Performing a Database Switchover. A switchover provides the ability for the
primary to go back and forth


-- On Primary Database
CONNECT / AS SYSDBA
ALTER DATABASE COMMIT TO SWITCHOVER TO STANDBY;
SHUTDOWN IMMEDIATE;
STARTUP NOMOUNT;
ALTER DATABASE MOUNT STANDBY DATABASE;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;



On the original standby database issue the following commands to convert
standby database to primary
CONNECT / AS SYSDBA
ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;
SHUTDOWN IMMEDIATE;
STARTUP;



OR can do a failover, but this is not as forgiving as a switchover.



Failover. Just like it sounds, failover because the primary is not
responding.
--On the standby database
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH;
ALTER DATABASE ACTIVATE STANDBY DATABASE;









From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Ingrid Voigt
Sent: Tuesday, September 22, 2015 6:58 AM
To: howard.latham@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Aw: dataguard and operators

Hi,

I'd like to second this request. My company is currently introducing 7x24
service hours
for the first level support people, they are supposed to be able to solve as
many
things as possibly using critical problem checklists without waking up the
DBAs.
This will include general database troubleshooting and DG switchover (we are
still
fighting...)

Thanks
Ingrid Voigt


Gesendet: Dienstag, 22. September 2015 um 12:10 Uhr
Von: "Howard Latham" <howard.latham@xxxxxxxxx>
An: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
Betreff: dataguard and operators
Oracle 11 Redhat 4E

My boss wants scripts /instructions so 'any fool ' can do a dataguard
switchover. I think that's hard if not impossible as you can't
predict what is going to happen How many of you have successfully
handed this over to an operator? And if you have can I see example
scripts please?

--
Howard A. Latham
--
//www.freelists.org/webpage/oracle-l


-- //www.freelists.org/webpage/oracle-l

------------------------------------------------------------------
This email is intended solely for the use of the addressee and may
contain information that is confidential, proprietary, or both.
If you receive this email in error please immediately notify the
sender and delete the email.
------------------------------------------------------------------

Other related posts: