Business Intelligence (BI) Interface Guide › Setting Source Database to Archive Log Mode

Setting Source Database to Archive Log Mode

Note: This section is only relevant when configuring the BI Interface for installation on two separate databases.

To switch the CA Business Service Insight source database archiving mode, use the ALTER DATABASE statement with the ARCHIVELOG or NOARCHIVELOG option. The following steps indicate how to switch the CA Business Service Insight source database archiving mode from NOARCHIVELOG to ARCHIVELOG:

1. Shut down the database instance using the SHUTDOWN command.

   An open database must first be closed and any associated instances shut down before you can switch the database's archiving mode. You cannot disable archiving if any data files need media recovery.

2. Back up the database.

   Before making any major change to a database, always back up the database to protect against any problems. This will be your final backup of the database in NOARCHIVELOG mode and can be used if something goes wrong while trying to change to ARCHIVELOG mode. See Oracle9i User-Managed Backup and Recovery Guide or Oracle9i Recovery Manager User's Guide for further information on backup and recovery.

3. Edit the initialization parameter file to include initialization parameters specifying whether automatic archiving is enabled (see "Enabling Automatic Archiving") and the destinations for the archive log files (see "Specifying Archive Destinations").

   LOG_ARCHIVE_START=TRUE
   LOG_ARCHIVE_DEST = '/disk1/arc'
   

4. Start a new instance and mount, but do not open, the database using the STARTUP MOUNT command.

   Note: To enable or disable archiving, the database must be mounted but not open.

5. Switch the database's archiving mode. Then open the database for normal operations as follows:

   ALTER DATABASE [NO]ARCHIVELOG;
   ALTER DATABASE OPEN;
   

6. Shut down the database using the SHUTDOWN IMMEDIATE command.
7. Back up the database.