快速掌握重啟Oracle數(shù)據(jù)庫的操作步驟

1、快速掌握重啟Oracle數(shù)據(jù)庫的操作步驟摘要在實際的應(yīng)用中，有時候工作數(shù)據(jù)庫需要重新啟動。本文介紹了一個特別實用的操作步驟，希望對大家有所幫助。關(guān)鍵字Oracle重啟在實際的應(yīng)用中，有時候工作數(shù)據(jù)庫需要重新啟動。本文介紹了一個特別實用的操作步驟，希望對大家有所幫助。停應(yīng)用層的各種程序停Oralce的監(jiān)聽進程$ Isnrctl stop在獨占的系統(tǒng)用戶下，備份控制文件：$ sqlplus /as sysdbaSQL alter database backup controlfile to trace;在獨占的系統(tǒng)用戶下，手工切換重作日志文件，確保當前已修改過的數(shù)據(jù)存入文件：SQL alter s

2、ystem switch logfile;在獨占的系統(tǒng)用戶下，運行下面SQL語句，生成殺數(shù)據(jù)庫用戶連接的kill_all_session.sql文件：SQL set head off;SQL set feedback off;SQL spool ./kill_session.sqlserial# ; from v$session whereSQL select alter system kill session sid username is not null;SQL spool off;6.在獨占的系統(tǒng)用戶下，執(zhí)行殺數(shù)據(jù)庫用戶連接的kill_session.sql文件SQL ./kill_s

3、ession.sql7.在獨占的系統(tǒng)用戶下，用immediate方式關(guān)閉數(shù)據(jù)庫:SQL shutdown immediate;或者SVRMGRL shutdown immediate;8.啟動oralce的監(jiān)聽進程$ lsnrctl start9.進入獨占的系統(tǒng)用戶下，啟動Oralce數(shù)據(jù)庫$ sqlplus /nologSQL connect / as sysdba或者$ svrmgrlSVRMGRL connect internal;SVRMGRL startup;10.啟動應(yīng)用層的各種程序-在服務(wù)器上執(zhí)行sqlplus /as sysdbaSQLalter system checkpoi

4、nt;SQLshutdown immediate SQLstartup;nmyz2$/oraclesqlplus /as sysdbaSQL*Plus: Release 10.2.0.4.0 - Production on Tue Jan 4 09:39:52 2011Copyright (c) 1982, 2007, Oracle. All Rights Reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit ProductionWith the Partitioning,

5、 OLAP, Data Mining and Real Application Testing optionsSQL alter system checkpoint;System altered.SQL shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL SQL SQL startup;ORACLE instance started.Total System Global Area 1.9327E+10 bytesFixed Size 2103520 bytesVariable Size 2298480416 bytesDatabase Buffers 1.7012E+10 bytesRedo Buffers 14671872 bytesDatabase mounted.Database opened.SQL exitDisconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Min