日志显示
2015-10-27 08:52:39 WARNING OGG-01423 No valid default archive log destination directory found for thread 2015-10-27 08:52:40 INFO OGG-01515 Positioning to begin time Oct 27, 2015 8:50:00 AM. 2015-10-27 08:52:40 INFO OGG-01516 Positioned to Sequence 16, RBA 453648, SCN 0.0, Oct 27, 2015 8:50:00 2015-10-27 08:52:40 INFO OGG-01055 Recovery initialization completed for target file ./dirdat/wm000002, 2015-10-27 08:52:40 INFO OGG-01478 Output file ./dirdat/wm is using format RELEASE 11.2. 2015-10-27 08:52:40 INFO OGG-01026 Rolling over remote file ./dirdat/wm000002. 2015-10-27 08:52:40 INFO OGG-01053 Recovery completed for target file ./dirdat/wm000003, at RBA 1062. 2015-10-27 08:52:40 INFO OGG-01057 Recovery completed for all targets. *********************************************************************** ** Run Time Messages ** *********************************************************************** 2015-10-27 08:52:40 INFO OGG-01517 Position of first record processed Sequence 16, RBA 453648, SCN 0.11 , 2015 8:50:08 AM.
原因:归档路径问题
解决方法:
SQL> alter system set log_archive_dest_1='LOCATION=/oradata/archivelog' scope=both;
就可以了。
重新打开抽取进程
2.SQL> @/u01/ogg/marker_setup这么执行hang住不动了
然后这样执行:
[oracle@lei ~]$ cd /u01/ogg/ [oracle@lei ogg]$ rlwrap sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Tue Oct 27 11:26:37 2015 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> @marker_setup
就好了,可能是权限问题。
3.
2015-10-27 15:59:07 ERROR OGG-00199 Table gate02.GGS_SETUP does not exist in target database.
表在目标库不存在,
要么把不同步该表:mapexclude gate01.GGS_SETUP;
或者在目标库创建该表。
版权声明:本文为博主原创文章,未经博主允许不得转载。
- 上一篇:Oracle 11g OGG配置,安装
- 下一篇:12C 临时UNDO说明