Oracle 视图 V$PROXY_ARCHIVELOG_DETAILS 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图V$PROXY_ARCHIVELOG_DETAILS用于查询归档日志在备份中的状态。它包含有关归档日志文件加入备份批处理的详细信息，例如可用的大小、已使用的大小、备份子任务的ID以及备份子任务的状态（写入成功、失败）等等。
如何使用V$PROXY_ARCHIVELOG_DETAILS：
一、可以使用该视图查询某一次备份中归档日志的详细信息：
SELECT * FROM v$proxy_archivelog_details where BACKUP_SET_ID = ;
二、也可以通过该视图来查找日志文件是否被压缩：
SELECT * FROM v$proxy_archivelog_details where online_log_file like ‘%%’ and backup_set_id=;
三、还可以通过该视图来查找归档日志是否被编入备份批任务中：
SELECT * FROM v$proxy_archivelog_details where online_log_file like ‘%%’;
官方英文解释
V$PROXY_ARCHIVELOG_DETAILS contains information about all available archive log proxy copies.
| Column | Datatype | Description |
|---|---|---|
|
|
|
Session identifier |
|
|
|
Session recid |
|
|
|
Session stamp |
|
|
|
Copy identifier |
|
|
|
Redo thread number |
|
|
|
Redo log sequence number |
|
|
|
Resetlogs change number of the database when this log was written |
|
|
|
Resetlogs time of the database when this log was written |
|
|
|
Proxy copy handle identifies the copy for restore |
|
|
|
Name of the media on which the copy resides. This value is informational only. It is not needed for restore. |
|
|
|
Media pool in which the copy resides. This is the same value that was entered in the |
|
|
|
Proxy copy tag |
|
|
|
First change number in the archived log |
|
|
|
First change number in the next log |
|
|
|
Timestamp of the first change |
|
|
|
Timestamp of the next change |
|
|
|
Total output bytes written |
|
|
|
Completion time |
|
|
|
Displayable format for output bytes |
|
|
|
Indicates whether this backup set has a retention policy that is different than the value for the configure retention policy ( |
|
|
|
If specified, then this is the date after which the backup becomes obsolete. If this column is |
|
|
|
Additional retention options for this backup set:
|
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
