ITPub博客

首页 > Linux操作系统 > Linux操作系统 > solaris10_oracle10g_系列数据字典学习

solaris10_oracle10g_系列数据字典学习

原创 Linux操作系统 作者:wisdomone1 时间:2009-09-07 01:25:39 0 删除 编辑





V$DELETED_OBJECT

This view displays information about deleted archived logs, datafile copies and backup pieces from the control file. The only purpose of this view is to optimize the recovery catalog resync operation. When an archived log, datafile copy, or backup piece is deleted, the corresponding record is marked deleted.

Column Datatype Description
RECID NUMBER Deleted object record ID
STAMP NUMBER Deleted object record stamp
TYPE VARCHAR2(26) Identifies the type of deleted object:
  • ARCHIVED LOG

  • BACKUP PIECE

  • DATAFILE COPY

  • PROXY COPY

  • BACKUP PIECE AVAILABLE

  • BACKUP PIECE EXPIRED

  • PROXY COPY AVAILABLE

  • PROXY COPY EXPIRED

  • BACKUP PIECE UNAVAILABLE

  • PROXY COPY UNAVAILABLE

  • DATAFILE COPY AVAILABLE

  • DATAFILE COPY EXPIRED

  • DATAFILE COPY UNAVAILABLE

  • ARCHIVED LOG AVAILABLE

  • ARCHIVED LOG EXPIRED

  • ARCHIVED LOG UNAVAILABLE

  • BACKUP SET KEEP OPTIONS

  • BACKUP SET KEEP UNTIL

  • PROXY COPY KEEP OPTIONS

  • PROXY COPY KEEP UNTIL

  • DATAFILE COPY KEEP OPTIONS

  • DATAFILE COPY KEEP UNTIL

  • DATAFILE RENAME ON RESTORE

OBJECT_RECID NUMBER Record ID of the deleted object
OBJECT_STAMP NUMBER Record timestamp of the deleted object
OBJECT_DATA NUMBER Displays additional internal information related to this deleted object. For internal Oracle use only.



rman target /
backup datafile 3;

delete noprompt archivelog all;

select count(*) from v$deleted_object;---这时就记了来自于控制文件被删除的归档日志的记录数


















----

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

请登录后发表评论 登录
全部评论
提供针对oracle初学者及进阶的数据库培训,欢迎大家咨询: 微信: wisdomone 微信公众号: lovedb qq: 305076427 微博: wisdomone9

注册时间:2008-04-04

  • 博文量
    2164
  • 访问量
    11763864