关于Logical Standby
刚刚把试验平台上的Physical Standby改成了Logical Standby，照着官方文档作的，备用日志组也加了，
SQL APPLY也作了，但是查看备库，主库上的数据没有在备库上重作出来，
在主库执行 alter system switch logfile ;
查看备库上的alert log,发现日志已经发送过来了，Mining也执行了，
下面是alter日志的内容，
RFS LogMiner: Client enabled and ready for notification
Fri Dec 28 12:36:40 2007
Primary database is in MAXIMUM PERFORMANCE mode
RFS[2]: Successfully opened standby log 5: '/u01/app/oracle/oradata/dgdemo/stdredo05.ora'
Fri Dec 28 12:36:40 2007
RFS LogMiner: Registered logfile [/u01/app/oracle/oradata/arch1/1_69_641854740.dbf] to LogMiner session id [1]
Fri Dec 28 12:36:40 2007
LOGMINER: Archived logfile found, transition to mining logfile: /u01/app/oracle/oradata/arch1/1_69_641854740.dbf
Fri Dec 28 12:36:40 2007
LOGMINER: End mining logfile: /u01/app/oracle/oradata/arch1/1_69_641854740.dbf
Fri Dec 28 12:36:41 2007
LOGMINER: Begin mining logfile: /u01/app/oracle/oradata/dgdemo/stdredo05.ora
查看v$logstadby_progress，发现SCN也是在随着主库不断更新的，
非常奇怪，就是看不到应该同步过来的数据，
请达人指点一二，先谢谢了。
SQL APPLY也作了，但是查看备库，主库上的数据没有在备库上重作出来，
在主库执行 alter system switch logfile ;
查看备库上的alert log,发现日志已经发送过来了，Mining也执行了，
下面是alter日志的内容，
RFS LogMiner: Client enabled and ready for notification
Fri Dec 28 12:36:40 2007
Primary database is in MAXIMUM PERFORMANCE mode
RFS[2]: Successfully opened standby log 5: '/u01/app/oracle/oradata/dgdemo/stdredo05.ora'
Fri Dec 28 12:36:40 2007
RFS LogMiner: Registered logfile [/u01/app/oracle/oradata/arch1/1_69_641854740.dbf] to LogMiner session id [1]
Fri Dec 28 12:36:40 2007
LOGMINER: Archived logfile found, transition to mining logfile: /u01/app/oracle/oradata/arch1/1_69_641854740.dbf
Fri Dec 28 12:36:40 2007
LOGMINER: End mining logfile: /u01/app/oracle/oradata/arch1/1_69_641854740.dbf
Fri Dec 28 12:36:41 2007
LOGMINER: Begin mining logfile: /u01/app/oracle/oradata/dgdemo/stdredo05.ora
查看v$logstadby_progress，发现SCN也是在随着主库不断更新的，
非常奇怪，就是看不到应该同步过来的数据，
请达人指点一二，先谢谢了。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/768134/viewspace-695375/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
