Monitoring Server Archive Log Disk Space Use

You can monitor archive log disk space use to manage your system.

By default, ARCHIVELOG mode is disabled in Oracle Audit Vault Server. The ARCHIVELOG mode once enabled, copies the filled online redo logs to disk. This enables you to back up the database while it is open and being accessed by users, and to recover the database to any desired point in time. You should monitor the disk space usage for the redo logs.

To change from No Archive Mode to Archive Mode, follow these steps:

  1. Log in as oracle user.

  2. Connect to SQLPlus as *sysdba user.

  3. Run the command:

    archive log list;

    Observe the following output:

    Database log mode No Archive Mode

    Automatic archival Disabled

    Archive destination USE_DB_RECOVERY_FILE_DEST

  4. In case the Database log mode is No Archive Mode, then run the following commands:

    shutdown immediate;
    startup mount;
    alter database archivelog;
    archive log list;

  5. Observe the following output:

    Database log mode Archive Mode

    Automatic archival Enabled

    Archive destination USE_DB_RECOVERY_FILE_DEST

  6. Run the command:

    alter database open;

    Note:

    • If you change the ARCHIVELOG mode during the backup configuration process, after the database restarts, then ensure the Java Framework internal tool is running on the Audit Vault Server.

    • Archivelog mode is required for hot backup.

See Also: