Oracle基础知识第三讲.pptVIP

* * * * * * * * * * * * * 二零一零年六月 第一页，共二十五页。 目标 学习此章，需要掌握以下知识: 启停 Enterprise Manager Database Control 启停 Oracle Listener 启停 Oracle Database 10g 了解数据库日志文件和初始化参数文件 第二页，共二十五页。 管理架构 ORACLE10G数据库的管理架构由三部分组成： 数据实例 Listener 管理工具 Database Control Management agent (when using Grid Control) Listener Database Control Management agent Management interface -or- 第三页，共二十五页。 启停 Database Control $ emctl start dbconsole TZ set to US/Pacific Oracle Enterprise Manager 10g Database Control Release .0 Copyright (c) 1996, 2004 Oracle Corporation. All rights reserved. :5500/em/console/aboutApplication Starting Oracle Enterprise Manager 10g Database Control started. Logs are generated in directory /u01/app/oracle/product/10.1.0/db_1/_orcl/sysman/log $ emctl stop dbconsole TZ set to US/Pacific Oracle Enterprise Manager 10g Database Control Release .0 Copyright (c) 1996, 2004 Oracle Corporation. All rights reserved. :5500/em/console/aboutApplication Stopping Oracle Enterprise Manager 10g Database Control ... ... Stopped. 第四页，共二十五页。 访问Database Control 第五页，共二十五页。 SYSOPER 和SYSDBA 第六页，共二十五页。 Database Home Page 第七页，共二十五页。 改变 Listener 状态 第八页，共二十五页。 启动和停止 Click Advanced Options to select startup options and shutdown mode 第九页，共二十五页。 启动数据库－NOMOUNT OPEN MOUNT NOMOUNT SHUTDOWN Instance started STARTUP 第十页，共二十五页。 启动数据库－MOUNT OPEN MOUNT NOMOUNT SHUTDOWN Control file opened for this instance Instance started STARTUP SHUTDOWN 第十一页，共二十五页。 启动数据库－OPEN OPEN MOUNT NOMOUNT SHUTDOWN All files opened as described by the control file for this instance Control file opened for this instance Instance started STARTUP SHUTDOWN 第十二页，共二十五页。 停止数据库 Shutdown mode: A = ABORT I = IMMEDIATE T = TRANSACTIONAL N = NORMAL A No No No No T No No Yes Yes I No No No Yes Shutdown Mode Allow new connections Wait until current sessions end Wait until current transactions end Force a checkpoint and close files N No Yes Yes Yes 第十三页，共二十五页。 SHUTDOWN 选项 此种方式停止: 数据缓冲区的内容已经写回数据文件 未提交事务进行回滚 资源被释放 此种方式启动: 无须进行实例恢复 During SHUTDOWN