Benutzer-Werkzeuge

Webseiten-Werkzeuge

Action disabled: index

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
Diese Website verwendet Cookies. Durch die Nutzung der Website stimmen Sie dem Speichern von Cookies auf Ihrem Computer zu. Außerdem bestätigen Sie, dass Sie unsere Datenschutzbestimmungen gelesen und verstanden haben. Wenn Sie nicht einverstanden sind, verlassen Sie die Website.Weitere Information
"Autor: Gunther Pipperr"
dba/backup_block_change_tracking.txt · Zuletzt geändert: 2010/10/04 12:05 von gpipperr