complete_post_pdb

Performs cleanup operations and complete pluggable database relocation in the maximum availability mode.

Note:

This verb is applicable only for database versions 12.2 (and above).

Note:

When a pluggable database of version 12.2 (and above) is relocated in maximum availability mode, the source pluggable database target still continues to exist in Enterprise Manager after the successful relocation. In the Maximum Availability mode, the existing client connections is redirected by the source CDB's listener to the relocated PDB. To facilitate this connection redirection, the source pluggable database exists in mounted state. Eventually, after all the client connect descriptors are migrated by the user manually to point to the relocated pluggable database, the source can be removed. This verb should be run only on the source pluggable database target to remove it and also to delete the pluggable database from backend.

Format

 emcli complete_post_pdb_relocation
		 -pdb_target_name="source pluggable database target name"
		 -input_file="path of the input file"
		 							           
[ ]  indicates that the parameter is optional.

Options

pdb_target_name

Name of the source pluggable database target.

input_file

Path of the file containing the following input properties:

	SRC_CDB_CRED = SYSDBA source container database credentials (format - CRED_NAME:OWNER)
	SRC_HOST_CRED = Source container database host credentials (format - CRED_NAME:OWNER)

Example

Example 1

This example completes the post relocation actions to delete the source pluggable database "SICDB_GEN", which was relocated to another container database in the maximum availability mode.

 emcli complete_post_pdb_relocation 
		 -pdb_target_name="SICDB_GEN" 
		 -input_file=data:/u01/post_relocate.props