在测试GoldenGate Integrated Capture Mode的时候,启动抽取进程报 OGG-02050 Not enough database memory to honor requested MAX_SGA_SIZE 错误
参数配置如下:
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.*;
解决方案:
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进程:
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
查看日志:
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-8. 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.