The following list describes the minimum standby database configuration required to participate in the Mirror Activator system:
All the data server options and configuration parameters exactly match those of the primary data server.
The database name, data and log device configuration, and all database options exactly match those of the primary database.
Maintenance User login name (as specified in the Replication Server create connection command) added to the standby database, with the required permissions granted.
Replication Server database objects (tables and procedures) created and set up in the standby database, with appropriate permissions granted to the Maintenance User name in the standby database.
For Oracle: DDL user login name added to the standby database and granted permissions required to execute replicated DDL commands.
Materialization populates the standby database with all of the contents of the primary database, including the Maintenance User login name and Replication Server database objects (which are required in the primary database). If you use snapshot materialization for the standby database, its name, device configuration, and options must exactly match those of the primary database.