selectlog_mode,open_mode,database_rolefromv$database;--查看dataguard主备库状态selectstatusfromv$instance;--查看数据库状态alterdatabaserecovermanagedstandbydatabasecancel;--取消日志应用alterdatabaserecovermanagedstandbydatabaseusingcurrentlogfiledisconnect;--备库开启实时应用selectsequence#,appliedfromv$archived_logorderbysequence#;--备库若全为yes则表明standby库已经实时复制了alterdatabaserecovermanagedstandbydatabasedisconnectfromsession;--备库mount应用日志altersystemswitchlogfile;--主库切换日志--启停dg主库altersystemsetlog_archive_dest_state_2='defer';lsnrctlstopshutdownimmediatestartupaltersystemsetlog_archive_dest_state_2='enable';--备库停止alterdatabaserecovermanagedstandbydatabasecancel;shutdownimmediate--备库开启startupmount--启动到mount状态alterdatabaserecovermanagedstandbydatabasedisconnectfromsession;--启动日志应用主备执行archiveloglist看是否同步，备库可执行select*fromv$archive_gap;看是否有延时altersystemswitchlogfile;--主库执行切换日志，看备库是否及时应用日志同步成功后，备库执行ALTERDATABASERECOVERMANAGEDSTANDBYDATABASECANCEL;--取消日志应用alterdatabaseopen;--将备库打开alterdatabaserecovermanagedstandbydatabaseusingcurrentlogfiledisconnect;--备库开启实时应用selectlog_mode,open_mode,database_rolefromv$database;--检查备库状态