SQL> select status,filename from v$block_change_tracking;
STATUS FILENAME
---------- ----------------------------------------
DISABLED
SQL> alter database enable block change tracking;
Database altered.
SQL> select status,filename from v$block_change_tracking;
STATUS FILENAME
---------- ----------------------------------------
ENABLED +DATA/RAC/CHANGETRACKING/ctf.272.1014664
987
RMAN> backup incremental level 1 database tag "bkplvl1_BCT";
RMAN> SELECT USED_CHANGE_TRACKING, FILE#, AVG(DATAFILE_BLOCKS), AVG(BLOCKS_READ) FROM V$BACKUP_DATAFILE WHERE INCREMENTAL_LEVEL > 0 GROUP BY USED_CHANGE_TRACKING, FILE# ORDER BY 1;
USE FILE# AVG(DATAFILE_BLOCKS) AVG(BLOCKS_READ)
--- ---------- -------------------- ----------------
NO 1 111360 102400
NO 2 307200 288896
NO 3 189440 179776
NO 4 25600 4693.33333333333
NO 5 25600 2453.33333333333
NO 6 640 256
NO 7 12800 128
NO 8 12800 832
8 rows selected
RMAN>
STATUS FILENAME
---------- ----------------------------------------
DISABLED
SQL> alter database enable block change tracking;
Database altered.
SQL> select status,filename from v$block_change_tracking;
STATUS FILENAME
---------- ----------------------------------------
ENABLED +DATA/RAC/CHANGETRACKING/ctf.272.1014664
987
RMAN> backup incremental level 1 database tag "bkplvl1_BCT";
RMAN> SELECT USED_CHANGE_TRACKING, FILE#, AVG(DATAFILE_BLOCKS), AVG(BLOCKS_READ) FROM V$BACKUP_DATAFILE WHERE INCREMENTAL_LEVEL > 0 GROUP BY USED_CHANGE_TRACKING, FILE# ORDER BY 1;
USE FILE# AVG(DATAFILE_BLOCKS) AVG(BLOCKS_READ)
--- ---------- -------------------- ----------------
NO 1 111360 102400
NO 2 307200 288896
NO 3 189440 179776
NO 4 25600 4693.33333333333
NO 5 25600 2453.33333333333
NO 6 640 256
NO 7 12800 128
NO 8 12800 832
8 rows selected
RMAN>
No comments:
Post a Comment