editPrimDb.txt
09-07-2001 Bikle
---------------------

This file displays specific changes made to initABIKLE.ora and other
files to facilitate the setup of a standby database.

First we need to work with the parameter LOG_ARCHIVE_DEST_2.  We need
to alter it so that it "points" at the standby database (which
requires that we think forward a little bit and decide on the name of
our standby database):

LOG_ARCHIVE_DEST_2 = "service=BBIKLE.BIKLE.NET"

Also we need to add the following entry:

LOG_ARCHIVE_DEST_STATE_2 = ENABLE

The astute reader might ask, "I only see a service name; How do we
specify the exact directory which collects the archived redolog files?"

Answer: The Oracle kernel for the standby database handles this problem by placing
the incoming archivelog files in a location specified by the standby database
init.ora: STANDBY_ARCHIVE_DEST

For example, 
standby_archive_dest = /u2/oracle/data/BBIKLE/archstandby


Next, we add an entry to $ORACLE_HOME/network/admin/tnsnames.ora:

BBIKLE.bikle.net =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = sf49er.bikle.com)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = BBIKLE.bikle.net)
    )
  )