DGMGRL>  SHOW DATABASE VERBOSE 'prim';

Database - prim

  Role:               PRIMARY
  Intended State:     TRANSPORT-ON
  Instance(s):
    prim

  Properties:
    DGConnectIdentifier             = 'prim'
    ObserverConnectIdentifier       = ''
    FastStartFailoverTarget         = ''
    PreferredObserverHosts          = ''
    LogShipping                     = 'ON'
    RedoRoutes                      = ''
    LogXptMode                      = 'ASYNC'
    DelayMins                       = '0'
    Binding                         = 'optional'
    MaxFailure                      = '0'
    ReopenSecs                      = '300'
    NetTimeout                      = '30'
    RedoCompression                 = 'DISABLE'
    PreferredApplyInstance          = ''
    ApplyInstanceTimeout            = '0'
    ApplyLagThreshold               = '30'
    TransportLagThreshold           = '30'
    TransportDisconnectedThreshold  = '30'
    ApplyParallel                   = 'AUTO'
    ApplyInstances                  = '0'
    StandbyFileManagement           = ''
    ArchiveLagTarget                = '0'
    LogArchiveMaxProcesses          = '0'
    LogArchiveMinSucceedDest        = '0'
    DataGuardSyncLatency            = '0'
    LogArchiveTrace                 = '0'
    LogArchiveFormat                = ''
    DbFileNameConvert               = ''
    LogFileNameConvert              = ''
    ArchiveLocation                 = ''
    AlternateLocation               = ''
    StandbyArchiveLocation          = ''
    StandbyAlternateLocation        = ''
    InconsistentProperties          = '(monitor)'
    InconsistentLogXptProps         = '(monitor)'
    LogXptStatus                    = '(monitor)'
    SendQEntries                    = '(monitor)'
    RecvQEntries                    = '(monitor)'
    HostName                        = 'test.learnomate.org'
    StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test.learnomate.org)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=prim_DGMGRL)(INSTANCE_NAME=prim)(SERVER=DEDICATED)))'
    TopWaitEvents                   = '(monitor)'
    SidName                         = '(monitor)'

  Log file locations:
    Alert log               : /data/app/oracle/diag/rdbms/prim/prim/trace/alert_prim.log
    Data Guard Broker log   : /data/app/oracle/diag/rdbms/prim/prim/trace/drcprim.log

Database Status:
SUCCESS

DGMGRL>  SHOW DATABASE 'stand';

Database - stand

  Role:               PHYSICAL STANDBY
  Intended State:     APPLY-ON
  Transport Lag:      0 seconds (computed 0 seconds ago)
  Apply Lag:          0 seconds (computed 1 second ago)
  Average Apply Rate: 0 Byte/s
  Real Time Query:    OFF
  Instance(s):
    stand

Database Status:
SUCCESS

DGMGRL> VALIDATE DATABASE 'prim';

  Database Role:    Primary database

  Ready for Switchover:  Yes

  Flashback Database Status:
    prim:  Off

  Managed by Clusterware:
    prim:  NO
    Validating static connect identifier for the primary database prim...
    The static connect identifier allows for a connection to database "prim".



DGMGRL> VALIDATE DATABASE 'stand';

  Database Role:     Physical standby database
  Primary Database:  prim

  Ready for Switchover:  Yes
  Ready for Failover:    Yes (Primary Running)

  Flashback Database Status:
    prim :  Off
    stand:  Off

DGMGRL> switchover to 'stand';
Performing switchover NOW, please wait...
Operation requires a connection to database "stand"
Connecting ...
Connected to "stand"
Connected as SYSDBA.
New primary database "stand" is opening...
Operation requires start up of instance "prim" on database "prim"
Starting instance "prim"...
Connected to an idle instance.
ORACLE instance started.
Connected to "prim"
Database mounted.
Connected to "prim"
Switchover succeeded, new primary is "stand"

DGMGRL> show configuration

Configuration - prim

  Protection Mode: MaxPerformance
  Members:
  stand - Primary database
    prim  - Physical standby database

Fast-Start Failover:  Disabled

Configuration Status:
SUCCESS   (status updated 12 seconds ago)