dba:backup_block_change_tracking
Change Tracking
To create the Change Tracking file and enable Change Tracking, make sure the database is either open or mounted. Then issue an ALTER DATABASE command:
ALTER DATABASE
ENABLE BLOCK CHANGE TRACKING USING FILE <pathname>;
where <pathname> is the operating system pathname to the location where you want the Change Tracking file to be stored. (If you have Oracle Managed Files enabled, the USING clause is optional, and the file will be created in the directory pointed to by DB_CREATE_FILE_DEST.)
Regardless of how the path is determined, the file begins at 10MB in size and grows by 10MB if it needs to be extended.
# CREATE directory ON the ASM # SET Oracle SID TO ASM asmcmd ASMCMD>cd +DATA/GPIDB ASMCMD>mkdir change_tracking ASMCMD>EXIT # #set Oracle SID TO GPIDB1 sqlplus / AS sysdba sqlplus> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE '+DATA/GPIDB/change_tracking/GPIDB_changetrack.dmp'; Database altered. sql>SELECT filename, status, bytes FROM v$block_change_tracking; FILENAME STATUS BYTES ----------------------------- -------------- ---------- +DATA/GPIDB/change_tracking/GPIDB_changetrack.dmp ENABLED 11599872
dba/backup_block_change_tracking.txt · Zuletzt geändert: 2010/10/04 12:05 von gpipperr