Shulou(Shulou.com)06/01 Report--

= operation and maintenance SQL

-- View switch status

Select switchover_status from v$database

-- View database status

Set lin 200 pages 100

Select current_scn,protection_mode,database_role,force_logging,open_mode,switchover_status from v$database

-- View process status

Set lin 200 pages 200

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

-- check whether the slave database applies the log

Select sequence#,applied,standby_dest from gv$archived_log

Select * from (select sequence#,applied,standby_dest from v$archived_log order by sequence# asc) where rownum

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.