ORACLE 12C物理备库archive log list 显示为0
1.问题描述
12C 物理Standby的 archive log list 情况如下:
所谓的ADG,只不过就是在备库,应用redo log 的同事,避免资源的浪费,(10g之前的dg备库必须处于Mount状态,才可以接收应用redo log),11g增加的ADG的功能支持,备库处于open状态(默认为read only模式),同时可以接收并应用redo log。
12C针对物理备库redo log做出了调整,可以通过以下SQL查看:
select GROUP#,STATUS from v$log;
2.解决方案:
Do not use ARCHIVE LOG LIST on standby side.
可以使用以下命令查看:
Primary: SQL> select thread#, max(sequence#) "Last Primary Seq Generated"
from v$archived_log val, v$database vdb where val.resetlogs_change# = vdb.resetlogs_change#
group by thread# order by 1;
PhyStdby:SQL> select thread#, max(sequence#) "Last Standby Seq Received"
from v$archived_log val, v$database vdb
where val.resetlogs_change# = vdb.resetlogs_change#
group by thread# order by 1;
PhyStdby:SQL>select thread#, max(sequence#) "Last Standby Seq Applied"
from v$archived_log val, v$database vdb
where val.resetlogs_change# = vdb.resetlogs_change#
and val.applied in ('YES','IN-MEMORY')
group by thread# order by 1;