A minimum of two Oracle redo log groups/files must be defined and configured to be stored on separate, archived physical disks or archived directories on a RAID device.
An XCCDF Rule
Description
The Oracle redo log files store the detailed information on changes made to the database. This information is critical to database recovery in case of a database failure.
- ID
- SV-219699r879887_rule
- Version
- O112-BP-021600
- Severity
- Medium
- References
- Updated
Remediation Templates
A Manual Procedure
To define additional redo log file groups:
From SQL*Plus (Example):
alter database add logfile group 2
('diska:log2.log', 'diskb:log2.log') size 50K;