O112-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 - V$LOG count

Warning! Audit Deprecated

This audit has been deprecated and will be removed in a future update.

View Next Audit Version

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_11-2g_V2R3_STIG.zip

Item Details

References: CAT|II, CCI|CCI-000366, Rule-ID|SV-219699r401224_rule, STIG-ID|O112-BP-021600, STIG-Legacy|SV-68209, STIG-Legacy|V-53969, Vuln-ID|V-219699

Plugin: OracleDB

Control ID: 95049bad3e62def1ef2e556f82af4af18aaf6b5969358e3e164f2bf2960b6027