What is Oracle Archive Logging

Check the requirements for an application-consistent backup of the Oracle database

To back up an Oracle database with consistent data, make sure that the ARCHIVELOG mode is activated so that the redo logs are archived.

Follow these steps to check if ARCHIVELOG mode is enabled:

  1. Log on to the Oracle server as an Oracle user with SYSDBA authorizations.
  2. Enter the following command when the SQL * Plus prompt appears:
  3. ARCHIVE LOG LIST;

  4. Archive log settings for the current instance are displayed.
  5. Configure the following settings:
  6. Database logging mode: archiving mode

    Automatic archiving: activated

  7. Start the ARCHIVELOG mode.
  8. Note:If the ARCHIVELOG mode is not activated, start the ARCHIVELOG mode to back up the database.

Follow these steps to start ARCHIVELOG mode:

  1. Shut down the Oracle server.
  2. Perform the following instructions in Oracle:
  3. CONNECT SYS / SYS_PASSWORD AS SYSDBA

    STARTUP MOUNT;

    ALTER DATABASE ARCHIVELOG;

    ALTER DATABASE OPEN;

  4. By default, logs are stored in the flash recovery area. If you do not want archive logs to be saved in the flash recovery area, set the LOG_ARCHIVE_DEST_n parameter to the location where you want the archive logs to be saved.
  5. SQL> ALTRE SYSTEM SET LOG_ARCHIVE_DEST_1 = 'LOCATION = e: \ app \ administrator \ oradata \ \ arch' SCOPE = BOTH;

    System changed.

    SQL> ARCHIVE LOG LIST;

  6. Archive log settings for the current instance are displayed.
  7. Configure the following settings:
  8. Database logging mode: archiving mode

    Automatic archiving: activated

    Archive target: E: \ app \ oracle \ oradata \ \ arch

    Oldest online log sequence: Jan.

    Current protocol sequence: 23

The Oracle VSS Writer Service has started and is working properly.


Copyright © 2018.