Oracle啟動(dòng)停止規(guī)范

本啟動(dòng)停止規(guī)范適用于單實(shí)例數(shù)據(jù)庫。

一. 啟動(dòng)數(shù)據(jù)庫:

sqlplus / as sysdba
SQL> startup

啟動(dòng)成功后，啟動(dòng)監(jiān)聽
lsnrctl status
啟動(dòng)監(jiān)聽后，動(dòng)態(tài)監(jiān)聽需要等待一分鐘左右，才可以將服務(wù)注冊(cè)成功。或手動(dòng)在SQLPLUS中發(fā)出alter system register;

二. 關(guān)閉數(shù)據(jù)庫：

1. 應(yīng)用停掉

2. 停監(jiān)聽器
   ps -ef|grep LOCAL|wc -l
   [oracle@r11g ~]$ lsnrctl stop

3. 查看有沒有JOB--如有需要確定是否停掉
   ps -ef|grep ora_j

4. 查看有沒有事務(wù)還未提交的--如有事務(wù)未提交確認(rèn)是否需要等待事務(wù)完成
   sqlplus '/ as sysdba'
   select instance_name,status from v$instance;
   select open_mode,name from v$database;

是否有大的查詢?cè)谶M(jìn)行
select count() from v$transaction;
select count() from v$session_longops where time_remaining>0;

是否有大的事務(wù)在進(jìn)行
select sum(used_ublk) from v$transaction; ---如果有大量返回，參考本文最后
select to_char(start_time,'yyyy/mm/dd hh34:mi:ss') start_t from v$transaction;

是否有事務(wù)需要在數(shù)據(jù)庫OPEN時(shí)進(jìn)行實(shí)例恢復(fù)
select from v$fast_start_transactions;
and/or
select from v$fast_start_servers;

5. 手工切換log
   SQL> alter system switch logfile;
   SQL> /
   System altered.
   SQL> /
   System altered.

6. 做checkpoint
   目的是把臟數(shù)據(jù)寫入數(shù)據(jù)文件，避免造成數(shù)據(jù)丟失，減小關(guān)閉啟動(dòng)不起來這種現(xiàn)象發(fā)生
   SQL> alter system checkpoint;
   SQL> /
   System altered.
   SQL> /
   System altered.
   SQL> /
   System altered

7. 關(guān)庫
   SQL> shutdown immediate;