Previous Topic: Check ARCHIVELOG modeNext Topic: Automatic Archiving


Start ARCHIVELOG Mode

You must start the ARCHIVELOG MODE to backup the database after installing the agent.

To start ARCHIVELOG mode

  1. Shut down Oracle Server.
  2. Execute the following statements in Oracle:

    At the SQL*Plus prompt in Oracle:

    CONNECT SYS/SYS_PASSWORD AS SYSDBA 
    STARTUP MOUNT EXCLUSIVE 
    ALTER DATABASE ARCHIVELOG;
    ALTER DATABASE OPEN;
    ARCHIVE LOG START;
    

If you are not using a flash recovery area with your Oracle 10g or Oracle 11g server, you must include the following entries in either the PFILE or the SPFILE:

LOG_ARCHIVE_DEST_1="C:\Oracle\oradata\ORCL\archive"
LOG_ARCHIVE_FORMAT="ARC%S_%R.%T"

Note: With Oracle 10g or Oracle 11g, the LOG_ARCHIVE_START and LOG_ARCHIVE_DEST entries are considered obsolete and should not be made, in either the PFILE or the SPFILE.

For more information about the Archive Log Mode, see the Oracle documentation.