资源描述
快速掌握重启Oracle数据库的操作步骤摘要在实际的应用中,有时候工作数据库需要重新启动。本文介绍了一个特别实用的操作步骤,希望对大家有所帮助。关键字Oracle重启在实际的应用中,有时候工作数据库需要重新启动。本文介绍了一个特别实用的操作步骤,希望对大家有所帮助。1. 停应用层的各种程序2. 停Oralce的监听进程$ Isnrctl stop3. 在独占的系统用户下,备份控制文件:$ sqlplus /as sysdbaSQL alter database backup controlfile to trace;4. 在独占的系统用户下,手工切换重作日志文件,确保当前已修改过的数据存入文件:SQL alter system switch logfile;5. 在独占的系统用户下,运行下面SQL语句,生成杀数据库用户连接的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.在独占的系统用户下,执行杀数据库用户连接的kill_session.sql文件SQL ./kill_session.sql7.在独占的系统用户下,用immediate方式关闭数据库:SQL shutdown immediate;或者SVRMGRL shutdown immediate;8.启动oralce的监听进程$ lsnrctl start9.进入独占的系统用户下,启动Oralce数据库$ sqlplus /nologSQL connect / as sysdba或者$ svrmgrlSVRMGRL connect internal;SVRMGRL startup;10.启动应用层的各种程序-在服务器上执行sqlplus /as sysdbaSQLalter system checkpoint;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, 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 Mining and Real Application Testing optionsyou have mail in /var/mail/oraclenmyz2$/oracle回复更多评论
展开阅读全文