Initializing the Replication Agent for the Standby Database

Start the Replication Agent for Oracle (RAO) instance and connect to it using isql.

  1. Set the archive log file path of the standby Oracle databases:
    ra_config pdb_include_archives, true
    go
    ra_config pdb_archive_path, <path-to-oracle-archive-directory>
    go
  2. Configure connection of Replication Agent to the standby database:
    ra_config pds_host_name, <the host name of the standby oracle>
    go
    ra_config pds_port_number <the port number of the standby oracle>
    go
    ra_config pds_database_name,<the standby oracle database name>
    go
    ra_config  pds_username, <the oracle user for Replication Agent>
    go
    ra_config pds_password, <password>
    go
    test_connection PDS
    go
    If the connection is established successfully, you see:
    Type   Connection
    ---- 	----------
    PDS    succeeded
  3. Configure the Replication Agent connection to Replication Server:
    ra_config rs_host_name, <the host name of the Replication Server>
    go
    ra_config rs_port_number, <the port number of the
    Replication Server>
    go
    ra_config rs_username, <the Replication Server user for Replication Agent>
    go
    ra_config rs_password, <password>
    go
    ra_config rs_source_ds ','<the DCON server name> 
    go
    ra_config rs_source_db ','<the standby oracle database name>
    go
    Note: If you are using ExpressConnect for Oracle, replace the DirectConnect server name with the name of the Oracle instance. For example:
    ra_config rs_source_ds, 'ordb'
    go
    rs_config rs_source_db, 'ordb'
    go
  4. Configuring the Replication Agent connection to ERSSD:
    ra_config rssd_host_name <the host name of the ERSSD>
    go
    ra_config rssd_port_number, <the port number of the ERSSD>
    go
    ra_config rssd_username, <the ERSSD user for
    Replication Agent>
    go
    ra_config rssd_password, <password>
    go
    ra_config rssd_database_name, <the database name of the ERSSD>
    go
    test_connection RS
    go
    If the connection is established successfully, you see:
    Type   Connection
    ---- 	----------
    RS     succeeded
  5. If the character set of Replication Server is not the same as Replication Agent, update the Replication Server character set:
    ra_config rs_charset, <the charset of the Replication Server>
  6. Create a replication definition for each table marked for replication:
    ra_config pdb_auto_create_repdefs, true 
    go
  7. Set automatic marking of user tables:
    ra_config pdb_automark_tables, true
    go
  8. Initialize the Replication Agent transaction log:
    pdb_xlog init
  9. Enable DDL replication for the active database:
    pdb_setrepddl enable
    Note: Some DDL commands are filtered even when DDL replication is enabled. If you are enabling DDL replication, you must also set ddl_password and ddl_username.
  10. Configure the Replication Agent to work in standby mode. Set the ra_standby configuration parameter to “true” to work in standby mode.
    ra_config ra_standby,'true'
    go