sql> alter system archive log current;----对当前日志进行归档,启动远程归档.
检查logical standby database
在建立好logical standby database后,log transport service 和 log apply service服务也都启动.需要检查一下日志是否正由主数据库传到备用数据库并apply.要做到这个目的,用下面的步骤来做.
检查日志是否已经被注册到logical standby database中.连接到备用数据库并查询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
