RMAN - Query on V$BACKUP_SET inconsistency

Hi Friends,

Oracle Database EE 11.2.0.2 on Solaris 10...

We have incremental level 0 backups which runs on Sunday using command
backup as compressed backupset incremental level 0 .....

We have incremental level 1 backups which runs everyday other than Sunday 
using command
backup as compressed backupset incremental level 1 database....

After the backup ran for today, what I see is as shown below..

SQL> select BACKUP_TYPE,INCREMENTAL_LEVEL,START_TIME,COMPLETION_TIME from 
v$backup_set where START_TIME > sysdate -4 and BACKUP_TYPE<>'L';

B INCREMENTAL_LEVEL START_TIME        COMPLETION_TIME
- ----------------- ----------------- -----------------
D                 0 28-AUG-2011 04:30 28-AUG-2011 04:33
D                 0 28-AUG-2011 04:30 28-AUG-2011 04:33
I                 1 29-AUG-2011 04:30 29-AUG-2011 04:33
I                 1 29-AUG-2011 04:30 29-AUG-2011 04:35
I                 1 30-AUG-2011 04:30 30-AUG-2011 04:33
I                 1 30-AUG-2011 04:30 30-AUG-2011 04:35
I                 1 31-AUG-2011 04:30 31-AUG-2011 04:33
I                 1 31-AUG-2011 04:30 31-AUG-2011 04:35
D                   31-AUG-2011 04:35 31-AUG-2011 04:35
D                   31-AUG-2011 06:30 31-AUG-2011 06:30
D                   31-AUG-2011 08:30 31-AUG-2011 08:30

As per Oracle documentation V$BACKUP_SET,BACKUP_TYPE holds

"BACKUP_TYPE VARCHAR2(1) 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."
"INCREMENTAL_LEVEL NUMBER Location where this backup set fits into the 
database's backup strategy. Set to zero for full datafile backups, nonzero 
for incremental datafile backups, and NULL for archivelog backups."

So the above query shows an entry with "D" which means a full datafile 
backup did run today, but you can see INCREMENTAL_LEVEL is null which 
means it is not a full datafile backup. My questions is, why is 
BACKUP_TYPE field showing not as per the documentation -Why it is showing 
a "D" ?

Listing the backup also does not show a full backup. 

Thanks in Advance.

RMAN> list backup summary;

using target database control file instead of recovery catalog

