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
根据上面的alert日志,能断定:Oracle 在open一个插入的pdb时向cdb$root中插入datafile信息,而不是在create pluggable database时
原文链接:https://www.f2er.com/oracle/209914.html