Oracle教程 2023-04-04

Oracle 视图 DBA_PDB_SAVED_STATES 官方解释，作用，如何使用详细说明

Oracle视图DBA_PDB_SAVED_STATES用于查询Pluggable Database（PDB）可用的挂起状态列表，也可以使查询未挂起但可挂起的PDB状态。该视图列出了PDB中存储在磁盘上的备份文件，便于对PDB进行操作或进行相关的恢复操作。

使用此视图的步骤如下：

1.查询DBA_PDB_SAVED_STATES视图以查询PDB的可用备份：

SELECT * FROM DBA_PDB_SAVED_STATES;

2.确定哪个PDB需要被恢复：

SELECT * FROM DBA_PDB_SAVED_STATES WHERE PDB_NAME=’PDB_TO_RESTORE’;

3.恢复PDB_TO_RESTORE：

ALTER PLUGGABLE DATABASE PDB_TO_RESTORE RESTORE FROM SAVED STATE ‘SAVEDSTATE’;

DBA_PDB_SAVED_STATES shows information about the current saved PDB states in the CDB.

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