国外主机测评 - 国外VPS，国外服务器，国外云服务器，测评及优惠码
本站中文解释
Oracle视图V$RECOVERY_LOG视图用于显示数据库的归档日志信息。这个视图可以用来查看数据库的恢复状态，从而了解归档日志是否激活，有没有发生恢复等情况。
使用V$RECOVERY_LOG视图非常简单，只需使用SELECT命令查询就可以了。不仅可以查看日志文件的路径，还可以查看日志文件的名称、路径、大小，作为归档日志所用到的文件，以及归档日志是否激活等信息。
例如用下面的SELECT查看归档日志是否激活:
SELECT arc_status
FROM v$recovery_log;
如果返回YES，则说明归档日志已经激活，如果返回NO，则说明归档日志尚未激活。
官方英文解释
V$RECOVERY_LOG lists information about archived logs that are needed to complete media recovery. This information is derived from the log history view, V$LOG_HISTORY.
V$RECOVERY_LOG contains useful information only for the Oracle process doing the recovery. When Recovery Manager directs a server process to perform recovery, only Recovery Manager can view the relevant information in this view. V$RECOVERY_LOG will be empty to all other Oracle users.
| Column | Datatype | Description |
|---|---|---|
|
|
|
Thread number of the archived log |
|
|
|
Sequence number of the archived log |
|
|
|
Time of the first entry (lowest SCN) in the log |
|
|
|
Name of the file when archived, using the naming convention specified by the See Also: “LOG_ARCHIVE_FORMAT” |
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
See Also:
“V$LOG_HISTORY” and Oracle Database Backup and
Recovery User’s Guide
