我们要保存pdb状态,首先要了解视图DBA_PDB_SAVED_STATES显示了当前CDB中保存的pdb状态信息。
This view is a data link, so the data is also available within the PDB.
Column
Datatype
NULL
Description
CON_ID
NUMBER
NOT NULL
The ID of the PDB
CON_NAME
VARCHAR2(128)
NOT NULL
Name of the PDB
INSTANCE_NAME
VARCHAR2(128)
NOT NULL
Name of the instance for which the state is saved
CON_UID
NUMBER
NOT NULL
Unique ID assigned to the PDB at creation time
GUID
RAW(16)
Globally unique immutable ID assigned to the PDB at creation time
STATE
VARCHAR2(14)
Open state of the PDB
RESTRICTED
VARCHAR2(3)
Restricted mode of the PDB
默认情况,启停CDB,观察pdb状态
SQL> show pdbs
CON_ID CON_NAME