当前位置 博文首页 > LuciferLiu_DBA：ORACLE 12C物理备库archive log list 显示为0
12C 物理Standby的 archive log list 情况如下：
ADG是可以正常同步的，但是备库执行 archive log list 时显示都为 0，因此比较好奇，于是查询mos发现：
参考MOS文档：Archive Log List Showing 0 At Standby, But Standby Is Completely In Sync With Primary! (Doc ID 2041137.1)?? ?
12C针对物理备库redo log做出了调整，可以通过以下SQL查看：
select GROUP#,STATUS from v$log;12C：
?
11G：
解决方案：
?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;?
