| If the database is used solely for transient data (such as one dedicated to Extract-Transform-Load (ETL)), and a clear plan exists for the recovery of the database by means other than archiving, this is not a finding. |
If it has been determined that up-to-the second recovery is not necessary and this fact is recorded in the system documentation, with appropriate approval, this is not a finding.
Check DBMS settings to determine whether system state information is being preserved in the event of a system failure.
The necessary state information is defined as "information necessary to determine cause of failure and to return to operations with least disruption to mission/business processes".
Oracle creates what is known as archive logs. Archive logs contain information required to replay a transaction should something happen. The redo logs are also used to copy transactions or pieces of transactions.
Issue the following commands to check the status of archive log mode:
$ sqlplus connect as sysdba --Check current archivelog mode in database
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /home/oracle/app/oracle/arc2/ORCL
Oldest online log sequence 433
Next log sequence to archive 435
Current log sequence 435
If archive log mode is not enabled, this is a finding.