cloning a PDB between servers using NFS share

• Create a Copy of Source PDB

# SET Oracle environment
. oraenv <<< CDB1
 
# CONNECT TO SQL*Plus
sqlplus / AS sysdba
 
# CHECK CURRENT PDBs
show pdbs
 
# CREATE PDB copy
CREATE pluggable database PDB2_COPY FROM PDB2;
 
# Verify creation
show pdbs
EXIT

• Move PDB to NFS Share

# SET Oracle environment
. oraenv <<< SITNECDB
 
# CONNECT TO SQL*Plus
sqlplus / AS sysdba
 
# CLOSE the PDB
ALTER pluggable database SIT_PDB2_COPY CLOSE IMMEDIATE instances=ALL;
 
EXIT
 
rman target /
 
run {
    allocate channel c1 TYPE disk;
    allocate channel c2 TYPE disk;
    allocate channel c3 TYPE disk;
    allocate channel c4 TYPE disk; 
    backup AS copy pluggable database SIT_PDB2_COPY format '/NFS/ORACLE/pdb_copy/%U';
}
 
switch pluggable database SIT_PDB2_COPY TO copy;
EXIT

• Create Manifest File

sqlplus / AS sysdba
 
ALTER pluggable database SIT_PDB2_COPY unplug INTO '/NFS/ORACLE/pdb_copy/SIT_PDB2_COPY.xml';
 
show pdbs
EXIT

• Create PDB on Target Server

# SET Oracle environment
. oraenv <<< SITNECDB
 
sqlplus / AS sysdba
 
CREATE pluggable database PDB2 using '/NFS/ORACLE/pdb_copy/SIT_PDB2_COPY.xml';
EXIT

• Restore PDB datafiles on Target Server

rman target /
 
run {
    allocate channel c1 TYPE disk;
    allocate channel c2 TYPE disk;
    allocate channel c3 TYPE disk;
    allocate channel c4 TYPE disk; 
    backup AS copy pluggable database PDB2 format '+DATA';
}
 
switch pluggable database PDB2 TO copy;
EXIT

• Clean Up Source CDB

# DROP the PDB copy
DROP pluggable database PDB2_COPY including datafiles;
 
# Verify PDBs
show pdbs
EXIT

• Clean Up data files on the NFS

# Remove the datafiles on the NFS
cd /NFS/ORACLE
 
rm -rf /NFS/ORACLE/pdb_copy