oracle+启动pdb,PDB随CDB启动

下面的命令可以放pdb保持其关机前的状态，语法如下：

ALTER PLUGGABLE DATABASE [all]|[PDB_NAME] SAVE STATE;

取消设置的话，语法如下：

ALTER PLUGGABLE DATABASE [all]|[PDB_NAME] DISCARD STATE;

如：

alter pluggable database pdbrac1 save state;

alter pluggable database all discard state;

注意，savle state只是抓取当前的状态进行save，如果当前状态是mount，然后save state了。然后在open all pdb，再重启cdb，重启后只是会恢复到open all pdb之前的状态，即save state时的状态。

SQL> show con_name

CON_NAME

------------------------------

CDB$ROOT

SQL>

SQL> startup

ORACLE instance started.

Total System Global Area 1560281088 bytes

Fixed Size 2924784 bytes

Variable Size 1056968464 bytes

Database Buffers 486539264 bytes

Redo Buffers 13848576 bytes

Database mounted.

Database opened.

SQL> --最初时，2个pdb启动后状态都是mounted的。

SQL> select NAME,OPEN_MODE from v$pdbs;

NAME OPEN_MODE

------------------------------ ----------

PDB$SEED READ ONLY

PDBRAC1 MOUNTED

PDBRAC2 MOUNTED

SQL> alter pluggable database PDBRAC1 open;

Pluggable database altered.

SQL> alter pluggable database pdbrac1 save state;

Pluggable database altered.

SQL>

SQL>

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL>

SQL>

SQL>

SQL> startup

ORACLE instance started.

Total System Global Area 1560281088 bytes

Fixed Size 2924784 bytes

Variable Size 1056968464 bytes

Database Buffers 486539264 bytes

Redo Buffers 13848576 bytes

Database mounted.

Database opened.

SQL>

SQL>

SQL> --save state之后，PDBRAC1就是随cdb一起启动了。

SQL> select NAME,OPEN_MODE from v$pdbs;

NAME OPEN_MODE

------------------------------ ----------

PDB$SEED READ ONLY

PDBRAC1 READ WRITE

PDBRAC2 MOUNTED

SQL>

SQL> --如果是先save state，在open all，那么记录的状态只是在open all 之前的。

SQL> alter pluggable database all save state;

Pluggable database altered.

SQL> alter pluggable database all open;

Pluggable database altered.

SQL>

SQL>

SQL>

SQL>

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL>

SQL>

SQL>

SQL> startup

ORACLE instance started.

Total System Global Area 1560281088 bytes

Fixed Size 2924784 bytes

Variable Size 1056968464 bytes

Database Buffers 486539264 bytes

Redo Buffers 13848576 bytes

Database mounted.

Database opened.

SQL>

SQL> --因此重启cdb之后，也只是恢复save state时候的状态，即open all之前的，只有PDBRAC1打开的状态。

SQL> select NAME,OPEN_MODE from v$pdbs;

NAME OPEN_MODE

------------------------------ ----------

PDB$SEED READ ONLY

PDBRAC1 READ WRITE

PDBRAC2 MOUNTED

SQL>