Step 1: Setup up Source Database
Environment
The NOREGISTER attribute needs to be set to
indicate that the location of the archived redo log should not
be recorded at the corresponding destination. If this attribute
is not specified, the following error may be returned:
ORA-16009: remote archive log destination must be a STANDBY
database
The TEMPLATE attribute should be set to the
directory specification and format template for archived redo
logs at the Down Streams database. This parameter overrides the
standby_archive_dest and log_archive_format
initialization parameter settings at the remote destination.
When specifying a directory within the template attribute value,
it is important to make sure that the directory exists, or the
following error may be returned:
ORA-00270: error creating archive log
The log_archive_format specification
has %s, %t and %r. The %s corresponds to the sequence number and
%r corresponds to the resetlogs ID that ensures unique names are
constructed for the archived redo logs across multiple
incarnations of the database. The %t, which is required for RAC
configurations, corresponds to the thread.
Enable the archive destination by using the
log_archive_dest_state_2 parameter:
LOG_ARCHIVE_DEST_STATE_2=enable
At
both the source database and the Down Streams database, the
remote_archive_enable initialization parameter should be set
to TRUE.
