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
<VulnDiscussion>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.</VulnDiscussion><FalsePositives></FalsePositives><FalseNegatives></FalseNegatives><Documentable>false</Documentable><Mitigations></Mitigations><SeverityOverrideGuidance></SeverityOverrideGuidance><PotentialImpacts></PotentialImpacts><ThirdPartyTools></ThirdPartyTools><MitigationControl></MitigationControl><Responsibility></Responsibility><IAControls></IAControls>
- ID
- SV-219699r879887_rule
- Severity
- Medium
- References
- Updated
Remediation - 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;