1、SQL>startup mount

數(shù)據(jù)庫進(jìn)入mount狀態(tài)，只可以讀取控制文件信息，不可以讀取數(shù)據(jù)文件信息；

2、SQL>alter database open

將數(shù)據(jù)庫切換到open狀態(tài)

3、查詢數(shù)據(jù)庫狀態(tài)

SQL> select dbid,name,switchover_status,db_unique_name,database_role,open_mode,current_scn from v$database;DBID NAME SWITCHOVER_STATUS DB_UNIQUE_NAME DATABASE_ROLE OPEN_MODE CURRENT_SCN ---------- --------- -------------------- ------------------------------ ---------------- -------------------- -----------724433656 DEVDB TO PRIMARY phydb PHYSICAL STANDBY MOUNTED 1545869 View Code

4、查看監(jiān)聽服務(wù)的狀態(tài)

11gdg-> id uid=1101(oracle) gid=1000(oinstall) groups=1000(oinstall),1200(asmadmin),1201(asmdba),1300(dba),1301(oper) 11gdg-> lsnrctl serviceLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 10-JUL-2013 18:28:23Copyright (c) 1991, 2011, Oracle. All rights reserved.Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) Services Summary... Service "+ASM" has 1 instance(s).Instance "+ASM", status READY, has 1 handler(s) for this service...Handler(s):"DEDICATED" established:0 refused:0 state:readyLOCAL SERVER Service "phydb" has 1 instance(s).Instance "phydb", status READY, has 1 handler(s) for this service...Handler(s):"DEDICATED" established:1347 refused:0 state:readyLOCAL SERVER Service "phydbXDB" has 1 instance(s).Instance "phydb", status READY, has 1 handler(s) for this service...Handler(s):"D000" established:0 refused:0 current:0 max:1022 state:readyDISPATCHER <machine: 11gdg.localdomain, pid: 2176>(ADDRESS=(PROTOCOL=tcp)(HOST=11gdg.localdomain)(PORT=60468)) The command completed successfully 11gdg-> View Code

5、將數(shù)據(jù)庫置于read only狀態(tài).?

SQL> startup mount; ORACLE instance started.Total System Global Area 430075904 bytes Fixed Size 2229064 bytes Variable Size 339741880 bytes Database Buffers 79691776 bytes Redo Buffers 8413184 bytes Database mounted. SQL> select open_mode from v$database;OPEN_MODE -------------------- MOUNTEDSQL> alter database open read only;Database altered.SQL> select open_mode from v$database;OPEN_MODE -------------------- READ ONLY View Code

6、查看數(shù)據(jù)庫當(dāng)前的scn

SQL> select current_scn from v$database;CURRENT_SCN -----------4222245SQL> show user USER is "SYS" SQL> View Code

?

?

?

轉(zhuǎn)載于:https://www.cnblogs.com/arcer/archive/2013/03/28/2976663.html

總結(jié)

以上是生活随笔為你收集整理的oracle status的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。