OGG-01028分析处理

1.现象

ogg的安装目录使用率达到100%，果断时间会释放短时间又会达到使用率100%。

 

2.分析

2.1 如果是队列文件问题不应该自己释放短时间又达到100%，查看到底是哪个目录导致。

du -sm /home/oracle/oggsource/*|sort -n

83      replicat

277     dirdmp

330     jdk

1524    ggserr.log

21976   dirtmp

2.2 查看问题目录里文件信息

看文件信息应该是内存page out了

 

2.3查看抽取进程配置信息

配置了cachemgr参数

cachemgr cachesize 2GB

2.4解决方案

修改参数

CACHEMGR CACHESIZE 2G, CACHEDIRECTORY /data/ogg

3.总结

3.1mos相关信息

OGG Extract Abends With ERROR OGG-01028 error (108, No Space On Directories: Error: 108: Obj_id: ) Adding Item For Object (文档 ID 1558534.1)

On : 11.1.1.1.2 version, EXTRACT executable

When attempting to start the extract the following error occurs.

ERROR

-----------------------

2013-06-02 10:01:30 WARNING OGG-01262 The call to the cm_memfile_get() function from line 4424 in cm_file_write_upper(op_t *, co_t *, size_t, size_t *, size_t *, int *)() failed with reason 'no space on directories: error: 108: obj_id: '.

2013-06-02 10:01:30 ERROR OGG-01028 error (108, no space on directories: error: 108: obj_id: ) adding item for object 50248 with ROWID AAHSenACbAAEJVMAAs to transaction 125.20.518000 (0x007d.014.0007e770).

If you are using OGG version 12.1.x  error will be like the foollowing

IN OGG v12.1.x,  will throw error like the following

ERROR   OGG-06352  cachemgr: filecaching: cm_mf_write_lower comErr: 102 write: /u01/app/oracle/product/ogg/dirtmp/ex_st810_p93660_extr_0x7f7d1b510888_00000.cm (errno 28, No space left on device).

CAUSE

The issue is caused by the following setup: File system where OGG is installed in 100% full

If the size of the open transaction exceeds the cachesize, then transactions are paged to disk, .cm files will get created under dirtmp directory of OGG install location. If the file system is full, extract will not be able to write to dirtmp directory.

SOLUTION

1. edit params <extract-name>

2. Specify the following parameter

CACHMGR CACHEDIRECTORY <path> <size>

<path> - name of the directory to which Oracle GoldenGate writes transaction data to disk temporarily when necessary

<size> -  sets a maximum amount of disk space that can be allocated to the specified directory. This is optional. If size is not specified, it will create the .cm files till the file system becomes full.

eg:

CACHEMGR CACHEDIRECTORY /opt/dirtmp 10G.

The above example will allow extract to write .cm files up to 10GB.

3. ggsci>start extract