Hi Riaan,
something odd come up.
The bpimagelist the customer sent me yesterday, as you correctly pinted out, was showing the image was still on disk.
This morning the customer launched a destaging job manually and only today the actual bk id was copied to tape and the disk STU is now empty.
Since RMAN crosscheck check all backup sets that make a whole bk, it is possible that RMAN marked this particular bk id EXPIRED since portions of it were alreay on tape.
To you and the whole community I'd like to ask if you have ever configured Oracle bk to Destagin STU and if this supported or what I see is the expected behaviour.
Today I will repeat the entire test.
root@nb-ser:/# bpimagelist -backupid
dm01db01-priv1.service.intra_1444744154 -L
Client: dm01db01-priv1.service.intra
Backup ID: dm01db01-priv1.service.intra_1444744154
Policy: 2_exadata
Policy Type: Oracle (4)
Proxy Client: (none specified)
Creator: oracle
Name1: (none specified)
Sched Label: week
Schedule Type: UBAK (2)
Retention Level: 1 week (0)
Backup Time: Tue Oct 13 15:49:14 CEST 2015 (1444744154)
Elapsed Time: 6 second(s)
Expiration Time: Tue Oct 20 15:49:14 CEST 2015 (1445348954)
Compressed: yes
Client Encrypted: no
Kilobytes: 6240
Number of Files: 1
Number of Copies: 1
Number of Fragments: 1
Histogram: 0 0 0 0 0 0 0 0 0 0
DB Compressed: no
Files File Name: 2_exadata_1444744154_UBAK.f
Previous Backup Files File Name: (none specified)
Parent Backup Image File Name: (none specified)
SW Version: (none specified)
Options: 0x0
MPX: 0
TIR Info: 0
TIR Expiration: Thu Jan 1 01:00:00 CET 1970 (0)
Keyword: dbm01
Ext Security Info: no
File Restore Raw: no
Image Dump Level: 0
File System Only: no
Object Descriptor: (none specified)
Previous BI Time: Thu Jan 1 01:00:00 CET 1970 (0)
BI Full Time: Thu Jan 1 01:00:00 CET 1970 (0)
Request Pid: 0
Backup Status: 0
Stream Number: 0
Backup Copy: Standard (0)
Files File size: 644
PFI type: 0
IMAGE_ATTRIBUTE: 0
Primary Copy: 2
Image Type: 0 (Regular)
Job ID: 1211263
Num Resumes: 1
Resume Expiration: Thu Jan 1 01:00:00 CET 1970 (0)
Data Classification: (none specified)
Data_Classification_ID: (none specified)
Storage Lifecycle Policy: (none specified)
Storage Lifecycle Policy Version: 0
STL_Completed: 0
Remote Expiration Time: Thu Jan 1 01:00:00 CET 1970 (0) Origin Master Server: (none specified)
Origin Master GUID: (none specified)
Snap Time: Thu Jan 1 01:00:00 CET 1970 (0)
IR Enabled: no
Client Character Set: 1
Image On Hold: 0
Indexing Status: 0
Copy number: 2
Fragment: 1
Kilobytes: 6240
Remainder: 0
Media Type: Media Manager (2)
Density: hcart2 (14)
File Num: 39
ID: 500063
Host: examedia02
Block Size: 65536
Offset: 5145988
Media Date: Wed Oct 7 16:13:26 CEST 2015 (1444227206)
Dev Written On: 3
Flags: 0x0
Media Descriptor: ?
Expiration Time: Tue Oct 20 15:49:14 CEST 2015 (1445348954)
MPX: 0
retention_lvl: 1 week (0)
Try to Keep Time: Thu Jan 1 01:00:00 CET 1970 (0)
Copy Creation Time: Wed Oct 14 08:40:33 CEST 2015 (1444804833)
Data Format: Tar
checkpoint: 0
resume num: 1
Key tag: *NULL*
STL tag: *NULL*
Copy on hold: 0
root@nb-ser:/# bpimagelist -backupid
dm01db01-priv1.service.intra_1444744135 -L
Client: dm01db01-priv1.service.intra
Backup ID: dm01db01-priv1.service.intra_1444744135
Policy: 2_exadata
Policy Type: Oracle (4)
Proxy Client: (none specified)
Creator: oracle
Name1: (none specified)
Sched Label: week
Schedule Type: UBAK (2)
Retention Level: 1 week (0)
Backup Time: Tue Oct 13 15:48:55 CEST 2015 (1444744135)
Elapsed Time: 5 second(s)
Expiration Time: Tue Oct 20 15:48:55 CEST 2015 (1445348935)
Compressed: yes
Client Encrypted: no
Kilobytes: 32
Number of Files: 1
Number of Copies: 1
Number of Fragments: 1
Histogram: 0 0 0 0 0 0 0 0 0 0
DB Compressed: no
Files File Name: 2_exadata_1444744135_UBAK.f
Previous Backup Files File Name: (none specified)
Parent Backup Image File Name: (none specified)
SW Version: (none specified)
Options: 0x0
MPX: 0
TIR Info: 0
TIR Expiration: Thu Jan 1 01:00:00 CET 1970 (0)
Keyword: dbm01
Ext Security Info: no
File Restore Raw: no
Image Dump Level: 0
File System Only: no
Object Descriptor: (none specified)
Previous BI Time: Thu Jan 1 01:00:00 CET 1970 (0)
BI Full Time: Thu Jan 1 01:00:00 CET 1970 (0)
Request Pid: 0
Backup Status: 0
Stream Number: 0
Backup Copy: Standard (0)
Files File size: 641
PFI type: 0
IMAGE_ATTRIBUTE: 0
Primary Copy: 2
Image Type: 0 (Regular)
Job ID: 1211260
Num Resumes: 1
Resume Expiration: Thu Jan 1 01:00:00 CET 1970 (0)
Data Classification: (none specified)
Data_Classification_ID: (none specified)
Storage Lifecycle Policy: (none specified)
Storage Lifecycle Policy Version: 0
STL_Completed: 0
Remote Expiration Time: Thu Jan 1 01:00:00 CET 1970 (0) Origin Master Server: (none specified)
Origin Master GUID: (none specified)
Snap Time: Thu Jan 1 01:00:00 CET 1970 (0)
IR Enabled: no
Client Character Set: 1
Image On Hold: 0
Indexing Status: 0
Copy number: 2
Fragment: 1
Kilobytes: 32
Remainder: 0
Media Type: Media Manager (2)
Density: hcart2 (14)
File Num: 38
ID: 500063
Host: examedia02
Block Size: 65536
Offset: 5145985
Media Date: Wed Oct 7 16:13:26 CEST 2015 (1444227206)
Dev Written On: 3
Flags: 0x0
Media Descriptor: ?
Expiration Time: Tue Oct 20 15:48:55 CEST 2015 (1445348935)
MPX: 0
retention_lvl: 1 week (0)
Try to Keep Time: Thu Jan 1 01:00:00 CET 1970 (0)
Copy Creation Time: Wed Oct 14 08:40:32 CEST 2015 (1444804832)
Data Format: Tar
checkpoint: 0
resume num: 1
Key tag: *NULL*
STL tag: *NULL*
Copy on hold: 0
root@nb-ser:/# bpimagelist -backupid
dm01db01-priv1.service.intra_1444744121 -L
Client: dm01db01-priv1.service.intra
Backup ID: dm01db01-priv1.service.intra_1444744121
Policy: 2_exadata
Policy Type: Oracle (4)
Proxy Client: (none specified)
Creator: oracle
Name1: (none specified)
Sched Label: week
Schedule Type: UBAK (2)
Retention Level: 1 week (0)
Backup Time: Tue Oct 13 15:48:41 CEST 2015 (1444744121)
Elapsed Time: 6 second(s)
Expiration Time: Tue Oct 20 15:48:41 CEST 2015 (1445348921)
Compressed: yes
Client Encrypted: no
Kilobytes: 448
Number of Files: 1
Number of Copies: 1
Number of Fragments: 1
Histogram: 0 0 0 0 0 0 0 0 0 0
DB Compressed: no
Files File Name: 2_exadata_1444744121_UBAK.f
Previous Backup Files File Name: (none specified)
Parent Backup Image File Name: (none specified)
SW Version: (none specified)
Options: 0x0
MPX: 0
TIR Info: 0
TIR Expiration: Thu Jan 1 01:00:00 CET 1970 (0)
Keyword: dbm01
Ext Security Info: no
File Restore Raw: no
Image Dump Level: 0
File System Only: no
Object Descriptor: (none specified)
Previous BI Time: Thu Jan 1 01:00:00 CET 1970 (0)
BI Full Time: Thu Jan 1 01:00:00 CET 1970 (0)
Request Pid: 0
Backup Status: 0
Stream Number: 0
Backup Copy: Standard (0)
Files File size: 641
PFI type: 0
IMAGE_ATTRIBUTE: 0
Primary Copy: 2
Image Type: 0 (Regular)
Job ID: 1211258
Num Resumes: 1
Resume Expiration: Thu Jan 1 01:00:00 CET 1970 (0)
Data Classification: (none specified)
Data_Classification_ID: (none specified)
Storage Lifecycle Policy: (none specified)
Storage Lifecycle Policy Version: 0
STL_Completed: 0
Remote Expiration Time: Thu Jan 1 01:00:00 CET 1970 (0) Origin Master Server: (none specified)
Origin Master GUID: (none specified)
Snap Time: Thu Jan 1 01:00:00 CET 1970 (0)
IR Enabled: no
Client Character Set: 1
Image On Hold: 0
Indexing Status: 0
Copy number: 2
Fragment: 1
Kilobytes: 448
Remainder: 0
Media Type: Media Manager (2)
Density: hcart2 (14)
File Num: 37
ID: 500063
Host: examedia02
Block Size: 65536
Offset: 5145976
Media Date: Wed Oct 7 16:13:26 CEST 2015 (1444227206)
Dev Written On: 3
Flags: 0x0
Media Descriptor: ?
Expiration Time: Tue Oct 20 15:48:41 CEST 2015 (1445348921)
MPX: 0
retention_lvl: 1 week (0)
Try to Keep Time: Thu Jan 1 01:00:00 CET 1970 (0)
Copy Creation Time: Wed Oct 14 08:40:31 CEST 2015 (1444804831)
Data Format: Tar
checkpoint: 0
resume num: 1
Key tag: *NULL*
STL tag: *NULL*
Copy on hold: 0
root@nb-ser:/#