Is there a way of determining how much of an online backup is taken up by the BI?
prorest -list give me the extent sizes but doesn't list the BI size.
BI information was added to prorest -list in 11.1. Prior to that, your best bet would be to look at the original DB's lg file and look for backup message (6688) which states the number of BI blocks written. Prior to 11.3's bibackup active optimization, online backup always backed up all of the BI.
In 11.3 and later, backup also writes out message (16866) for the number of active BI blocks written.
prorest -list actually does list BI = Primary Recovery Area
$ prorest sports sports.bkp -list
Area Name: Primary Recovery Area
Size: 606, Records/Block: N/A, Area Number: 3
So 606 * (Before image block size) is your BI size.
606 * 8192 = 4964352
BI information was added to prorest -list in 11.1. Prior to that, your best bet would be to look at the original DB's lg file and look for backup message (6688) which states the number of BI blocks written. Prior to 11.3's bibackup active optimization, online backup always backed up all of the BI.
In 11.3 and later, backup also writes out message (16866) for the number of active BI blocks written.
Kyle - thanks for that, looking in the log file is a good tip.
Dimitri - this doesn't get output by the version I'm using.