PDB rename

修改PDB name

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB                            MOUNTED
         4 PDB2                           MOUNTED
SQL> alter pluggable database pdb2 open restricted;---以受限制模式open

Pluggable database altered.

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB                            MOUNTED
         4 PDB2                           READ WRITE YES
SQL> alter session set container=pdb2;

Session altered.

SQL> alter pluggable database rename global_name to pdb22;

Pluggable database altered.

SQL> alter pluggable database close immediate;

Pluggable database altered.

SQL> alter pluggable database open;

Pluggable database altered.

SQL> alter session set container=CDB$ROOT;

Session altered.

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB                            MOUNTED
         4 PDB22                          READ WRITE NO

---修改数据文件的目录

SQL> !mkdir /oracle/app/oracle/oradata/ZTEST/pdb22

SQL> alter session set container=pdb22;

Session altered.

SQL> alter database move datafile '/oracle/app/oracle/oradata/ZTEST/pdb2/system01.dbf' to '/oracle/app/oracle/oradata/ZTEST/pdb22/system01.dbf';
alter database move datafile '/oracle/app/oracle/oradata/ZTEST/pdb2/sysaux01.dbf' to '/oracle/app/oracle/oradata/ZTEST/pdb22/sysaux01.dbf';
alter database move datafile '/oracle/app/oracle/oradata/ZTEST/pdb2/undotbs01.dbf' to '/oracle/app/oracle/oradata/ZTEST/pdb22/undotbs01.dbf';

Database altered.

SQL> 
Database altered.

SQL> 
Database altered.

SQL> alter database tempfile '/oracle/app/oracle/oradata/ZTEST/pdb2/temp012020-07-31_16-04-44-893-PM.dbf' drop including datafiles;

Database altered.

SQL> alter tablespace temp add tempfile '/oracle/app/oracle/oradata/ZTEST/pdb22/temp01.dbf' size 100m reuse;

Tablespace altered.

SQL> !rmdir /oracle/app/oracle/oradata/ZTEST/pdb2---删除原目录

---修改tnsnames.ora
复制

In a multitenant environment, one concern is contention for system resources among the PDBs running on the same server. Another concern is limiting resource usage for more consistent, predictable performance. To address such resource contention, usage, and monitoring issues, use Oracle Database Resource Manager 。在多租户环境中，一个问题是在同一服务器上运行的PDB之间争用系统资源。另一个问题是限制资源使用，以获得更一致，可预测的性能。要解决此类资源争用，使用和监视问题，请使用Oracle数据库资源管理器。

If you clone a PDB from a remote CDB, then you must use a database link.