ADD PLUGGABLE DATABASE

This command instantiates a target PDB in the target database. The target PDB is used to provide data protection for a source PDB in a source database.

Format

ADD PLUGGABLE DATABASE <pdb_name> AT <target_db_unique_name>
SOURCE IS <source_pdb_name> AT <source_db_unique_name> 
PDBFileNameConvert IS '<filename_convert_string>' [<create_pluggable_database_options>]';

Command Parameters

pdb_name

Name of the target PDB that must be instantiated in the target database. A PDB with the specified name must not exist in the target database.

target_db_unique_name

Name of the target database that contains the target PDB.

source_pdb_name

Name of the source PDB that must be instantiated at the target database. The source PDB must exist in the source database specified by the source_database_name parameter.

source_db_unique_name

Name of the source database that contains the source PDB.

filename_convert_string

String conversion of data file names from source database to target database.

create_pluggable_database_options

Options to be used when creating the Data Guard Pluggable Database. These are the options available for the SQL*Plus CREATE PLUGGABLE DATABASE command.

Usage Notes

  • This command instantiates the specified PDB after verifying that it exists in the source database and does not exist in the target database.

  • If a PDB with the specified name exists in the target database and is operating as a native PDB (not set up for Data Guard protection), an error is displayed.

Examples

Example 10-5 Instantiating a Source PDB in a DG PDB Environment

This example adds a target PDB named dgpdb_sales to the target database named newyork. The target PDB is used to provide data protection for the source PDB sales in the source database boston. The PDBFileNameConvert keyword specifies how to convert database files in the source database to the target database. 

ADD PLUGGABLE DATABASE 'dgpdb_sales' AT 'newyork' 
SOURCE IS 'sales' AT 'boston' 
PDBFileNameConvert IS "'dbs/boston-sales, dbs/newyork-sales-dg'";