Oracle 视图 V$RECOVER_FILE 官方解释，作用，如何使用详细说明
本站中文解释
本视图显示进行数据库恢复所需的文件，它集中了数据库文件名、文件ID号、恢复锁定状态和所属的数据库。
使用：
1、查看需要恢复的文件：
SELECT file#, file_name, online_status
FROM V$recover_file
where online_status= ‘OFFLINE’;
2、查看需要恢复的数据库：
SELECT file#, file_name, online_status, across_db_name
FROM V$recover_file
WHERE online_status=’OFFLINE’
AND across_db_name IS NOT NULL;
官方英文解释
V$RECOVER_FILE displays the status of files needing media recovery.
| Column | Datatype | Description |
|---|---|---|
|
|
|
File identifier number |
|
|
|
This column is obsolete and maintained for backward compatibility. The value of this column is always equal to the value in |
|
|
|
Online status ( |
|
|
|
Why the file must be recovered: NULL if reason unknown, or |
|
|
|
SCN where recovery must start |
|
|
|
Time of SCN when recovery must start |
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
