12C-CDB中PDB间的转换

来源：互联网发布：手机扫描文字识别软件编辑：程序博客网时间：2024/06/04 00:44

--DB启动后，默认是不启动PDB，可通过触发器来实现

CREATE TRIGGERopen_all_pdbs

AFTER STARTUP

ON DATABASE

BEGIN

EXECUTE IMMEDIATE 'alter pluggable databaseall open';

ENDopen_all_pdbs;

--CDB中PDB创建的几种方法

方法一：

create pluggable database zaki4 from zaki1 file_name_convert= ('/oracle/db/oradata/orcl/zaki1','/oracle/db/oradata/orcl/zaki4');

create pluggabled atabase zaki8 from zaki2 file_name_convert= ('/oracle/db/oradata/orcl/zaki2','/oracle/db/oradata/orcl/zaki8') snapshot copy;--需要操作系统支持snapshot

方法二：

alter pluggable database zaki5 close;

alter pluggable database zaki5 unplug into '/oracle/db/oradata/orcl/zaki1/zaki5.xml';

DECLARE

l_result BOOLEAN;

BEGIN

l_result :=DBMS_PDB.check_plug_compatibility(pdb_descr_file =>'/oracle/db/oradata/orcl/zaki1/zaki5.xml',pdb_name => 'zaki5');

IF l_result THEN

DBMS_OUTPUT.PUT_LINE('compatible');

ELSE

DBMS_OUTPUT.PUT_LINE('incompatible');

END IF;

END;

create pluggabledatabase zaki5 using '/oracle/db/oradata/orcl/zaki1/zaki5.xml' nocopy tempfilereuse; (source_file_name_convert)

方法三：

CREATE PLUGGABLEDATABASE zaki5 admin user zwh identified by zwh

PATH_PREFIX='/oracle/db/oradata/orcl/zaki5/'

FILE_NAME_CONVERT= ('/oracle/db/oradata/orcl/pdbseed/','/oracle/db/oradata/orcl/zaki5/');

或者

CREATE PLUGGABLEDATABASE zaki6 admin user zwh identified by zwh

STORAGE (MAXSIZE2G MAX_SHARED_TEMP_SIZE 100M)

DEFAULTTABLESPACE lex datafile'/oracle/db/oradata/orcl/zaki6/zwh.dbf' size 100M

PATH_PREFIX='/oracle/db/oradata/orcl/zaki6/'

FILE_NAME_CONVERT= ('/oracle/db/oradata/orcl/pdbseed/','/oracle/db/oradata/orcl/zaki6/');

--查看新建的zaki8状态并以只读方式打开

selectpdb_id,pdb_name,dbid,STATUS,CREATION_SCN from dba_pdbs;

alter pluggabledatabase zaki8 close;

alter pluggabledatabase zaki8 open read only;

0 0