How do I find out how many (or %) of blocks changed between RMAN backups?
(Doc ID 866166.1)
Last updated on JUNE 23, 2023
Applies to:
Oracle Cloud Infrastructure - Database Service - Version N/A and laterOracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Information in this document applies to any platform.
Information in this document applies to any platform.
Goal
Customers often request queries to tell how many blocks changed between backups, to better understand database usage. You query the v$backup_datafile view as shown, to determine how effective the change tracking data is in minimizing the incremental backup I/O (the pct_read_for_backup column). A high percentage for the pct_read_for_backup column indicates that RMAN reads most blocks in the data file during an incremental backup. To reduce this ratio you decrease the time between incremental backups.
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |
| Instructions |
| Sample Code |
| References |