--unplug pdbs

alter pluggable database all close instances=all;

alter pluggable database mypdb1 unplug into '/home/oracle/mypdb1.xml' instances=all;

cp +DATA/MYDB/mypdb1/* +DATA/MYDB/mypdb2/

drop pluggable database mypdb1 including datafiles;

--plug pdbs

cp +DATA/MYDB/mypdb2/* +DATA/MYDB/mypdb1/

create pluggable database mypdb1 using '/home/oracle/mypdb1.xml' nocopy;

alter pluggable database mypdb1 open instances=all;

--clone pdbs

alter pluggable database all close instances=all;

alter pluggable database all open read only instances=all;

create pluggable database mypdb2 from mypdb1

file_name_convert=

('+DATA/MYDB/mypdb1/DATAFILE/system.285.879170469',

'+DATA/MYDB/mypdb2/mypdb2_system.dbf',

'+DATA/MYDB/mypdb1/DATAFILE/sysaux.287.879170505',

'+DATA/MYDB/mypdb2/mypdb2_sysaux.dbf',

'+DATA/MYDB/mypdb1/TEMPFILE/temp.290.879170519',

'+DATA/MYDB/mypdb2/mypdb2_temp.dbf');

alter pluggable database mypdb2 open instances=all;

--create pdbs

CREATE PLUGGABLE DATABASE mypdb1 ADMIN USER mypdb1 IDENTIFIED BY oracle ROLES=(CONNECT)

file_name_convert=

('+DATA/MYDB/158CBB38F7294608E0536538A8C08B86/DATAFILE/system.285.879170469',

'+DATA/MYDB/mypdb1/mypdb1_system.dbf',

'+DATA/MYDB/158CBB38F7294608E0536538A8C08B86/DATAFILE/sysaux.287.879170505',

'+DATA/MYDB/mypdb1/mypdb1_sysaux.dbf',

'+DATA/MYDB/158CBB38F7294608E0536538A8C08B86/TEMPFILE/temp.290.879170519',

'+DATA/MYDB/mypdb1/mypdb1_temp.dbf');

alter pluggable database mypdb1 open instances=all;

--usefull sentence

show con_name

show pdbs

alter session set container=pdbs/cdb$root

SELECT

'DB_NAME: ' ||sys_context('userenv', 'db_name')||

' / CDB?: ' ||(select cdb from v$database)||

' / AUTH_ID: ' ||sys_context('userenv', 'authenticated_identity')||

' / USER: ' ||sys_context('userenv', 'current_user')||

' / CONTAINER: '||nvl(sys_Context('userenv', 'con_Name'), 'NON-CDB')

as "DB DETAILS"

FROM DUAL;

select v.name, v.open_mode, nvl(v.restricted, 'n/a') "RESTRICTED", d.status

from v$PDBs v inner join dba_pdbs d

using (GUID)

order by v.create_scn;

ITPub博客

创建管理pdbs

最新文章