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 24-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.