[oracle@ora12c admin]$ dgmgrl sys/oracle@db12g DGMGRL for Linux: Release 12.2.0.1.0 - Production on Tue May 23 16:47:58 2017 Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved. Welcome to DGMGRL, type "help" for information. Connected to "db12g" Connected as SYSDBA. DGMGRL> switchover to db12g_s Performing switchover NOW, please wait... Operation requires a connection to database "db12g_s" Connecting ... Connected to "db12g_s" Connected as SYSDBA. New primary database "db12g_s" is opening... Operation requires start up of instance "db12g" on database "db12g" Starting instance "db12g"... ORACLE instance started. Database mounted. Database opened. Connected to "db12g" Switchover succeeded, new primary is "db12g_s" SQL> select database_role from v$database; DATABASE_ROLE ---------------- PHYSICAL STANDBY

SQL> select process,status,sequence# from v$managed_standby;

PROCESS   STATUS        SEQUENCE#
--------- ------------ ----------
ARCH      CONNECTED             0
ARCH      CONNECTED             0
ARCH      CLOSING               1
ARCH      CLOSING               2
ARCH      CONNECTED             0
ARCH      CONNECTED             0
ARCH      CONNECTED             0
ARCH      CONNECTED             0
DGRD      ALLOCATED             0
DGRD      ALLOCATED             0
RFS       IDLE                  0

PROCESS   STATUS        SEQUENCE#
--------- ------------ ----------
MRP0      APPLYING_LOG          3
RFS       IDLE                  0
RFS       IDLE                  3

14 rows selected.