Oracle19c热克隆

1.先确认备克隆的pdb的字符集

[oracle@dbm0dbadm01 ~]$  sqlplus / as sysdba
SQL>  alter session set container=pdb1;
SQL> select * from nls_database_parameters;

2.进行热克隆

SQL> create pluggable database pdb2 from pdb1; 

3.启动新克隆出来的pdb2数据库并设置为自启动

SQL> alter pluggable database pdb2 open instances=all;

Pluggable database altered.

SQL> alter pluggable database all save state instances=all;

Pluggable database altered.

create user umcaresys identified by Umcare123;
  
grant dba to umcaresys; 

alter user umcaresys quota unlimited on tablespace;

grant  unlimited tablespace to umcaresys;

grant insert any table to umcaresys;