select inst_id,thread#,sequence#,status
from gv$log
where status=’CURRENT’
order by inst_id,thread#,sequence#
/
select * from v$log where status = ‘current’;
select * from gv$managed_standby where process=’MRP0′;

select inst_id,status from gv$instance
/
select process, client_process, sequence#, status from gv$managed_standby
/
select protection_mode,protection_level,database_role as role,switchover_status from gv$database
/