Oracle 12C -- CDB的启动过程
2024-08-27 22:21:46
以启动DB12为例子
$ sqlplus '/as sysdba'
SQL*Plus: Release 12.1.0.2. Production on Sun Nov :: Copyright (c) , , Oracle. All rights reserved. Connected to an idle instance.
1.nomount阶段
SQL> startup nomount;
ORACLE instance started. Total System Global Area bytes
Fixed Size bytes
Variable Size bytes
Database Buffers bytes
Redo Buffers bytes
SQL> select name,open_mode from v$pdbs; no rows selected
2.mount阶段:打开控制文件,Root和pdbs都被mount起来
SQL> alter database db12 mount; Database altered. SQL> select name,open_mode from v$pdbs; NAME OPEN_MODE
------------------------------ ----------
PDB$SEED MOUNTED
PDB1 MOUNTED
PDB2 MOUNTED
3.open阶段:root被打开,pdbs仍然是mounted状态,seed pdb处于只读状态
SQL> alter database db12 open; Database altered. SQL> select name,open_mode from v$pdbs; NAME OPEN_MODE
------------------------------ ----------
PDB$SEED READ ONLY
PDB1 MOUNTED
PDB2 MOUNTED
4.打开PDB
SQL> connect sys@pdb1 as sysdba
Enter password:
Connected.
SQL> alter pluggable database pdb1 open; Pluggable database altered. SQL> select name,open_mode from v$pdbs; NAME OPEN_MODE
------------------------------ ----------
PDB1 READ WRITE SQL>
最新文章
- PAT/字符串处理习题集(二)
- IOS开发基础知识--碎片39
- ubuntu下的ssh
- STM32的GPIO
- Myeclipse+Tomcat安装与配置
- bzoj4033
- IIS发布mvc程序遇到的HTTP错误 403.14-Forbidden解决办法
- Zookeeper 快速入门(上)
- 解决vuecli3.0构建的vue2.0项目在IE9可能出现的兼容性问题
- AngularJS 1.x系列:AngularJS过滤器(4)
- 调参贝叶斯优化(BayesianOptimization)
- docker笔记(2)-----容器连接
- EasyUIDataGrid去掉垂直滚动条
- [Python设计模式] 第28章 男人和女人——访问者模式
- Eclipse Debug不能热部署解决
- Excel的快速录入
- Windows server 安装和配置zabbix agent
- js防止表单重复提交
- deep learning loss总结
- 防止putty的鼠标右键错误粘贴