List of Backups
===============
Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
1722    B  0  A DISK        28-AUG-11       1       1       YES 
DB_FULL_BACKUP
1723    B  0  A DISK        28-AUG-11       1       1       YES 
DB_FULL_BACKUP
1724    B  A  A DISK        28-AUG-11       1       1       YES 
TAG20110828T043338
1727    B  A  A DISK        28-AUG-11       1       1       YES 
TAG20110828T063036
1729    B  A  A DISK        28-AUG-11       1       1       YES 
TAG20110828T083025
1731    B  A  A DISK        28-AUG-11       1       1       YES 
TAG20110828T103015
1733    B  A  A DISK        28-AUG-11       1       1       YES 
TAG20110828T123050
1735    B  A  A DISK        28-AUG-11       1       1       YES 
TAG20110828T143026
1737    B  A  A DISK        28-AUG-11       1       1       YES 
TAG20110828T163025
1739    B  A  A DISK        28-AUG-11       1       1       YES 
TAG20110828T183025
1741    B  A  A DISK        28-AUG-11       1       1       YES 
TAG20110828T203029
1743    B  A  A DISK        28-AUG-11       1       1       YES 
TAG20110828T223027
1745    B  A  A DISK        29-AUG-11       1       1       YES 
TAG20110829T003025
1747    B  A  A DISK        29-AUG-11       1       1       YES 
TAG20110829T023043
1749    B  1  A DISK        29-AUG-11       1       1       YES 
DB_INCR_BACKUP
1750    B  1  A DISK        29-AUG-11       1       1       YES 
DB_INCR_BACKUP
1751    B  A  A DISK        29-AUG-11       1       1       YES 
TAG20110829T043543
1752    B  A  A DISK        29-AUG-11       1       1       YES 
TAG20110829T043543
1754    B  A  A DISK        29-AUG-11       1       1       YES 
TAG20110829T063027
1756    B  A  A DISK        29-AUG-11       1       1       YES 
TAG20110829T083027
1758    B  A  A DISK        29-AUG-11       1       1       YES 
TAG20110829T103035
1760    B  A  A DISK        29-AUG-11       1       1       YES 
TAG20110829T123054
1762    B  A  A DISK        29-AUG-11       1       1       YES 
TAG20110829T143043
1764    B  A  A DISK        29-AUG-11       1       1       YES 
TAG20110829T163029
1766    B  A  A DISK        29-AUG-11       1       1       YES 
TAG20110829T183036
1768    B  A  A DISK        29-AUG-11       1       1       YES 
TAG20110829T203026
1770    B  A  A DISK        29-AUG-11       1       1       YES 
TAG20110829T223029
1772    B  A  A DISK        30-AUG-11       1       1       YES 
TAG20110830T003021
1774    B  A  A DISK        30-AUG-11       1       1       YES 
TAG20110830T023042
1776    B  1  A DISK        30-AUG-11       1       1       YES 
DB_INCR_BACKUP
1777    B  1  A DISK        30-AUG-11       1       1       YES 
DB_INCR_BACKUP
1778    B  A  A DISK        30-AUG-11       1       1       YES 
TAG20110830T043517
1779    B  A  A DISK        30-AUG-11       1       1       YES 
TAG20110830T043517
1781    B  A  A DISK        30-AUG-11       1       1       YES 
TAG20110830T063031
1783    B  A  A DISK        30-AUG-11       1       1       YES 
TAG20110830T083027
1785    B  A  A DISK        30-AUG-11       1       1       YES 
TAG20110830T103026
1787    B  A  A DISK        30-AUG-11       1       1       YES 
TAG20110830T123041
1789    B  A  A DISK        30-AUG-11       1       1       YES 
TAG20110830T143021
1791    B  A  A DISK        30-AUG-11       1       1       YES 
TAG20110830T163030
1793    B  A  A DISK        30-AUG-11       1       1       YES 
TAG20110830T183033
1795    B  A  A DISK        30-AUG-11       1       1       YES 
TAG20110830T203026
1797    B  A  A DISK        30-AUG-11       1       1       YES 
TAG20110830T223027
1799    B  A  A DISK        31-AUG-11       1       1       YES 
TAG20110831T003027
1801    B  A  A DISK        31-AUG-11       1       1       YES 
TAG20110831T023048
1803    B  1  A DISK        31-AUG-11       1       1       YES 
DB_INCR_BACKUP
1804    B  1  A DISK        31-AUG-11       1       1       YES 
DB_INCR_BACKUP
1805    B  A  A DISK        31-AUG-11       1       1       YES 
TAG20110831T043513
1806    B  A  A DISK        31-AUG-11       1       1       YES 
TAG20110831T043513
1807    B  F  A DISK        31-AUG-11       1       1       NO 
TAG20110831T043518
1808    B  A  A DISK        31-AUG-11       1       1       YES 
TAG20110831T063015
1809    B  F  A DISK        31-AUG-11       1       1       NO 
TAG20110831T063024
1810    B  A  A DISK        31-AUG-11       1       1       YES 
TAG20110831T083026
1811    B  F  A DISK        31-AUG-11       1       1       NO 
TAG20110831T083034

--
Cheers,
Sreejith
 





DISCLAIMER: 

"The information in this e-mail and any attachment is intended only for 
the person to whom it is addressed and may contain confidential and/or 
privileged material. If you have received this e-mail in error, kindly 
contact the sender and destroy all copies of the original communication. 
IBS makes no warranty, express or implied, nor guarantees the accuracy, 
adequacy or completeness of the information contained in this email or any 
attachment and is not liable for any errors, defects, omissions, viruses 
or for resultant loss or damage, if any, direct or indirect."




Other related posts: