备用数据库为何不应用主数据库的归档日志呢

显示全部楼层 · 2008-10-17 01:03:19

QL> SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME, APPLIED
2FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;
SEQUENCE# FIRST_TIME NEXT_TIMEAPP
---------- ------------ ------------ ---
166 27-MAR-0728-MAR-07NO
167 28-MAR-0728-MAR-07NO
168 28-MAR-0728-MAR-07NO
169 28-MAR-0728-MAR-07NO
170 28-MAR-0728-MAR-07NO
171 28-MAR-0728-MAR-07NO
172 28-MAR-0728-MAR-07NO
173 28-MAR-0728-MAR-07NO
174 28-MAR-0728-MAR-07NO
175 28-MAR-0729-MAR-07NO
176 29-MAR-0729-MAR-07NO
SEQUENCE# FIRST_TIME NEXT_TIMEAPP
---------- ------------ ------------ ---
177 29-MAR-0730-MAR-07NO
12 rows selected.
我的归档文件可以从主库传到备用库，可是为什么APP都是NO呢？要如何可以应用呢，

千问 · 2008-10-17 01:03:19

要看你的备用库处于什么样的打开方式呀

千问 · 2008-10-17 01:03:19

SQL>startup nomount pfile=’d:\oracle\product\initdgtest.ora’
SQL>alter database mount standby database;
SQL>alter database recover managed standby database disconnect from session;
以上操作后，还要其它的操作吗？

千问 · 2008-10-17 01:03:19

这个命令应该就开始apply log了阿

千问 · 2008-10-17 01:03:19

最初由 logjiang 发布
[B]QL> SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME, APPLIED
2FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;
SEQUENCE# FIRST_TIME NEXT_TIMEAPP
---------- ------------ ------------ ---
166 27-MAR-0728-MAR-07NO
167 28-MAR-0728-MAR-07NO
168 28-MAR-0728-MAR-07NO
169 28-MAR-0728-MAR-07NO
170 28-MAR-0728-MAR-07NO
171 28-MAR-0728-MAR-07NO
172 28-MAR-0728-MAR-07NO
173 28-MAR-0728-MAR-07NO
174 28-MAR-0728-MAR-07NO
175 28-MAR-0729-MAR-07NO
176 29-MAR-0729-MAR-07NO
SEQUENCE# FIRST_TIME NEXT_TIMEAPP
---------- ------------ ------------ ---
177 29-MAR-0730-MAR-07NO
12 rows selected.
我的归档文件可以从主库传到备用库，可是为什么APP都是NO呢？要如何可以应用呢， [/B]

SQL>alter database recover managed standby database cancel;
SQL>recover automatic standby database;
看看

千问 · 2008-10-17 01:03:19

用楼上兄弟的方式手工应用完后再开。
之前有遇到过，手工删除archive log后，再copy回来，只能手工应用后，才能自动应用archive log