PAUSE_REPLICATION_DATABASE

This procedure pauses replication for the specified database with all associated replication servers. If replication_server_name is specified, replication for the one database/one replication server is paused.

The Recovery Appliance permits in-progress replication of backup pieces to complete. If the Recovery Appliance queued backup pieces for replication through this replication server configuration but did not replicate them, then the Recovery Appliance holds the backup pieces until you call RESUME_REPLICATION_DATABASE. No replication tasks that run against this database/Recovery Appliance can execute until you resume_replication_database for the specified database/downstream Recovery Appliance.

Syntax

PROCEDURE pause_replication_database (
   db_unique_name IN VARCHAR2,
   replication_server_name IN VARCHAR2 DEFAULT NULL,
   comments IN VARCHAR2 DEFAULT NULL);

Parameters

Table 22-34 PAUSE_REPLICATION_DATABASE Parameters

Parameter Description

db_unique_name

The protected database for which to pause replication.

replication_server_name

If not null, replication is paused only for the one database on this specified replication server. If null, replication is paused for that database on all associated replication servers.

comments

Optional user supplied comment describing reason for executing this command.