欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页

oracle12C 随CDB启动PDB数据库  

程序员文章站 2022-04-02 23:18:15
...
1.确保oracle已经启动
SQL> startup
ORA-01081: 无法启动已在运行的 ORACLE - 请先将其关闭
或者
ORACLE 例程已经启动。

Total System Global Area  805306368 bytes
Fixed Size                  3050800 bytes
Variable Size             394265296 bytes
Database Buffers          297795584 bytes
Redo Buffers                5337088 bytes
In-Memory Area            104857600 bytes
数据库装载完毕。
数据库已经打开。
2.查询dba_pdb_saved_states无记录
SQL> select con_name, state from dba_pdb_saved_states;
未选定行
3.在数据库mount状态下save state
show pdbs;
  CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDBORCL                        MOUNTED
4.查询dba_pdb_saved_states无记录
SQL> select con_name, state from dba_pdb_saved_states;

未选定行
5.在数据库mount状态下save state
ALTER PLUGGABLE DATABASE PDBORCL save state;
插接式数据库已变更。
select con_name, state from dba_pdb_saved_states;

未选定行
pdb为mount状态下,执行save state无记录,证明save state不成功

6在数据库open状态下save state—-设置pdb随cdb启动

SQL> ALTER PLUGGABLE DATABASE PDBORCL save state;

插接式数据库已变更。

SQL> select con_name, state from dba_pdb_saved_states;

CON_NAME
---------------------------------------------------------------

STATE
--------------
PDBORCL
OPEN
pdb为open状态下,执save state成功.
需要注意save state需要在pdb open情况下执行才能够生效.

3.重启数据库测试pdb随cdb启动