True, the documentation is incorrect to state that a value of "D" only for datafile backups Freek D'Hooge Uptime Oracle Database Administrator email: freek.dhooge@xxxxxxxxx tel +32(0)3 451 23 82 http://www.uptime.be disclaimer: www.uptime.be/disclaimer -----Original Message----- From: Sreejith Nair [mailto:sreejithsna@xxxxxxxxx] Sent: donderdag 1 september 2011 3:23 To: D'Hooge Freek Cc: Oracle L Subject: Re: RMAN - Query on V$BACKUP_SET inconsistency Hi, But as per documentation V$BACKUP_SET.BACKUP_TYPE holds the Type of files that are in this backup. If the backup contains archived redo logs, the value is L. If this is a datafile full backup, the value is D. If this is an incremental backup, the value is I." So, I suppose even if it is a control file backup backup_type is updated as "D" , which as per documentation will only come for a full datafile backup. This looks like misleading or incomplete. Sreejith ~Sent from my samsung phone -- //www.freelists.org/webpage/oracle-l