REPLICATE

Syntax

Text description of the illustration replicat.gif

Purpose

To copy a control file to the locations specified in the CONTROL_FILES initialization parameter of the target database.

After restoring the control file, you can use the REPLICATE CONTROLFILE statement to prepare the database for mounting. This operation is equivalent to executing multiple COPY CONTROLFILE statements.

Note: The RESTORE command will automatically replicate the control file to all CONTROL_FILES locations if no restore destination is specified.

Restrictions and Usage Notes

• Execute REPLICATE CONTROLFILE only within the braces of a RUN command.

• The target instance must be started.

Keywords and Parameters

'filename'

Specifies the location of the control file to be replicated. For example, if you restore a control file backup to /oracle/temp/cf.bak, then you would also specify this filename in the REPLICATE command.

Example

Replicating a Restored Control File: Example

This example restores a control file to a temporary location and then replicates it manually:

STARTUP NOMOUNT;
RUN
{
  SET UNTIL TIME 'Jun 18 2000 16:32:36';
  # restore a backup controlfile to a temporary location.
  RESTORE CONTROLFILE TO '/tmp/cf.tmp';
  REPLICATE CONTROLFILE FROM '/tmp/cf.tmp'; 
  STARTUP FORCE MOUNT; 
}