一、新增租户(暂时不用)
create pluggable database orclpdb2 admin user pdbadmin identified by pdbadmin FILE_NAME_CONVERT=('/opt/oracle/oradata/ORCLCDB','/opt/oracle/oradata/ORCLCDB/ORCLPDB2');
二、复制租户
1、登录数据库
export ORACLE_SID=ORCLCDB
sqlplus / as sysdba
2、查看租户
show pdbs;
3、复制租户
create pluggable database orclpdb2 from orclpdb1 FILE_NAME_CONVERT=('/opt/oracle/oradata/ORCLCDB/ORCLPDB1','/opt/oracle/oradata/ORCLCDB/ORCLPDB2');
4、打开租户
alter pluggable database orclpdb2 open;
5、保存状态(否则down掉后,租户会变成MOUNTED状态)
alter pluggable database orclpdb2 save state;
三、删除租户
1、关闭租户
alter pluggable database orclpdb2 close immediate;
2、删除租户
drop pluggable database orclpdb2 including datafiles;