Order of Oracle Data guard switch over steps.

All posts relating to Oracle database administration.

Moderator: Tim...

Order of Oracle Data guard switch over steps.

Postby shrinika » Fri Oct 05, 2012 7:05 pm

Tim, I would like to confirm the Oracle11g Data guard Switch over steps.

here are the switch over steps. what order we should run? Should we start on current primary first? or current standby first?
Any order is fine?

on current primary : make the current primary to standby
Code: Select all
CONNECT / AS SYSDBA
ALTER DATABASE COMMIT TO SWITCHOVER TO STANDBY;
if above command does not work, then,
alter database commit to switchover to PHYSICAL STANDBY WITH SESSION SHUTDOWN;


Standby : make the standby to primary

Code: Select all
SHUTDOWN IMMEDIATE;
STARTUP NOMOUNT;
ALTER DATABASE MOUNT STANDBY DATABASE;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
alter database recover managed standby database cancel;
alter database open;
alter database recover managed standby database using current logfile disconnect;
shrinika
Advisor
 
Posts: 255
Joined: Fri Jun 13, 2008 3:18 pm

Re: Order of Oracle Data guard switch over steps.

Postby Tim... » Sat Oct 06, 2012 8:03 am

Hi.

It's all explained in this article:

http://www.oracle-base.com/articles/11g ... switchover

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17935
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 7 guests

cron