== Source ==
* cdb TSTTDECL
* with wallet password : pwdtsttdecl
* pdb PDB1TDE
* with wallet password : pwdpdb1tde --isolated mode
\\
== Target ==
* cdb TARTDECL
* with wallet password : pwdtartdecl
* pdb PDBTARTDE
* with wallet password : pwdpdbtartde --isolated
\\
== 1/ Log in to the source isolated mode PDB PDB1TDE and verify that the wallet is opened ==
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
3 PDB1TDE READ WRITE NO
SQL> SELECT CON_ID, KEYSTORE_MODE,status,wallet_type from gV$ENCRYPTION_WALLET;
CON_ID KEYSTORE STATUS WALLET_TYPE
---------- -------- ------------------------------ --------------------
3 ISOLATED OPEN PASSWORD
\\
== 2/ On target CDB TARTDECL create a database link for the PDB PDB1TDE that you want to clone remotely. ==
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL> create database link forclone connect to system identified by ZicZac##4523Pec using '//moros:1521/PDB1TDE.COE.CORP';
Database link created.
SQL> alter session set global_names=false;
Session altered.
SQL> select * from dual@forclone;
D
-
X
SQL>
\\
== 3/ On source cdb give following privilege ==
SQL> show parameter db_un
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_unique_name string TSTTDECL
SQL> grant create pluggable database to system container=all;
Grant succeeded.
\\
== 4/ CREATE PLUGGABLE DATABASE statement with the KEYSTORE IDENTIFIED BY clause to perform the clone of the PDB. ==
alter session set global_names=false;
SQL> show parameter tde
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
one_step_plugin_for_pdb_with_tde boolean FALSE
tde_configuration string KEYSTORE_CONFIGURATION=FILE
SQL> alter system set one_step_plugin_for_pdb_with_tde=true;
System altered.
SQL> create pluggable database PDB1TDECLNE2 from PDB1TDE@forclone keystore identified by pwdtartdecl; --with target cdb tde passwd
Pluggable database created.
SQL> alter pluggable database PDB1TDECLNE2 open;
Pluggable database altered.
\\
== 5/ Rekey the master encryption key of the remotely cloned PDB ==
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
6 PDB1TDECLNE2 READ WRITE NO
SQL> ADMINISTER KEY MANAGEMENT SET KEY FORCE KEYSTORE IDENTIFIED BY pwdtartdecl WITH BACKUP USING 'after_clne_key_backup';
keystore altered.
\\
== 6/ Change password for the PDB ==
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
6 PDB1TDECLNE2 READ WRITE NO
SQL> ADMINISTER KEY MANAGEMENT ALTER KEYSTORE PASSWORD IDENTIFIED BY pwdtartdecl SET pwdpdbclne2 WITH BACKUP ;
keystore altered.
\\
== 7/ Create Auto login for the PDB ==
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
6 PDB1TDECLNE2 READ WRITE NO
SQL> ADMINISTER KEY MANAGEMENT CREATE AUTO_LOGIN KEYSTORE FROM KEYSTORE IDENTIFIED BY pwdpdbclne2;
keystore altered.