Manage and Monitor Standby Database

Stop data guard:

alter database recover managed standby database cancel;

Check DG:

select process, status, thread#, sequence#, block#, blocks from   v$managed_standby; 

check DB role

col db_unique_name format a10

select database_role, db_unique_name, open_mode, protection_mode, protection_level, switchover_status from v$database

DG standby proc

set time on

set lines 132

set pagesize 9999

col client_pid format a12

select pid, process, status, client_process, client_pid, thread#, sequence#, block#, blocks, delay_mins from v$managed_standby

;