Setting Up Warm Standby Databases

Set up databases for a warm standby application.

Prerequisites

Perform these tasks before setting up the databases:

Install the Replication Server that manages the active and standby databases. A single Replication Server manages both the active and the standby databases.
Set up ECDA or ExpressConnect for Oracle connectivity. If using ECDA, one copy at primary site and one copy at standby site must be running and configured to communicate with the Oracle databases.
Configure the Replication Agent, and verify that it is running in admin mode for both the active and the standby databases.
Define the DDL user name in both the active and the standby databases, and verify that it is configured in both the Replication Agents.The ddl_username parameter is the database user name included in LTL for replicating DDL commands to the standby or target database. This user must have permission to execute all replicated DDL commands at the target database. The DDL user must be different from the maintenance user. In addition, the DDL user must also have alter session permission to execute the DDL command as the user who executed at the active database. The ddl_password parameter is the password corresponding to the database user name.

Task

Create a single logical connection to be used by both the active and standby databases.
Use the Replication Server create connection command to add the active database to the replication system. You need not add the active database if it has already been added to the replication system.
Use the Replication Server create connection command to add the standby database to the replication system.

Creating the Logical Connection
Create the logical connection for a warm standby application.
Initializing the Replication Agent for the Active Database
Start the Replication Agent for Oracle (RAO) instance and connect to it using isql.
Adding the Active Database to the Replication System
Create connection to the active database.
Initializing the Standby Database
Initialize the standby database with data from the active database using the dump and load technique.
Initializing the Replication Agent for the Standby Database
Start the Replication Agent for Oracle (RAO) instance and connect to it using isql.
Creating Connection to the Standby Database
Create a standby database connection.
Resuming Connection to the Active Database and the Standby Database
Resume the active database and standby database connections.
Resuming the Replication Agents for the Active and Standby Databases
Resume the Replication Agents for the active and standby databases to start scanning the database log for transactions to replicate.

Parent topic: Heterogeneous Warm Standby for Oracle