检查pdb的状态

最新推荐文章于 2024-04-18 05:24:26 发布

msdnchina

最新推荐文章于 2024-04-18 05:24:26 发布

阅读量1.6k

点赞数

分类专栏： Oracle DB 12c Oracle DB 12c新特性文章标签： pdb unplug plug record

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

版权

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

62 篇文章 0 订阅

订阅专栏

Oracle DB 12c新特性

39 篇文章 8 订阅

订阅专栏

SQL> set lines 300
SQL> alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
SQL> col pdb_name format a10
SQL> col db_name format a10
SQL> col db_unique_name format a20
SQL> col db_version_string format a20
SQL> select pdb_name,pdb_id,pdb_dbid,pdb_guid,OP_TIMESTAMP,operation,
  2  db_version,db_name,db_unique_name,db_dbid,db_version_string 
  3  from dba_pdb_history order by OP_TIMESTAMP;

PDB_NAME       PDB_ID	PDB_DBID PDB_GUID			  OP_TIMESTAMP	      OPERATION        DB_VERSION DB_NAME    DB_UNIQUE_NAME	     DB_DBID DB_VERSION_STRING
---------- ---------- ---------- -------------------------------- ------------------- ---------------- ---------- ---------- -------------------- ---------- --------------------
PDB$SEED	    2 1476988726 4700A987085B3DFAE05387E5E50A8C7B 2017-01-26 15:30:12 UNPLUG		203424000 SEEDDATA   seeddata		  4262971485 12.2.0.1.0
PDB$SEED	    2 1476988726 4700A987085B3DFAE05387E5E50A8C7B 2017-01-26 15:30:41 DROP		203424000 SEEDDATA   seeddata		  4262971485 12.2.0.1.0
PDB$SEED	    2 3190971365 495000375B91A977E0530C50A8C0EB56 2017-02-25 07:22:18 PLUG		203424000 ORCL	     orcl		  1464642271 12.2.0.1.0
HIGHGO1 	    3  160143870 49504EFFCB3FBEECE0530C50A8C043CE 2017-02-25 07:44:19 CREATE		203424000 ORCL	     orcl		  1464642271 12.2.0.1.0
HIGHGO2 	    4 2222399776 4950599A41E6C0B8E0530C50A8C09F64 2017-02-25 07:47:18 CREATE		203424000 ORCL	     orcl		  1464642271 12.2.0.1.0
HIGHGO3 	    5 3441782034 4950663E26DEC28CE0530C50A8C05578 2017-02-25 07:50:50 CREATE		203424000 ORCL	     orcl		  1464642271 12.2.0.1.0
HIGHGO1 	    3  160143870 49504EFFCB3FBEECE0530C50A8C043CE 2017-03-24 11:15:57 UNPLUG		203424000 ORCL	     orcl		  1464642271 12.2.0.1.0

7 rows selected.

SQL>

SQL> col pdb_name format a30
SQL>  select pdb_name, status from cdb_pdbs;

PDB_NAME		       STATUS
------------------------------ ----------
HIGHGO1 		       UNPLUGGED
PDB$SEED		       NORMAL
HIGHGO2 		       NORMAL
HIGHGO3 		       NORMAL

SQL>