1 rows selected.
连接到主数据库并归档部分日志.
sql> alter system archive log current;
system altered.
sql> alter system archive log current;
system altered.
再查询一下dba_logstdby_log视图.
sql> alter session set nls_date_format = 'dd-mon-yy hh24:mi:ss';
session altered.
sql> select sequence#, first_time, next_time, dict_begin, dict_end
2 from dba_logstdby_log order by sequence#;
sequence# first_time next_time dic dic
---------- ------------------- ------------------- --- ---
22 23-11月-04 14:00:17 23-11月-04 14:26:58 no no
23 23-11月-04 14:26:58 23-11月-04 14:33:33 no no
2 rows selected.
(可以看到多出来一个新的归档日志)