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

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

<roidb01:cdb:/home/oracle>$sqlplus/assysdbaSQL*Plus:Release12.1.0.2.0ProductiononSatJan2017:52:422018Copyright(c)1982,2014,Oracle.Allrightsreserved.Connectedto:OracleDatabase12cEnterpriseEditionRelease12.1.0.2.0-64bitProductionWiththePartitioning,OLAP,AdvancedAnalyticsandRealApplicationTestingoptionsSQL>showcon_nameCON_NAME------------------------------CDB$ROOTSQL>desccdb_pdbs;NameNull?Type-----------------------------------------------------------------------------PDB_IDNOTNULLNUMBERPDB_NAMENOTNULLVARCHAR2(128)DBIDNOTNULLNUMBERCON_UIDNOTNULLNUMBERGUIDRAW(16)STATUSVARCHAR2(9)CREATION_SCNNUMBERVSNNUMBERLOGGINGVARCHAR2(9)FORCE_LOGGINGVARCHAR2(3)FORCE_NOLOGGINGVARCHAR2(3)CON_IDNOTNULLNUMBERSQL>colpdb_namefora30SQL>selectpdb_id,pdb_name,statusfromcdb_pdbs;PDB_IDPDB_NAMESTATUS----------------------------------------------------------2PDB$SEEDNORMAL3PDB1NORMAL4PDB2NORMAL5PDB3NORMAL6PDB4NORMALSQL>descv$pdbs;NameNull?Type-----------------------------------------------------------------------------CON_IDNUMBERDBIDNUMBERCON_UIDNUMBERGUIDRAW(16)NAMEVARCHAR2(30)OPEN_MODEVARCHAR2(10)RESTRICTEDVARCHAR2(3)OPEN_TIMETIMESTAMP(3)WITHTIMEZONECREATE_SCNNUMBERTOTAL_SIZENUMBERBLOCK_SIZENUMBERRECOVERY_STATUSVARCHAR2(8)SNAPSHOT_PARENT_CON_IDNUMBERSQL>setline200SQL>selectcon_id,name,open_modefromv$pdbs;CON_IDNAMEOPEN_MODE------------------------------------------------------------------------------------------2PDB$SEEDREADONLY3PDB1READWRITE4PDB2READWRITE5PDB3READWRITE6PDB4READWRITESQL>

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