Oracle教程 2023-02-24

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

Oracle视图V$RECOVERY_FILE_DEST主要用于查看数据库的备份存储位置。该视图包含备份文件夹的描述信息和文件以及文件路径，他们的大小以及状态等字段，主要用途如下。

1. 查看哪些恢复文件被存储在该位置。
2. 哪一个恢复文件被存储，以及它的路径。
3. 确定文件的总量和大小。
4. 确定备份文件夹是否可用。

使用方法：

1. 使用以下语句来执行查看操作：
SELECT * FROM V$RECOVERY_FILE_DEST;
2. 通过查看字段NAME，TYPE，PATH 和SIZE_MB 来确定备份文件夹的信息：
3. 通过查看字段LAST_BACKUP来检查备份文件夹是否可用。

V$RECOVERY_FILE_DEST displays information about the disk quota and current disk usage in the fast recovery area.

Column	Datatype	Description
`NAME`	`VARCHAR2(513)`	Location name. This is the value specified in the `DB_RECOVERY_FILE_DEST` initialization parameter.
`SPACE_LIMIT`	`NUMBER`	Maximum amount of disk space (in bytes) that the database can use for the fast recovery area. This is the value specified in the `DB_RECOVERY_FILE_DEST_SIZE` initialization parameter.
`SPACE_USED`	`NUMBER`	Amount of disk space (in bytes) used by fast recovery area files created in current and all previous fast recovery areas. Changing fast recovery areas does not reset `SPACE_USED` to `0`.
`SPACE_RECLAIMABLE`	`NUMBER`	Total amount of disk space (in bytes) that can be created by deleting obsolete, redundant, and other low priority files from the fast recovery area
`NUMBER_OF_FILES`	`NUMBER`	Number of files in the fast recovery area
`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