Prepare the Mining Database to Archive its Local Redo
To prepare the mining database to archive its local redo:
- 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;
- 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)'
- Enable
log_archive_dest_1
.ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_1=ENABLE