TMA-OCEANBASE-1.2
Ensure the Partition Size for Log Files is Large Enough
설명
The database files and directories should place to a non-system partition and the partition size should be large enough. For OceanBase stable running and accommondating log growth, the partition size for OceanBase log files must have at least 3-4 times the available memory .
점검 방법
감사 방식: 수동 검토
이 권장 사항은 자동으로 점검할 수 없습니다. --include-manual 옵션을 전달하면 스캔 결과에 이 지침과 함께 표시됩니다.
Run SELECT svr_ip, name, value FROM oceanbase.GV$OB_PARAMETERS WHERE name IN ('data_dir','memory_limit','memory_limit_percentage'); Derive available memory (memory_limit, or memory_limit_percentage x MemTotal from /proc/meminfo). For each log directory (e.g. /data/log1, df -h <dir>) the partition must be at least 3-4 times the observer available memory; a smaller log partition is a finding.
조치 방법
조치 방식: 가이드 또는 인프라 패치
Assume the disk used for the log partition is large enough. Then perform the following steps to remediate this setting for the log directory: 1. Backup the database. 2. Stop observer using a command like: pkill -9 observer. 3. Dismount the log partition usming command like: umount /data/log1. 4. Resize the log partition and the filesystem. 5. Mount the log partition to the original directory: mount <partition> /data/log1. 6. Restart observer. 7.
속성
- 운영 체제
- 모두
- 태그
- oceanbasestorage
- 참고 자료
- CIS OceanBase Enterprise Edition V4 Benchmark v1.0.0 - 1.2 Ensure the Partition Size for Log Files is Large Enough