Oracle 12c- Perform Dataguard Switchover Using DGMGRL Utility

Oracle 12c- Perform Dataguard Switchover Using DGMGRL Utility

[oracle@ip-10-0-1-12 ~]$ dgmgrl

DGMGRL for Linux: Release 12.2.0.1.0 - Production on Tue May 25 14:02:07 2021

Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.

Welcome to DGMGRL, type "help" for information.

DGMGRL> connect sys@india

Password:

Connected to "india"

Connected as SYSDBA.

DGMGRL

DGMGRL> edit database india set property StaticConnectIdentifier='(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.1.12)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=india)(INSTANCE_NAME=india)(SERVER=DEDICATED)))';

DGMGRL> edit database india_stby set property StaticConnectIdentifier='(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.1.37)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=india_stby)(INSTANCE_NAME=india_stby)(SERVER=DEDICATED)))';

[oracle@ip-10-0-1-12 ~]$ dgmgrl

DGMGRL for Linux: Release 12.2.0.1.0 - Production on Tue May 25 14:02:07 2021

Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.

Welcome to DGMGRL, type "help" for information.

DGMGRL> connect sys@india

Password:

Connected to "india"

Connected as SYSDBA.

DGMGRL>

DGMGRL>

DGMGRL>

DGMGRL> show configuration;

Configuration - india

  Protection Mode: MaxPerformance

  Members:

  india      - Primary database

    india_stby - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS   (status updated 48 seconds ago)

DGMGRL>

DGMGRL>

DGMGRL> switchover to india_stby

Performing switchover NOW, please wait...

Operation requires a connection to database "india_stby"

Connecting ...

Connected to "india_stby"

Connected as SYSDBA.

New primary database "india_stby" is opening...

Operation requires start up of instance "india" on database "india"

Starting instance "india"...

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORACLE instance started.

Database mounted.

Database opened.

Connected to "india"

Switchover succeeded, new primary is "india_stby"

DGMGRL>

DGMGRL>

DGMGRL>

DGMGRL>

DGMGRL> show configuration;

Configuration - india

  Protection Mode: MaxPerformance

  Members:

  india_stby - Primary database

    india      - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS   (status updated 28 seconds ago)

DGMGRL>

[oracle@ip-10-0-1-37 ~]$ !sq

sqlplus sys/sys@india_stby as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Tue May 25 14:05:53 2021

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> select name ,open_mode from v$database;

NAME      OPEN_MODE

--------- --------------------

INDIA     READ WRITE

SQL>

SQL> insert into hr.abc values(2,'From standby after primary');

1 row created.

SQL> commit;

Commit complete.

SQL>

On new standby 

=================

[oracle@ip-10-0-1-12 ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 12.2.0.1.0 Production on Tue May 25 14:06:28 2021

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> select name ,open_mode from v$database;

NAME      OPEN_MODE

--------- --------------------

INDIA     READ ONLY WITH APPLY

SQL>

SQL>

SQL> select * from hr.abc;

        ID NAME

---------- --------------------------------------------------

         1 A

SQL> /

        ID NAME

---------- --------------------------------------------------

         2 From standby after primary

         1 A

SQL>

SQL>

 alert log 

=================

Initiating a healthcheck...

05/25/2021 14:02:50

Forwarding CTL_SWITCH operation to member india for processing

Updated broker configuration file available, loading from "/u01/app/oracle/product/12.2.0/dbhome_1/dbs/dr2india_stby.dat"

05/25/2021 14:02:51

Switchover processing to this database has started

Notifying Oracle Clusterware to prepare target standby database for switchover

05/25/2021 14:03:01

Updated broker configuration file available, loading from "/u01/app/oracle/product/12.2.0/dbhome_1/dbs/dr1india_stby.dat"

New primary database after switchover

Informing client: OPENING instance 'india_stby' of database 'india_stby'

Informing client: STARTUP instance 'india' of database 'india'

Switchover completed, notifying client

Proceeding with buildup after switchover...

Notifying Oracle Clusterware to buildup the primary database after switchover

Opening database after Switchover

05/25/2021 14:03:04

Evaluating archivelog destinations for switchover

SWITCHOVER TO india_stby completed successfully, new primary database is india_stby