RE: RMAN - Query on V$BACKUP_SET inconsistency

From: D'Hooge Freek <Freek.DHooge_at_uptime.be>
Date: Thu, 1 Sep 2011 10:46:56 +0200
Message-ID: <4814386347E41145AAE79139EAA39898150E4F4B68_at_ws03-exch07.iconos.be>

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_at_uptime.be
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer

-----Original Message-----
From: Sreejith Nair [mailto:sreejithsna_at_gmail.com] 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

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Sep 01 2011 - 03:46:56 CDT