Dynamic Performance (V$) Views, 50 of 238

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(13)`	Identifies the type of deleted object: `ARCHIVED LOG, DATAFILE COPY, BACKUP PIECE, PROXY COPY, BACKUP PIECE AVAILABLE, BACKUP PIECE EXPIRED, PROXY COPY AVAILABLE`, or `PROXY COPY EXPIRED`
`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.