Benutzer-Werkzeuge

Webseiten-Werkzeuge


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
Cookies helfen bei der Bereitstellung von Inhalten. Durch die Nutzung dieser Seiten erklären Sie sich damit einverstanden, dass Cookies auf Ihrem Rechner gespeichert werden. Weitere Information
"Autor: Gunther Pipperr"
dba/backup_block_change_tracking.txt · Zuletzt geändert: 2010/10/04 12:05 von Gunther Pippèrr