oracle之nomount、mount、open三种状态
2024-10-18 22:34:53
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
最新文章
- java .bat批处理（java cmd命令）
- Git使用指南（2）——工作区，暂存区，版本库
- Xamarin开发Android笔记：拍照或相册选取图片角度问题
- Sqlserver推荐参数配置及日志收缩问题
- H5实现的可自定义贪吃蛇游戏
- uTenux-OS-Task再探
- Linux Shell脚本攻略 读书笔记
- POJ 3312 Mahershalalhashbaz, Nebuchadnezzar, and Billy Bob Benjamin Go to the Regionals (水题，贪心)
- 使用Yeoman搭建 AngularJS 应用 (3) —— 让我们搭建一个网页应用
- rowid的作用
- CentOS7安装Hadoop2.7流程
- 常用CSS样式 持续更新
- 点击空白处隐藏指定dom元素（纯javascript方法）
- HTTP协议Keep-Alive模式详解
- 创建文件DSN
- OSGi类加载流程
- [Codeforces702F]T-Shirts——非旋转treap+贪心
- 指导手册06：HBase安装部署
- poi读取excel内容工具类
- arguments.callee 和 caller