Solution : https://service.sap.com/sap/support/notes/964619 (SAP Service marketplace login required)
Summary :
This SAP Note summarizes the use of Block Change Tracking (BCT) for efficient RMAN-based incremental backups in Oracle databases, starting from version 10.2. BCT significantly enhances backup speeds by logging changed data blocks in a dedicated BCT File, thus avoiding full scans during backups. It covers practical aspects including activation commands, default file location across different platforms, and integration with SAP BR*Tools. Recommendations and monitoring strategies for maintaining Btrfs efficacy are detailed, ensuring optimal backup performance and minimal impact on system resources.
Key words :
block change tracking status monitoringsql> column status format a8sql> column filename format a60sql> select status, sap br toolsblock change tracking - recommendationsblock change tracking - administration block change tracking - description block change tracking, block change tracking - administration activating block change trackingsql> alter database enable block change tracking, note block change tracking - descriptionblock change tracking - configurationblock change tracking - support, activate block change tracking againsql> alter database enable block change tracking, stopping background process ctwrdeleted file /oracle/qo1/112_64/dbs/bctf, deactivate block change trackingsql> alter database disable block change tracking, deactivating block change trackingsql> alter database disable block change tracking, activatedsql> alter database enable block change tracking, unix/linux platforms'<oracle_home>/dbs/bctf<dbsid>
Related Notes :
| 842240 | FAQ: Backup strategy of large and highly-available databases |
| 828268 | Oracle Database 10g: New functions |
| 619188 | FAQ: Oracle wait events |
| 105047 | Support for Oracle functions in the SAP environment |