oracle 12c如何检查pdb数据库状态

这篇文章主要为大家展示了"oracle 12c如何检查pdb数据库状态"，内容简而易懂，条理清晰，希望能够帮助大家解决疑惑，下面让小编带领大家一起研究并学习一下"oracle 12c如何检查pdb数据库状态"这篇文章吧。

日常工作需要记住这两个视图，检查pdb状态

$sqlplus / as sysdbaSQL*Plus: Release 12.1.0.2.0 Production on Sat Jan 20 17:52:42 2018Copyright (c) 1982, 2014, Oracle.  All rights reserved.Connected to:Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit ProductionWith the Partitioning, OLAP, Advanced Analytics and Real Application Testing optionsSQL> show con_nameCON_NAME------------------------------CDB$ROOTSQL> desc cdb_pdbs; Name                                      Null?    Type ----------------------------------------- -------- ---------------------------- PDB_ID                                    NOT NULL NUMBER PDB_NAME                                  NOT NULL VARCHAR2(128) DBID                                      NOT NULL NUMBER CON_UID                                   NOT NULL NUMBER GUID                                               RAW(16) STATUS                                             VARCHAR2(9) CREATION_SCN                                       NUMBER VSN                                                NUMBER LOGGING                                            VARCHAR2(9) FORCE_LOGGING                                      VARCHAR2(3) FORCE_NOLOGGING                                    VARCHAR2(3) CON_ID                                    NOT NULL NUMBERSQL> col pdb_name for a30SQL> select pdb_id,pdb_name,status from cdb_pdbs;    PDB_ID PDB_NAME                       STATUS---------- ------------------------------ ------------------         2 PDB$SEED                       NORMAL         3 PDB1                           NORMAL         4 PDB2                           NORMAL         5 PDB3                           NORMAL         6 PDB4                           NORMALSQL> desc v$pdbs; Name                                      Null?    Type ----------------------------------------- -------- ---------------------------- CON_ID                                             NUMBER DBID                                               NUMBER CON_UID                                            NUMBER GUID                                               RAW(16) NAME                                               VARCHAR2(30) OPEN_MODE                                          VARCHAR2(10) RESTRICTED                                         VARCHAR2(3) OPEN_TIME                                          TIMESTAMP(3) WITH TIME ZONE CREATE_SCN                                         NUMBER TOTAL_SIZE                                         NUMBER BLOCK_SIZE                                         NUMBER RECOVERY_STATUS                                    VARCHAR2(8) SNAPSHOT_PARENT_CON_ID                             NUMBERSQL> set line 200SQL> select con_id,name,open_mode from v$pdbs;    CON_ID NAME                                                         OPEN_MODE---------- ------------------------------------------------------------ --------------------         2 PDB$SEED                                                     READ ONLY         3 PDB1                                                         READ WRITE         4 PDB2                                                         READ WRITE         5 PDB3                                                         READ WRITE         6 PDB4                                                         READ WRITESQL>

以上是"oracle 12c如何检查pdb数据库状态"这篇文章的所有内容，感谢各位的阅读！相信大家都有了一定的了解，希望分享的内容对大家有所帮助，如果还想学习更多知识，欢迎关注行业资讯频道！