Oracle教程

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

本站中文解释

V$PROXY_ARCHIVEDLOG视图是oracle数据库提供的管理已归档日志用的视图，用于查看和管理归档日志文件(存储在存档日志库中)。

它有以下列描述：
1. 索引列（它可以被用来检索每个列的详细信息）
2. 服务器名称(创建此档案存储库的服务器名称)
3. 归档日志库中日志文件的名称
4. 日志ID(用于标识某个日志的ID号)
5. 日志优先步骤
6. 日志字符串 日志路径等等。

使用V$PROXY_ARCHIVEDLOG视图可以获取如下信息：
1. 查询各归档日志库中日志文件的详细信息
2. 删除无用的归档日志
3. 确定归档日志空间使用情况
4. 检查某一日志文件是否下载
5. 监控需要储存的归档日志的尺寸
6. 等等。

官方英文解释

V$PROXY_ARCHIVEDLOG contains descriptions of archived log backups that were taken using the proxy copy functionality.

In a proxy copy, the media manager takes over the operations of backing up and restoring data. Each row represents a backup of one control file.

Column Datatype Description

RECID

NUMBER

Proxy copy record identifier

STAMP

NUMBER

Proxy copy stamp

DEVICE_TYPE

VARCHAR2(17)

Type of media device that stores the proxy copy

HANDLE

VARCHAR2(513)

Name or “handle” for the proxy copy

COMMENTS

VARCHAR2(81)

Comments about the proxy copy

MEDIA

VARCHAR2(65)

A comment that contains further information about the media manager that created this backup

MEDIA_POOL

NUMBER

Number of the media pool in which the proxy copy is stored

TAG

VARCHAR2(32)

Tag for the proxy copy

STATUS

VARCHAR2(1)

Status of the backup set:

  • A – Available

  • U – Unavailable

  • X – Expired

  • D – Deleted

DELETED

VARCHAR2(3)

Indicates whether this record has been deleted (YES) or not (NO)

THREAD#

NUMBER

Number of the redo thread

SEQUENCE#

NUMBER

Log sequence number

RESETLOGS_CHANGE#

NUMBER

RESETLOGS SCN of the database incarnation to which this archived log belongs

RESETLOGS_TIME

DATE

RESETLOGS time stamp of the database incarnation to which this archived log belongs

FIRST_CHANGE#

NUMBER

First SCN of this redo log

FIRST_TIME

DATE

Time when Oracle switched into the redo log

NEXT_CHANGE#

NUMBER

First SCN of the next redo log in the thread

NEXT_TIME

DATE

First time stamp of the next redo log in the thread

BLOCKS

NUMBER

Size of this archived redo log (in operating system blocks)

BLOCK_SIZE

NUMBER

Block size for the copy (in bytes)

START_TIME

DATE

Time when the proxy copy was initiated

COMPLETION_TIME

DATE

Time when the proxy copy was completed

ELAPSED_SECONDS

NUMBER

Duration of the proxy copy

RMAN_STATUS_RECID

NUMBER

Owning V$RMAN_STATUS record ID

RMAN_STATUS_STAMP

NUMBER

Owning V$RMAN_STATUS stamp

TERMINAL

VARCHAR2(3)

Indicates whether this record corresponds to a terminal archived redo log, as defined in V$ARCHIVED_LOG (YES) or not (NO)

KEEP

VARCHAR2(3)

Indicates whether this backup set has a retention policy that is different than the value for the configure retention policy (YES) or not (NO)

KEEP_UNTIL

DATE

If specified, then this is the date after which the backup becomes obsolete. If this column is NULL, then the backup never expires.

KEEP_OPTIONS

VARCHAR2(11)

Additional retention options for this backup set:

  • LOGS – Indicates a long-term backup made with the LOGS keyword, which is now deprecated

  • BACKUP_LOGS – Indicates that the backup was made in open mode, so archived log backups must be applied to make it consistent

  • NOLOGS – Indicates a consistent backup made when the database was mounted

  • NULL – Indicates that this backup has no KEEP options and becomes obsolete based on the retention policy

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


数据运维技术 » Oracle 视图 V$PROXY_ARCHIVEDLOG 官方解释，作用，如何使用详细说明
分享到：

相关推荐