从种子创建插件数据库、克隆本容器插件数据库和插入一个普通数据库，课程第68次（2017-03-22星期三）

botang · 发表于 2017-3-22 23:06:43

select name, cdb, con_id from v$database;
select INSTANCE_NAME, STATUS, CON_ID from v$instance;
select name , con_id from v$services;
select name , open_mode , con_id from v$pdbs;
select sys_context('userenv','con_name') from dual;
select sys_context('userenv','con_id') from dual;
select pdb_id, dbid, guid ,pdb_name , con_id from cdb_pdbs;
select name ,con_id from v$datafile ;
select * from v$tempfile;
select * from v$log;
select * from v$logfile;
select * from v$controlfile;
select file_name, tablespace_name, file_id , con_id
from cdb_data_files
order by con_id , tablespace_name;
select * from dba_data_files;
select d.name, file#, t.name , t.ts# , t.con_id
from v$tablespace t, v$datafile d
where t.ts# = d.ts#
and t.con_id= d.con_id;
select file_name, tablespace_name , file_id , con_id
from cdb_temp_files;
select name, file# ,con_id from
v$tempfile;
----
select username, common, con_id from cdb_users
where username='SYSTEM';
select username, common, con_id from cdb_users
where username='SYS';
select username, common, con_id from cdb_users
where username='HR';
select username, common, con_id from cdb_users
order by username;
select distinct username, CON_ID from cdb_users
where common ='NO';
select distinct status, con_id from v_$bh order by 2 ;
---
create pluggable database pdb2_1
admin user pdb2_1_admin
identified by oracle_4U roles=(connect)
file_name_convert=('/u01/app/oracle/oradata/cdb2/pdbseed',
'/u01/app/oracle/oradata/cdb2/pdb2_1');
select name , open_mode , con_id from v$pdbs;
alter pluggable database pdb2_1 open;
---
alter pluggable database pdb2_1 close immediate;
drop pluggable database pdb2_1 including datafiles;
---
select name , open_mode , con_id from v$pdbs;
alter pluggable database pdb2_1 close;
select name , open_mode , con_id from v$pdbs;
alter pluggable database pdb2_1 open read only;
create pluggable database pdb2_2 from pdb2_1;
alter pluggable database pdb2_1 close;
alter pluggable database pdb2_1 open;
alter pluggable database pdb2_2 open;
select name , open_mode , con_id from v$pdbs;
create pluggable database pdb_orcl2 using '/home/oracle/orcl2.xml' nocopy;
select file_name, tablespace_name , file_id , con_id
from cdb_temp_files;
select name, open_mode , con_id from v$pdbs;
select pdb_name ,status , con_id from cdb_pdbs;

复制代码