您當前位置：
首頁 >
數據庫 >
數據庫應用 > 在測試GoldenGate Integrated Capture Mode的時候，啟動抽取進程報 OGG-02050 Not enough database m
在測試GoldenGate Integrated Capture Mode的時候，啟動抽取進程報 OGG-02050 Not enough database m
來源：程序員人生 發布時間：2015-03-25 11:56:05 閱讀次數：5428次
在測試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⑻. 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.
-
生活不易，碼農辛苦
如果您覺得本網站對您的學習有所幫助,可以手機掃描二維碼進行捐贈
------分隔線----------------------------
------分隔線----------------------------
