O121-BP-021600 - 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

Information

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.

Solution

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;

To add additional redo log file [members] to an existing redo log file group:

From SQL*Plus (Example):

alter database add logfile member 'diskc:log2.log'
to group 2;

Replace diska, diskb, diskc with valid, different disk drive specifications.

Replace log#.log file with valid or custom names for the log files.

See Also

https://dl.dod.cyber.mil/wp-content/uploads/stigs/zip/U_Oracle_Database_12c_V2R8_STIG.zip

Item Details

References: CAT|II, CCI|CCI-000366, Rule-ID|SV-219828r879887_rule, STIG-ID|O121-BP-021600, STIG-Legacy|SV-75909, STIG-Legacy|V-61419, Vuln-ID|V-219828

Plugin: OracleDB

Control ID: fab6e657917db467455a4caeaace4a036ac40db98f699d1f174a2e5be50b935d