Friday, February 14, 2020

Clone a PDB in Oracle 12c Multi tanent

Step 1: Let's create PDB_SOURCE for cloning
> create pluggable database pdb_source
  admin user pdb_source_admin identified by password
  role = (dba)
  default tablespace pdb_source_ts datafile '/mnt/san_storage/oradata/orcl12c/pdb_source/pdb_sts_datafile1.dbf' size 50M autoextend on
  file_name_convert = ('/oradata/orcl12c/pdbseed','/oradata/orcl12c/pdb_source');



Step 2: Open the PDB_SOURCE
> alter pluggable database pdb_source open;


Step 3: For coning PDB_SOURCE, first close the PDB_SOURCE and open it in read only mode.
> alter pluggable database pdb_source close;
> alter pluggable database pdb_source open read only;


Step 4: Clone the PDB_SOURCE to PDB_TARGET.
> create pluggable database pdb_target from pdb_source file_name_convert = ('/oradata/orcl12c/pdb_source','/oradata/orcl12c/pdb_target/');


Step 3: Open PDB_TARGET
> alter pluggable database pdb_target open;


No comments:

Post a Comment

Oracle Database Administrator