NetBackup for Oracle server agent
The NetBackup Oracle agent automatically uses the accurate licensing model when capacity licensing is used. After a backup is complete using the Oracle policy type, the NetBackup for Oracle agent captures the size of data that the policy protects. This data is reported to the master server. The size of the data that is reported does not include the NetBackup for Oracle XML Archiver.
Accurate licensing for Oracle is specific to an Oracle policy. This type of licensing collects the front-end data size (FEDS) for any Oracle backup that can be restored, not including transaction logs. The backup selection is defined in the Oracle Instances and Databases tabs in the policy (OIP, templates, and scripts). The data size collection may not work properly if OS authentication is disabled.
The following Oracle queries are used to gather file size information.
Get size of database files being backed up
Given the database file name(s) that are backed up, these queries retrieve the file size (in MB) for every database in an instance. These queries do not include the transaction log:
select name, BYTES/1024/1024 from v$datafile; (where name is the name of the database file being protected in the backup policy)
Or to collect the entire sum of the database files in the instance, use the following query:
select sum(BYTES/1024/1024) from v$datafile;
Get the size of the control file
Given the database name, this query gets the control file size (size is only collected for one) in MB, not including transaction log:
select name, BLOCK_SIZE*FILE_SIZE_BLKS/1024/1024 controlfile_size from v$controlfile;