ORACLE DG同步异常

若归档日志在同步，数据文件没有同步，可尝试如下方式解决：

1.select process,status,sequence# from v$managed_standby; (检查MRP进程在不，如不在，则没有应用归档，继续执行如下命令)

2.shutdown immediate;

3.startup mount;

4.alter database recover managed standby database disconnect from session;

5.alter database recover managed standby database cancel;

6.alter database open;

7.alter database recover managed standby database using current logfile disconnect from session;

8.select process,status,sequence# from v$managed_standby;

查看归档日志是否被应用：

select name,SEQUENCE#,APPLIED from v$archived_log order by sequence#;