Oracle 10g DG 状态检查和恢复同步

-- 主库 运行
SELECT MAX(sequence#) FROM v$archived_log;

-- 备库 运行
SELECT MAX(sequence#) FROM v$archived_log WHERE applied='YES';

-- 检查备库归档是否应用
SELECT name, sequence#, applied, completion_time FROM v$archived_log WHERE applied='NO' ORDER BY sequence# DESC;

-- 检查备库服务运行状态
SELECT process, status, sequence#, client_process FROM v$managed_standby;

-- 备库 强制重启恢复进程：
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;