Replicated Information for an Oracle Warm Standby Application

Replication Agent supports different methods for enabling replication to the Oracle standby database.

The level and type of information that Replication Server copies to the standby database depends on the method you choose; one of:

pdb_setrepddl– allows replication of DDL commands and procedures that make changes to system tables stored in the database. You can use DDL commands to create, alter, and drop database objects, such as tables and views. Supported DDL system procedures affect information about database objects, and executed at the standby database by the DDL user.
pdb_setreptable – marks all user tables or a specified table for replication.

Optionally, you can also use pdb_setrepproc to tell Replication Agent which user-stored procedures to replicate to the standby database.

For detailed information on Replication Agent for Oracle configuration parameters, see Replication Agent Reference Manual > Configuration Parameters.