Oracle教程 2023-02-28

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

本站中文解释

Oracle V$PROXY_DATAFILE视图中的每一行记录均表示一个数据文件在proxy copy操作（数据库的文件拷贝操作）中的状态信息，此视图用于查询有关数据库文件在proxy copy操作中的状态信息。

使用方法：

1. 查看当前状态：

SELECT FILE_NAME, STATUS FROM V$PROXY_DATAFILE;

该查询语句会显示当前正在使用的数据文件以及每个文件的当前状态。

2. 查看历史状态：

SELECT FILE_NAME, PREVIOUS_STATUS, CURRENT_STATUS FROM V$PROXY_DATAFILE;

该查询语句会显示每个数据文件在proxy copy操作开始前ら处的状态，和在开始后的当前状态。

官方英文解释

V$PROXY_DATAFILE contains descriptions of datafile and control file backups that are taken with Proxy Copy. Each row represents a backup of one database file.

Column	Datatype	Description
`RECID`	`NUMBER`	Proxy copy record ID
`STAMP`	`NUMBER`	Proxy copy record stamp
`DEVICE_TYPE`	`VARCHAR2(17)`	Type of the device on which the copy resides
`HANDLE`	`VARCHAR2(513)`	Proxy copy handle identifies the copy for restore
`COMMENTS`	`VARCHAR2(81)`	Comment returned by the operating system or storage subsystem. This value is informational only. It is not needed for restore.
`MEDIA`	`VARCHAR2(65)`	Name of the media on which the copy resides. This value is informational only. It is not needed for restore.
`MEDIA_POOL`	`NUMBER`	Media pool in which the copy resides. This is the same value that was entered in the `POOL` operand of the Recovery Manager `BACKUP` command
`TAG`	`VARCHAR2(32)`	Proxy copy tag
`STATUS`	`VARCHAR2(1)`	Status of the backup set: `A` – Available `U` – Unavailable `X` – Expired `D` – Deleted
`DELETED`	`VARCHAR2(3)`	Indicates whether this record has been deleted (`YES`) or not (`NO`)
`FILE#`	`NUMBER`	Absolute datafile number, or 0 if this is a control file backup
`CREATION_CHANGE#`	`NUMBER`	Datafile creation change number
`CREATION_TIME`	`DATE`	Datafile creation Timestamp
`RESETLOGS_CHANGE#`	`NUMBER`	Resetlogs change number of the datafile when the copy was made
`RESETLOGS_TIME`	`DATE`	Resetlogs timestamp of the datafile when the copy was made
`CHECKPOINT_CHANGE#`	`NUMBER`	Checkpoint change number of the datafile when the copy was made
`CHECKPOINT_TIME`	`DATE`	Checkpoint timestamp of the datafile when the copy was made
`ABSOLUTE_FUZZY_CHANGE#`	`NUMBER`	Highest change in any block of the file, if known
`RECOVERY_FUZZY_CHANGE#`	`NUMBER`	Highest change written to the file by media recovery
`RECOVERY_FUZZY_TIME`	`DATE`	Timestamp of the highest change written to the file by media recovery
`INCREMENTAL_LEVEL`	`NUMBER`	If this backup is part of an incremental backup strategy, then 0. Otherwise null.
`ONLINE_FUZZY`	`VARCHAR2(3)`	Indicates whether this copy was made after a crash or offline immediate (or is a copy of a copy which was taken improperly while the database was open) (`YES`) or not (`NO`). Recovery will need to apply all redo up to the next crash recovery marker to make the file consistent.
`BACKUP_FUZZY`	`VARCHAR2(3)`	Indicates whether this is a copy taken using the `BEGIN BACKUP \| END BACKUP` technique (`YES`) or not (`NO`). The `BEGIN BACKUP \| END BACKUP` technique is used internally when proxy copies of open files are created. Recovery will need to apply all redo up to the end backup marker to make this copy consistent.
`BLOCKS`	`NUMBER`	Size of the copy (in blocks). Also the size of the datafile when the copy was made.
`BLOCK_SIZE`	`NUMBER`	Block size of the datafile
`OLDEST_OFFLINE_RANGE`	`NUMBER`	If the file number is `0` (that is, this is a control file backup), the RECID of the oldest offline range record in this control file copy. `0` for datafile copies.
`START_TIME`	`DATE`	Starting time
`COMPLETION_TIME`	`DATE`	Completion time
`ELAPSED_SECONDS`	`NUMBER`	Number of elapsed seconds
`CONTROLFILE_TYPE`	`VARCHAR2(1)`	Type of control file: `B` – Normal control file `S` – Standby control file
`KEEP`	`VARCHAR2(3)`	Indicates whether this backup set has a retention policy that is different than the value for the configure retention policy (`YES`) or not (`NO`)
`KEEP_UNTIL`	`DATE`	If specified, then this is the date after which the backup becomes obsolete. If this column is NULL, then the backup never expires.
`KEEP_OPTIONS`	`VARCHAR2(11)`	Additional retention options for this backup set: `LOGS` – Indicates a long-term backup made with the `LOGS` keyword, which is now deprecated `BACKUP_LOGS` – Indicates that the backup was made in open mode, so archived log backups must be applied to make it consistent `NOLOGS` – Indicates a consistent backup made when the database was mounted. NULL – Indicates that this backup has no `KEEP` options and becomes obsolete based on the retention policy
`RMAN_STATUS_RECID`	`NUMBER`	Owning `V$RMAN_STATUS` record ID
`RMAN_STATUS_STAMP`	`NUMBER`	Owning `V$RMAN_STATUS` stamp
`FOREIGN_DBID`	`NUMBER`	Foreign DBID of the database from which this datafile was transported. The value is `0` if the file backed up is not a foreign database file.
`PLUGGED_READONLY`	`VARCHAR2(3)`	Indicates whether this is a proxy copy of a transported read-only foreign file (`YES`) or not (`NO`)
`PLUGIN_CHANGE#`	`NUMBER`	SCN at which the foreign datafile was transported into the database. The value is `0` if this file is not a foreign database file.
`PLUGIN_RESETLOGS_CHANGE#`	`NUMBER`	SCN of the `RESETLOGS` operation for the incarnation into which this foreign file was transported. The value is `0` if this file is not a foreign database file.
`PLUGIN_RESETLOGS_TIME`	`DATE`	Time of the `RESETLOGS` operation for the incarnation into which this foreign file was transported. The value is `0` if this file is not a foreign database file.
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data
`BACKED_BY_PDB`	`VARCHAR2(3)`	Recovery Manager (RMAN) allows a PDB to be backed up in two ways. The value in this column indicates how the PDB backup was taken: `YES`: The backup was taken when connected to the PDB `NO`: The backup was taken when connected to the root container
`GUID`	`RAW(16)`	The GUID of the PDB to which the backup belongs. This is useful after the PDB is dropped to identify which PDB the backup belongs to.

数据运维技术 » Oracle 视图 V$PROXY_DATAFILE 官方解释，作用，如何使用详细说明

分享到：

本站中文解释

官方英文解释

相关推荐