视图学习之--V$RECOVER_FILE
This view displays the status of files needing media recovery.
| Column | Datatype | Description |
|---|---|---|
| FILE# | NUMBER | File identifier number |
| ONLINE | VARCHAR2(7) | This column is obsolete and maintained for backward compatibility. The value of this column is always equal to the value in ONLINE_STATUS. |
| ONLINE_STATUS | VARCHAR2(7) | Online status (ONLINE, OFFLINE) |
| ERROR | VARCHAR2(18) | Why the file needs to be recovered: NULL if reason unknown, or OFFLINE NORMAL if recovery not needed |
| CHANGE# | NUMBER | SCN where recovery must start |
| TIME | DATE | Time of SCN when recovery must start |
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/15881763/viewspace-679413/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
RMAN恢复的预操作--检测备份的有效性
请登录后发表评论
登录
全部评论
