ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORACLE V$RMAN_STATUS V$RMAN_OUTPUT

ORACLE V$RMAN_STATUS V$RMAN_OUTPUT

原创 Linux操作系统 作者:zecaro 时间:2011-05-11 20:30:54 0 删除 编辑

        本来想写些什么的,单独看文档的解释不容易明白。不过只要找台数据库查一下这个视图,对照着看下就基本明白了。

        以前查看rman的日志,都不知道有这几个视图,MARK之~
 
出自10gr2的文档:

  V$RMAN_STATUS 视图

  V$RMAN_STATUS displays the finished and on-going RMAN jobs. For on-going jobs, this view displays progress and status. The jobs which are in progress are stored only in memory while the finished jobs are stored in the controlfile.

V$RMAN_STATUS显示已完成和正在进行的RMAN任务。对于正在进行的任务,显示 progress 和 status,这些信息仅存在于内存中。当任务结束后,信息将存在控制文件中。

Column Datatype Description
SID NUMBER Session ID of the session which is running this RMAN operation
RECID NUMBER

Record ID of the row in the controlfile

按这个排序可以看到执行的顺序

STAMP NUMBER Timestamp of the row (RECID + STAMP is unique)
PARENT_RECID NUMBER

Record ID of the parent row of this row (corresponding V$RMAN_STATUS row with ROW_LEVEL = ROW_LEVEL - 1)

父recid,对应ROW_LEVEL列,子的ROW_LEVEL是父的ROW_LEVEL-1

PARENT_STAMP NUMBER Timestamp of the parent row of this row (corresponding V$RMAN_STATUS row with ROW_LEVEL = ROW_LEVEL - 1)
SESSION_RECID NUMBER

Record ID of the session (corresponding V$RMAN_STATUS row with ROW_LEVEL = 0)

session会话的记录id,也就是ROW_LEVEL=0的session

SESSION_STAMP NUMBER Timestamp of the session (corresponding V$RMAN_STATUS row with ROW_LEVEL = 0)
ROW_LEVEL NUMBER

Level of the row. The session has level 0.

按照下面row_type分了几类,其中session的level =0

ROW_TYPE VARCHAR2(19) Type of the row:
  • SESSION

  • COMMAND

  • RECURSIVE OPERATION

session的话,敲了诸如rman target / 就可以看到一条记录(没有退出前这一条记录的status是failed,有些别扭),operation写的是RMAN

command的话,对应的operation有BACKUP(进行备份),LIST(LIST命令),REPORT等等

COMMAND_ID VARCHAR2(33) Command ID set by the RMAN SET COMMAND ID command. If not set, then RMAN will create a unique number.
OPERATION VARCHAR2(33) Name of the command in the execution explained by this row
STATUS VARCHAR2(23) Status of the operation:
  • RUNNING

  • RUNNING WITH WARNINGS

  • RUNNING WITH ERRORS

  • COMPLETED

  • COMPLETED WITH WARNINGS

  • COMPLETED WITH ERRORS

  • FAILED

MBYTES_PROCESSED NUMBER Percentage of the job completed; null if not applicable for the operation
START_TIME DATE Start time of the job
END_TIME DATE End time of the job
INPUT_BYTES NUMBER Number of input bytes read
OUTPUT_BYTES NUMBER Number of output bytes written
OPTIMIZED VARCHAR2(3) YES, if backup optimization was applied during the backup job. Otherwise, NO.
OBJECT_TYPE VARCHAR2(13)

Identifies types of objects backed up

比如备份有 ARCHIVELOG,CONTROLFILE ,DB INCR

OUTPUT_DEVICE_TYPE VARCHAR2(17)

DISK, SBT_TAPE, or *. An * indicates that output was written to more than one device type.

  V$RMAN_OUTPUT 视图

  V$RMAN_OUTPUT displays messages reported by RMAN. This is an in-memory view and is not recorded in the controlfile. The view can hold 32768 rows.

V$RMAN_OUTPUT 视图记录了RMAN生成的信息,这是在内存中额视图,不会记录到控制文件上。最多有37278条记录。

Column Datatype Description
SID NUMBER Session ID of the session which is running this RMAN operation
RECID NUMBER Record ID of the corresponding V$RMAN_STATUS row
STAMP NUMBER Timestamp of the corresponding V$RMAN_STATUS row
SESSION_RECID NUMBER Record ID of the session (corresponding V$RMAN_STATUS row with ROW_LEVEL = 0)
SESSION_STAMP NUMBER Timestamp of the session (corresponding V$RMAN_STATUS row with ROW_LEVEL = 0)
OUTPUT VARCHAR2(129) Output text reported by RMAN
RMAN_STATUS_RECID NUMBER Owning V$RMAN_STATUS record ID
RMAN_STATUS_STAMP NUMBER Owning V$RMAN_STATUS record stamp
SESSION_KEY NUMBER Session identifier

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23650854/viewspace-695047/,如需转载,请注明出处,否则将追究法律责任。

下一篇: ORA-600 kdsgrp1
请登录后发表评论 登录
全部评论

注册时间:2010-10-28

  • 博文量
    182
  • 访问量
    348802