os 2000server
db oracle 9.2.0.1
测试dataguard(logical)
问题
logical standby database 已建立但我在primary database上做的改变没有在 logical standby 的database上实现。
logical database 上的状态数据:
SQL> select database_role from v$database;
DATABASE_ROLE
----------------
LOGICAL STANDBY
SQL> select * from v$logstdby_stats where name = 'coordinator state';
NAME
VALUE
---------------------------------------------------------------- --------------
coordinator state
APPLYING
SQL> select logstdby_id,type,status_code,status from v$logstdby;
LOGSTDBY_ID TYPE
STATUS_CODE STATUS
----------- ------------------------------ ----------- ---------------------
-1 COORDINATOR
16116 ORA-16116: 无可用工作
0 READER
16116 ORA-16116: 无可用工作
1 BUILDER
16116 ORA-16116: 无可用工作
2 PREPARER
16116 ORA-16116: 无可用工作
3 ANALYZER
16116 ORA-16116: 无可用工作
4 APPLIER
16116 ORA-16116: 无可用工作
5 APPLIER
16116 ORA-16116: 无可用工作
6 APPLIER
16116 ORA-16116: 无可用工作
7 APPLIER
16116 ORA-16116: 无可用工作
8 APPLIER
16116 ORA-16116: 无可用工作
SQL> select event_time,status_code,status from dba_logstdby_events;
EVENT_TIME
STATUS_CODE STATUS
------------------- ----------- -------------------------------------------------------------
2004/03/30 16:45:22 16111 ORA-16111: log mining and apply setting up
2004/03/30 16:58:29 16128 ORA-16128: User initiated shut down successfully completed
2004/03/30 16:58:55 16111 ORA-16111: log mining and apply setting up
2004/03/30 17:29:00 16128 ORA-16128: User initiated shut down successfully completed
2004/03/30 17:29:04 16111 ORA-16111: log mining and apply setting up
2004/03/31 14:42:59 16111 ORA-16111: log mining and apply setting up