程序员人生网站导航

在测试GoldenGate Integrated Capture Mode的时候，启动抽取进程报 OGG-02050 Not enough database m

栏目：数据库应用时间：2015-03-25 11:56:05

在测试GoldenGate Integrated Capture Mode的时候，启动抽取进程报 OGG-02050 Not enough database memory to honor requested MAX_SGA_SIZE 毛病

参数配置以下：

[html] view plaincopy

GGSCI (zbdba1) 20> view param ext1
EXTRACT ext1
USERID ogg, PASSWORD ogg
TRANLOGOPTIONS INTEGRATEDPARAMS (MAX_SGA_SIZE 50,parallelism 1)
EXTTRAIL /ogg/dirdat/sa
TABLE zbdba.*;

解决方案：

[html] view plaincopy

SQL> alter system set streams_pool_size=100m scope=spfile;
System altered.
SQL> show parameter streams
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
streams_pool_size big integer 4M
SQL>
SQL>
SQL>
SQL> startup force;
ORACLE instance started.
Total System Global Area 417546240 bytes
Fixed Size 2253824 bytes
Variable Size 322964480 bytes
Database Buffers 88080384 bytes
Redo Buffers 4247552 bytes
Database mounted.
Database opened.
SQL>
SQL>
SQL> show parameter streams
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
streams_pool_size big integer 100M
SQL>

再次尝试启动extract进程：

[html] view plaincopy

GGSCI (zbdba1) 21> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT1 00:00:00 00:00:08

查看日志：

[html] view plaincopy

2015-03-02 10:47:26 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, ext1.prm: EXTRACT EXT1 starting.
2015-03-02 10:47:26 INFO OGG-03035 Oracle GoldenGate Capture for Oracle, ext1.prm: Operating system character set identified as UTF⑻. Locale: en_US, LC_ALL:.
2015-03-02 10:47:26 INFO OGG-01635 Oracle GoldenGate Capture for Oracle, ext1.prm: BOUNDED RECOVERY: reset to initial or altered checkpoint.
2015-03-02 10:47:26 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, ext1.prm: Virtual Memory Facilities for: BR
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/ogg/BR/EXT1.
2015-03-02 10:47:26 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, ext1.prm: Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/ogg/dirtmp.
2015-03-02 10:47:26 WARNING OGG-01423 Oracle GoldenGate Capture for Oracle, ext1.prm: No valid default archive log destination directory found for thread 1.
2015-03-02 10:47:33 INFO OGG-02036 Oracle GoldenGate Capture for Oracle, ext1.prm: Integrated capture successfully attached to logmining server OGG$EXT1.
2015-03-02 10:47:34 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, ext1.prm: EXTRACT EXT1 started.
2015-03-02 10:47:34 INFO OGG-01052 Oracle GoldenGate Capture for Oracle, ext1.prm: No recovery is required for target file /ogg/dirdat/sa000000, at RBA 0 (file not opened).
2015-03-02 10:47:34 INFO OGG-01478 Oracle GoldenGate Capture for Oracle, ext1.prm: Output file /ogg/dirdat/sa is using format RELEASE 11.2.

------分隔线----------------------------

上一篇 WebApp之JQuery Mobile实现火车列表信息查询

下一篇 win32 单实例程序运行-无窗口程序也可

------分隔线----------------------------