数据库启动之MOUNT
来源:互联网 发布:mac抹掉磁盘后开机没用 编辑:程序博客网 时间:2024/05/22 11:54
How a Database Is Mounted
The instance mounts a database to associate the database with this instance. To mount the database, the instance obtains the names of the database control files specified in the CONTROL_FILES
initialization parameter and opens the files. Oracle Database reads the control files to find the names of the data files and the online redo log files that it will attempt to access when opening the database.
In a mounted database, the database is closed and accessible only to database administrators. Administrators can keep the database closed while completing specific maintenance operations. However, the database is not available for normal operations.
If Oracle Database allows multiple instances to mount the same database concurrently, then the CLUSTER_DATABASE
initialization parameter setting can make the database available to multiple instances. Database behavior depends on the setting:
If
CLUSTER_DATABASE
isfalse
(default) for the first instance that mounts a database, then only this instance can mount the database.If
CLUSTER_DATABASE
istrue
for the first instance, then other instances can mount the database if theirCLUSTER_DATABASE
parameter settings are set totrue
. The number of instances that can mount the database is subject to a predetermined maximum specified when creating the database.
See Also:
Oracle Database Administrator's Guide to learn how to mount a database
Oracle Real Application Clusters Administration and Deployment Guide for more information about the use of multiple instances with a single database
实例挂载
mount状态下实例与数据库发生关联。挂载数据库,实例从初始化变量CONTROL_FILES中获取数据库控制文件并打开之。数据库读取控制文件,找到数据文件和联机重做日志文件的名字,它会尝试打开数据库时访问。
mount状态情况下,数据库是关闭的,并且只有数据库管理员可以访问。完成特定的维护操作的同时,管理员可以保持数据库关闭。然而,一般的数据库操作还是不允许的。
如果数据库允许同时挂载多个实例,那么可以用初始化变量CLUSTER_DATABASE设置;依据下列设置:
如果第一个实例挂载数据库时初始化变量CLUSTER_DATABASE 设置为FALSE(默认设置),那么仅只有该实例可以挂载到数据库上
如果第一个实例挂载数据库时初始化变量CLUSTER_DATABASE 设置为TRUE,那么其他的实例的初始化变量CLUSTER_DATABASE如果也设置为TRUE,这些实例也可以挂载到该数据库上。数据库能够被挂在的实例数量是根据数据库创建的时候预定义的最大数量。
- 数据库启动之MOUNT
- 数据库启动之MOUNT
- 数据库启动关闭原理之:mount状态浅析
- Oracle启动之二 启动到mount
- Oracle启动数据库的三个台阶nomount,mount,open
- 实验46:启动数据库的三个台阶nomount,mount,open
- 数据库启动的三个台阶nomount,mount,open
- 数据库启动的三个台阶nomount,mount,open
- oracle数据库启动cannot mount database in EXCLUSIVE mode
- Linux启动自动mount
- Linux启动自动mount
- Linux启动自动mount
- 数据库启动之NOMOUNT
- 数据库启动之OPEN
- 数据库启动之NOMOUNT
- 数据库启动之OPEN
- startup mount;startup nomount;startup 这三个启动数据库的语句有什么区别?
- 启动oracle数据库报错:cannot mount database in exclusive mode
- Application.EnableVisualStyles()的作用
- IIS写权限利用续以及写权限漏洞来由解释
- SPOJ Finding Fractions
- 设计模式18种
- 学习就是一件要耐的住寂寞放的下欲望舍的得享乐的事
- 数据库启动之MOUNT
- ubuntu 源
- light oj 1274 - Beating the Dataset
- android BaseAdapter(修改优化)
- 选股公式
- CH8 指针和基于指针的字符串
- linux ---- 进程 --- 1
- maven 入门
- 优先队列——二叉堆实现