Prepare the Mining Database to Archive its Local Redo

To prepare the mining database to archive its local redo:

1. The downstream mining database must be in archive log mode. You can do this by issuing the following DDL:

   STARTUP MOUNT;
   ALTER DATABASE ARCHIVELOG;
   ALTER DATABASE OPEN;

2. At the downstream mining database, set log_archive_dest_1 to archive local redo.:

   ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=/home/arc_dest/local
   VALID_FOR=(ONLINE_LOGFILE, PRIMARY_ROLE)'

3. Enable log_archive_dest_1.

   ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_1=ENABLE