首页 > 数据库 > 数据库开发技术 > Close a Database (303)

Close a Database (303)

原创 数据库开发技术 作者:tsinglee 时间:2007-12-03 09:13:24 0 删除 编辑

When you close a database, Oracle writes all database data and recovery data in the
SGA to the datafiles and redo log files, respectively. Next, Oracle closes all online
datafiles and redo log files. (Any offline datafiles of any offline tablespaces have been
closed already. If you subsequently reopen the database, any tablespace that was
offline and its datafiles remain offline and closed, respectively.) At this point, the
database is closed and inaccessible for normal operations. The control files remain
open after a database is closed but still mounted.

1. 关闭数据库时,Oracle 将 SGA 内的数据库数据及恢复数据分别写入数据文件和重做日志文件
2. 接下来 , Oracle 关闭所有联机的数据文件及重做日志文件
3. 在数据库已经关闭但仍旧装载时,控制文件还是处于打开状态


来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
  • 博文量
  • 访问量