How to Preserve Open Mode of PDBs When the CDB Restarts (Doc ID 1933511.1)
- [oracle@db12cr2 ~]$ sqlplus / as sysdba
- sql*Plus: Release 12.2.0.1.0 Production on Wed Mar 8 01:56:25 2017
- Copyright (c) 1982,2016,Oracle. All rights reserved.
- Connected to:
- Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
- sql>
- sql> set lines 300
- sql> column NAME format a30
- sql> col pdb format a30
- sql> select PDB,INST_ID,NAME from gv$services order by 1;
- PDB INST_ID NAME
- ------------------------------ ---------- ------------------------------
- CDB$ROOT 1 orclXDB
- CDB$ROOT 1 orcl
- CDB$ROOT 1 SYS$BACKGROUND
- CDB$ROOT 1 SYS$USERS
- HIGHGO1 1 highgo1--------->>>注意此处
- HIGHGO2 1 highgo2--------->>>注意此处
- HIGHGO3 1 highgo3--------->>>注意此处
- 7 rows selected.
- sql> select CON_ID,NAME,OPEN_MODE from V$PDBS;
- CON_ID NAME OPEN_MODE
- ---------- ------------------------------ ----------
- 2 PDB$SEED READ ONLY
- 3 HIGHGO1 MOUNTED--------->>>注意此处
- 4 HIGHGO2 MOUNTED--------->>>注意此处
- 5 HIGHGO3 MOUNTED--------->>>注意此处
- sql>
- sql> alter pluggable database highgo1 open;
- Pluggable database altered.
- sql> set lines 300
- sql> column NAME format a30
- sql> col pdb format a30
- sql> select CON_ID,OPEN_MODE from V$PDBS;
- CON_ID NAME OPEN_MODE
- ---------- ------------------------------ ----------
- 2 PDB$SEED READ ONLY
- 3 HIGHGO1 READ WRITE
- 4 HIGHGO2 MOUNTED
- 5 HIGHGO3 MOUNTED
- sql> alter pluggable database highgo1 save state;---->>注意此命令(其实此命令从12.1.0.2开始就有了).
- Pluggable database altered.
- sql>
- sql> exit
- Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
- [oracle@db12cr2 ~]$ exit
- logout
- [root@db12cr2 ~]# init 6 --------该命令仅限试验,后果自负------>>>重启os
- [root@db12cr2 ~]#
- [root@db12cr2 ~]#
- Connection closed by foreign host.
- Disconnected from remote host(192.168.80.12) at 16:01:09.
- Type `help' to learn how to use Xshell prompt.
- [c:\~]$
- Disconnected from remote host(192.168.80.12) at 16:01:09.
- Type `help' to learn how to use Xshell prompt.
- [c:\~]$
- Connecting to 192.168.80.12:22...
- Connection established.
- To escape to local shell,press 'Ctrl+Alt+]'.
- Last login: Wed Mar 8 05:37:33 2017 from 192.168.80.1
- [root@db12cr2 ~]# su - oracle
- [oracle@db12cr2 ~]$ sqlplus / as sysdba
- sql*Plus: Release 12.2.0.1.0 Production on Wed Mar 8 06:33:09 2017
- Copyright (c) 1982,Oracle. All rights reserved.
- Connected to an idle instance.
- sql> startup
- ORACLE instance started.
- Total System Global Area 587202560 bytes
- Fixed Size 8795424 bytes
- Variable Size 348130016 bytes
- Database Buffers 222298112 bytes
- Redo Buffers 7979008 bytes
- Database mounted.
- Database opened.
- sql> set lines 300
- sql> column NAME format a30
- sql> col pdb format a30
- sql> select CON_ID,OPEN_MODE from V$PDBS;
- CON_ID NAME OPEN_MODE
- ---------- ------------------------------ ----------
- 2 PDB$SEED READ ONLY
- 3 HIGHGO1 READ WRITE -------------->>>pdb状态.
- 4 HIGHGO2 MOUNTED
- 5 HIGHGO3 MOUNTED
- sql> select PDB,NAME from gv$services order by 1;
- PDB INST_ID NAME
- ------------------------------ ---------- ------------------------------
- CDB$ROOT 1 orclXDB
- CDB$ROOT 1 orcl
- CDB$ROOT 1 SYS$BACKGROUND
- CDB$ROOT 1 SYS$USERS
- HIGHGO1 1 highgo1
- HIGHGO2 1 highgo2
- HIGHGO3 1 highgo3
- 7 rows selected.
- sql>