PDB创建之后,它的生命周期中最简单的事件就是启动和关闭。在实际操作中,对PDB的操作要远远比启动和关闭复杂,cdb_pdb_history视图提供了对这个内容进行回顾的方法。
SQL> col pdb_name format a10
SQL> select pdb_name,op_timestamp,operation from cdb_pdb_history order by 2;
PDB_NAME OP_TIMEST OPERATION
---------- --------- ----------------
PDB$SEED 26-JAN-17 UNPLUG
PDB$SEED 26-JAN-17 UNPLUG
PDB$SEED 26-JAN-17 DROP
PDB$SEED 18-MAR-19 PLUG
PDB$SEED 18-MAR-19 PLUG
ORCLPDB1 18-MAR-19 CREATE
ORCLPDB2 18-MAR-19 CREATE
ORCLPDB2 18-MAR-19 CREATE
ORCLPDB3 18-MAR-19 CREATE
LKAPP_ROOT 11-APR-19 CREATE
LKAPP_ONE 11-APR-19 CREATE
PDB_NAME OP_TIMEST OPERATION
---------- --------- ----------------
LKAPP_TWO 11-APR-19 CREATE
LKAPP_TWO 17-APR-19 DROP
LKAPP_ONE 17-APR-19 DROP
LKAPP_ROOT 17-APR-19 DROP
ORCLPDB3 17-APR-19 DROP
16 rows selected.