PDB

show pdbs;

--切换container
alter session set container=orclpdb;

alter session set container=cdb$root;

alter session set container=pdb$seed;

--切换到root
alter pluggable database orclpdb close;
alter pluggable database orclpdb open;

--切换到pdb
alter database  close;
alter database  open;

--保持某些pdb起库时就打开状态
SQL> startup
ORACLE instance started.
Total System Global Area 1090519040 bytes
Fixed Size     2923440 bytes
Variable Size   704644176 bytes
Database Buffers   369098752 bytes
Redo Buffers    13852672 bytes
Database mounted.
Database opened

SQL> select NAME,CON_ID,OPEN_MODE   from v$pdbs;
NAME  CON_ID OPEN_MODE
---------------------------------------------------------------------
PDB$SEED       2 READ ONLY
PDBORCL      3 READ WRITE
PDB4       4 MOUNTED
PDB5       5 MOUNTED
PDB6       6 MOUNTED
QL> alter pluggable database pdb4 open;
Pluggable database altered.

SQL> select NAME,CON_ID,OPEN_MODE   from v$pdbs;
NAME  CON_ID OPEN_MODE
------------------------------------------------------------------
PDB$SEED       2 READ ONLY
PDBORCL      3 READ WRITE
PDB4       4 READ WRITE
PDB5       5 MOUNTED
PDB6       6 MOUNTED

--保持CDB重启后PDB的状态
alter pluggable database all save state;

shut immediate;
startup
SQL> select name,OPEN_MODE from v$pdbs;
NAME      OPEN_MODE
-----------------------------------------------------------
PDB$SEED      READ ONLY
PDBORCL     READ WRITE
PDB4      READ WRITE
PDB5      MOUNTED
PDB6      MOUNTED