oracle数据库状态查询

《oracle数据库状态查询》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、1状态查询启动状态SQL语句结果nomountselectstatusfromv$instance;STARTEDselectopen_modefromv$database;ERRORatline1:ORA-01507:databasenotmountedmountselectstatusfromv$instance;MOUNTEDselectopen_modefromv$database;MOUNTEDopenselectstatusfromv$instance;OPENselectopen_modefromv$da

2、tabase;READWRITE或者READONLY2实验过程SQL>startupnomount;ORACLEinstancestarted.TotalSystemGlobalArea125829120bytesFixedSize1247684bytesVariableSize92276284bytesDatabaseBuffers25165824bytesRedoBuffers7139328bytesSQL>selectstatusfromv$instance;STATUS------------STARTEDSQ

3、L>selectopen_modefromv$database;selectopen_modefromv$database*ERRORatline1:ORA-01507:databasenotmountedSQL>alterdatabasemount;Databasealtered.SQL>selectstatusfromv$instance;STATUS------------MOUNTEDSQL>selectopen_modefromv$database;OPEN_MODE----------MOUNTEDSQL>

4、alterdatabaseopen;Databasealtered.SQL>selectstatusfromv$instance;STATUS------------OPENSQL>selectopen_modefromv$database;OPEN_MODE----------READWRITE