RE: dataguard and operators
Date: Tue, 22 Sep 2015 07:16:25 -0500
Message-ID: <06d201d0f530$80c00e90$82402bb0$_at_multiservice.com>
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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ingrid Voigt Sent: Tuesday, September 22, 2015 6:58 AM To: howard.latham_at_gmail.com; oracle-l_at_freelists.org 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_at_gmail.com> An: ORACLE-L <oracle-l_at_freelists.org> 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
--
http://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.
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Sep 22 2015 - 14:16:25 CEST