Oracle 在open一个插入的pdb时向本pdb的数据字典中插入datafile信息,而不是在create pluggable database时

最新推荐文章于 2022-05-13 11:07:42 发布

msdnchina

最新推荐文章于 2022-05-13 11:07:42 发布

阅读量1.2k

点赞数

分类专栏： Oracle DB 12c Oracle DB 12c新特性

本文链接：https://blog.csdn.net/msdnchina/article/details/66974843

版权

Oracle DB 12c 同时被 2 个专栏收录

62 篇文章 0 订阅

订阅专栏

Oracle DB 12c新特性

39 篇文章 8 订阅

订阅专栏

2017-03-27T14:25:23.474902+08:00
alter pluggable database abcpdb open
ABCPDB(3):Autotune of undo retention is turned on. 
2017-03-27T14:25:24.339815+08:00
ABCPDB(3):Endian type of dictionary set to little
2017-03-27T14:25:27.087536+08:00
ABCPDB(3):[20907] Successfully onlined Undo Tablespace 2.
ABCPDB(3):Undo initialization finished serial:0 start:68158399 end:68160743 diff:2344 ms (2.3 seconds)
Opatch validation is skipped for PDB ABCPDB (con_id=3)
ABCPDB(3):Deleting old file#2 from file$ 
ABCPDB(3):Deleting old file#9 from file$ 
ABCPDB(3):Deleting old file#10 from file$ 
ABCPDB(3):Deleting old file#11 from file$ 
ABCPDB(3):Deleting old file#12 from file$ 
ABCPDB(3):Adding new file#9 to file$(old file#9)    ------------------>>>此处
ABCPDB(3):Adding new file#13 to file$(old file#2)   ------------------>>>此处
ABCPDB(3):Adding new file#10 to file$(old file#10)  ------------------>>>此处
ABCPDB(3):Adding new file#11 to file$(old file#11)  ------------------>>>此处
ABCPDB(3):Adding new file#12 to file$(old file#12)  ------------------>>>此处
2017-03-27T14:25:28.784240+08:00
ABCPDB(3):Successfully created internal service abcpdb at open  ------>>>此处
****************************************************************
Post plug operations are now complete.
Pluggable database ABCPDB with pdb id - 3 is now marked as NEW. ------>>>此处
****************************************************************
ABCPDB(3):Database Characterset for ABCPDB is AL32UTF8
2017-03-27T14:25:32.479388+08:00
ABCPDB(3):Opatch validation is skipped for PDB ABCPDB (con_id=0)
2017-03-27T14:25:41.984486+08:00
ABCPDB(3):JIT: pid 20907 requesting full stop
2017-03-27T14:26:32.791390+08:00
ABCPDB(3):Opening pdb with no Resource Manager plan active
2017-03-27T14:26:38.990646+08:00
Pluggable database ABCPDB opened read write
Completed: alter pluggable database abcpdb open

SQL>  select  file#,status$ from file$;

     FILE#    STATUS$
---------- ----------
	12	    2
	11	    2
	10	    2
	13	    2
	 9	    2

SQL> show con_name 

CON_NAME
------------------------------
ABCPDB
SQL>

根据上面的alert日志和上面的查询,能断定:Oracle 在open一个插入的pdb时向本pdb的数据字典中插入datafile信息,而不是在create pluggable database时