Introducing Arcserve Backup Agents and Options › Using Agents › Agent for Oracle › Installing the Agent for Oracle › Perform Post-Installation Tasks › Automatic Archiving › Enable Automatic Archiving for Oracle Installation Using SPFILE

Enable Automatic Archiving for Oracle Installation Using SPFILE

You can enable automatic archiving for the Oracle installation using SPFILE.

To enable automatic archiving for Oracle installation using SPFILE

1. Verify the value of the log parameters by entering the following command at the SQL*Plus prompt:

   show parameter log
   

2. If the parameters do not have the correct values, change them by entering the following commands at the SQL*Plus prompt after you shut down the server:

   CONNECT SYS/SYS_PASSWORD AS SYSDBA 
   

   STARTUP MOUNT EXCLUSIVE
   

   ALTER SYSTEM SET LOG_ARCHIVE_START = TRUE SCOPE = SPFILE;
   ALTER SYSTEM SET LOG_ARCHIVE_DEST=“c:\oracle\oradata\ORCL\archive” 
   SCOPE = SPFILE;
   ALTER SYSTEM SET LOG_ARCHIVE_FORMAT=”ARC%S.%T” SCOPE = SPFILE;
   

   Note: The actual value of LOG_ARCHIVE_DEST is specific to your environment.

3. Restart the Oracle instance to make the changes effective.

For more information about automatic archiving, see the Oracle documentation.