本文共 1244 字,大约阅读时间需要 4 分钟。
Oracle 12c 中通过查询dba_pdb_hostory视图,可以了解PDB数据库的一些信息。
SQL> desc dba_pdb_history; 名称 (类型等信息省略...) ---------------------------- PDB_NAME PDB_ID PDB_DBID PDB_GUID OP_SCNBAS OP_SCNWRP OP_TIMESTAMP OPERATION DB_VERSION CLONED_FROM_PDB_NAME CLONED_FROM_PDB_DBID CLONED_FROM_PDB_GUID DB_NAME DB_UNIQUE_NAME DB_DBID CLONETAG DB_VERSION_STRING
通过下面的查询语句,可以查看PDB数据库的名字、操作等。
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;
SQL> col pdb_name format a30;SQL> select pdb_name, status from cdb_pdbs;PDB_NAME STATUS------------------------------ ----------BEANPDB NORMALPDB$SEED NORMALSQL> SELECT con_id,NAME,OPEN_MODE,restricted from v$PDBS; CON_ID NAME OPEN_MODE RES---------- -------------------- ---------- --- 2 PDB$SEED READ ONLY NO 3 BEANPDB READ WRITE YES
(完)
转载地址:http://sktdi.baihongyu.com/