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');
> 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