首页 > 数据库 > 数据库开发技术 > What Happens When You Open a Database (297)

What Happens When You Open a Database (297)

原创 数据库开发技术 作者:tsinglee 时间:2007-12-02 15:23:20 0 删除 编辑

Opening a mounted database makes it available for normal database operations. Any
valid user can connect to an open database and access its information. Usually, a
database administrator opens the database to make it available for general use.

When you open the database, Oracle opens the online datafiles and redo log files. If a
tablespace was offline when the database was previously shut down, the tablespace
and its corresponding datafiles will still be offline when you reopen the database.

If any of the datafiles or redo log files are not present when you attempt to open the
database, then Oracle returns an error. You must perform recovery on a backup of any
damaged or missing files before you can open the database.

1. 打开数据库时,Oracle 将打开所有联机的数据文件及重做日志文件
2. 在数据库之前offline的表空间,在数据库重新打开之后该表空间及他关联的数据文件依然为offline状态
3. 如果 Oracle 在打开数据库时找不到所需的数据文件或重做日志文件,系统将返回错误信息.


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

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