首页 > 代码库 > oracle之nomount、mount、open三种状态
oracle之nomount、mount、open三种状态
1.先来看下外国网站上的资料怎么说
- Nomount – The database instance has been started (processes and memory structures have been allocated, but control file is not yet accessed). 数据库实例已经开始(进程和内存已经分配,但是控制文件还没有启动)
- Mount – Instance has accessed the control file, but has not yet validated its entry or accessed the datafiles. 实例已经开启控制文件,但是还没有开启数据文件
- Open – Instance has validated the entries in the control files and is accessing the datafiles – it is now open for business. 开启数据文件
2.nomount阶段
- read the spfileSID.ora initSID.ora
- Allocating the SGA
- Starting the background processes
- Opening the alertSID.log file and the trace files
3.mount阶段
- Associating a database with a previously started instance
- Locating and opening the control files specified in the parameter file
- Reading the control files to obtain the names and status of the data files and online redo log files.However,no checks are performed to verify the existence of the data files and online redo log files at this time.
4.open状态
- opening the online datafiles
- opening the online redologs
oracle之nomount、mount、open三种状态
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。