That was OGG version 12.2.0.1.160517.
The size of this directory was 23G in the test environment and the ENABLEMONITORING option was set 3 weeks ago:
-bash-4.1$ du -sh dirbdb 23.8G dirbdbFrom that 23.8G , 23.5G was occupied by the log.* files like below:
-rw-r----- 1 oracle dba 10485760 Nov 16 18:16 log.0000015971 -rw-r----- 1 oracle dba 10485760 Nov 16 18:28 log.0000015972 -rw-r----- 1 oracle dba 10485760 Nov 16 18:41 log.0000015973 -rw-r----- 1 oracle dba 10485760 Nov 16 18:55 log.0000015974 -rw-r----- 1 oracle dba 10485760 Nov 16 19:08 log.0000015975 -rw-r----- 1 oracle dba 10485760 Nov 16 19:20 log.0000015976 -rw-r----- 1 oracle dba 10485760 Nov 16 19:32 log.0000015977 -rw-r----- 1 oracle dba 10485760 Nov 16 19:43 log.0000015978 -rw-r----- 1 oracle dba 10485760 Nov 16 19:55 log.0000015979 -rw-r----- 1 oracle dba 10485760 Nov 16 20:07 log.0000015980 -rw-r----- 1 oracle dba 10485760 Nov 16 20:19 log.0000015981 -rw-r----- 1 oracle dba 10485760 Nov 16 20:31 log.0000015982These files were generated approximately every ten minutes and each of them was 10M in size that made up 1.4G daily.
Having searched through MOS and Internet search engines, I stumbled across this MOSC Thread: Monitoring - Berkeley Database.
So I created a new DB_CONFIG file within the dirbdb directory and put this line into it:
-bash-4.1$ cat dirbdb/DB_CONFIG set_flags DB_LOG_AUTOREMOVEThen I restarted my OGG processes and discovered that these log files were gone.
Now there are only two log files that are kept:
[oracle@host ggs]$ ls -ltr dirbdb/log* -rw-r----- 1 oracle dba 10485760 Nov 28 13:31 dirbdb/log.0000017532 -rw-r----- 1 oracle dba 10485760 Nov 28 13:41 dirbdb/log.0000017533 [oracle@host ggs]$ ls -ltr dirbdb/log* -rw-r----- 1 oracle dba 10485760 Nov 28 13:42 dirbdb/log.0000017533 -rw-r----- 1 oracle dba 10485760 Nov 28 13:51 dirbdb/log.0000017534 [oracle@host ggs]$ ls -ltr dirbdb/log* -rw-r----- 1 oracle dba 10485760 Nov 29 07:21 dirbdb/log.0000017625 -rw-r----- 1 oracle dba 10485760 Nov 29 07:22 dirbdb/log.0000017626Looks like another option that should be added in the environments in which ENABLEMONITORING is set.
Yet, MOS returns no hits apart from the aforementioned MOSC thread.
Комментариев нет:
Отправить комментарий
Примечание. Отправлять комментарии могут только участники этого блога.