[Translated from mos] How to obtain the growth information of datafile backup, mosdatafile
How to obtain the growth information of datafile backup?
Source:
HOWTO get information about the growth of the datafile backup (Document ID 352777.1)
Applicable:
Oracle Server-Enterprise Edition-Version: 8.1.7.4 to 10.2.0.1-Release: 8.1.7 to 10.2
Oracle Server-Enterprise Edition-Version: 8.1.7.4 to 11.1.0.7 [Release: 8.1.7 to 11.1]
Information in this document applies to any platform.
Objectives:
It is useful in the following situations:
-- Check when backup time increases
-- Future backup space requirements
-- Filling grade of a datafile.
Solution:
You can query from RC_BACKUP_DATAFILE or V $ BACKUP_DATAFILE.
The BLOCKS column is the number of BLOCKS backed up (that is, the number of BLOCKS involved in the backup)
The DATAFILE_BLOCKS column is the total number of blocks in the datafile.
MAN catalog :Example for the increase in the last 14 days :SQL> select file#, min(blocks), max(blocks), max(blocks) - min(blocks) from rc_backup_datafile where db_name='V920' and completion_time > sysdate - 14 group by file# order by max(blocks)- min(blocks);
controlfile:SQL> select file#, min(blocks), max(blocks), max(blocks) - min(blocks) from v$backup_datafile where completion_time > sysdate - 14 group by file# order by max(blocks)- min(blocks);