OGG-02050 Not enough database memory to honor requested MAX_SGA_SIZE
在测试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.
郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。