{"id":4899,"date":"2023-05-08T09:26:12","date_gmt":"2023-05-08T00:26:12","guid":{"rendered":"http:\/\/oracledba.zapto.org\/wordpress\/?p=4899"},"modified":"2023-05-08T09:26:12","modified_gmt":"2023-05-08T00:26:12","slug":"oracle-block-change-tracking-%ea%b8%b0%eb%8a%a5","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=4899","title":{"rendered":"Oracle Block change tracking \uae30\ub2a5"},"content":{"rendered":"

. \ub370\uc774\ud130 \ube14\ub85d\ub4e4\uc758 \ubcc0\uacbd\ub41c \ube14\ub85d\ub9cc \ucd94\uc801\ud558\ub294 \uae30\ub2a5 \ube14\ub85d\ub4e4\uc758 \ubcc0\uacbd\uc0ac\ud56d\uc740 \ud2b9\uc815 \ud30c\uc77c\uc5d0 \uc800\uc7a5 \ub418\uc5b4 \uad00\ub9ac\ub428<\/p>\n

. RMAN \uc99d\ubd84 \ubc31\uc5c5 \uc18d\ub3c4 \uc640 \uc815\ud655\ub3c4\uac00 \ud5a5\uc0c1 \ub428<\/p>\n

 <\/p>\n

 <\/p>\n

\uc124\uc815\ud558\uae30<\/b><\/p>\n

1. \ud65c\uc131\ud654<\/b><\/p>\n

\n
\n\n\n\n
\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n<\/div>\n<\/td>\n
\n
\n
SQL>\u00a0alter\u00a0database\u00a0enable\u00a0block\u00a0change\u00a0tracking\u00a0using\u00a0file\u00a0‘\/data\/backup\/rman\/block_tracking.txt’;<\/div>\n
$\u00a0cd\u00a0\/data\/backup\/rman<\/div>\n
$\u00a0ls\u00a0-lSh\u00a0*.txt<\/div>\n
$\u00a0vi\u00a0block_tracking.txt<\/div>\n
…<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

\ubc14\uc774\ub108\ub9ac \ud30c\uc77c \ud615\ud0dc\uc784<\/b><\/p>\n

2. \ube44\ud65c\uc131\ud654<\/b><\/p>\n

\n\n\n\n
\n
\n
1<\/div>\n<\/div>\n<\/td>\n
\n
\n
SQL>\u00a0alter\u00a0database\u00a0disable\u00a0block\u00a0chang\u00a0tracking;<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

3. \ud65c\uc131\ud654 \uc0c1\ud0dc \uc870\ud68c<\/b><\/p>\n

\ud65c\uc131\ud654 \uc804<\/b><\/p>\n

\n\n\n\n
\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n<\/div>\n<\/td>\n
\n
\n
SQL>\u00a0col\u00a0status\u00a0for\u00a0a10<\/div>\n
SQL>\u00a0col\u00a0filename\u00a0for\u00a0a50<\/div>\n
SQL>\u00a0col\u00a0MB\u00a0for\u00a0999999<\/div>\n
SQL>\u00a0select\u00a0status,\u00a0filename,\u00a0bytes\/1024\/1024\u00a0MB<\/div>\n
from\u00a0v$block_change_tracking;<\/div>\n
<\/div>\n
STATUS\u00a0\u00a0\u00a0\u00a0\u00a0FILENAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0MB<\/div>\n
———-\u00a0————————————————–\u00a0——-<\/div>\n
DISABLED<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

\ud65c\uc131\ud654 \ud6c4<\/b><\/p>\n

\n\n\n\n
\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n<\/div>\n<\/td>\n
\n
\n
SQL>\u00a0col\u00a0status\u00a0for\u00a0a10<\/div>\n
SQL>\u00a0col\u00a0filename\u00a0for\u00a0a50<\/div>\n
SQL>\u00a0col\u00a0MB\u00a0for\u00a0999999<\/div>\n
SQL>\u00a0select\u00a0status,\u00a0filename,\u00a0bytes\/1024\/1024\u00a0MB<\/div>\n
from\u00a0v$block_change_tracking;<\/div>\n
<\/div>\n
STATUS\u00a0\u00a0\u00a0\u00a0\u00a0FILENAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0MB<\/div>\n
———-\u00a0————————————————–\u00a0——-<\/div>\n
ENABLED\u00a0\u00a0\u00a0\u00a0\/data\/backup\/rman\/block_tracking.txt\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a011<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

 <\/p>\n

Enabling Block Change Tracking<\/b><\/p>\n

To enable block change tracking for the database, use the following command:<\/p>\n

\n

alter database enable block change tracking using file \/u01\/oracle\/product\/10.2.0\/db_1\/oradata\/mydb\/blk_track.trc’;<\/span><\/p>\n<\/div>\n

If there is already a file named blk_track.trc and it needs to be overwritten, add a REUSE clause as follows:<\/p>\n

\n

alter database enable block change tracking using file \/u01\/oracle\/product\/10.2.0\/db_1\/oradata\/mydb\/blk_track.trc’ REUSE;<\/span><\/p>\n<\/div>\n

If the db_create_file_dest parameter is used, then the name of the tracking file should be omitted as follows:<\/p>\n

\n

ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;<\/span><\/p>\n<\/div>\n

When enabling the change tracking feature, the following lines are added to the alert.log file:<\/p>\n

\n

alter database enable block change tracking using file
\n‘\/u01\/oracle\/product\/10.2.0\/db_1\/oradata\/mydb\/blk_track.trc’
\nMon Mar 8 16:07:20 2015
\nBlock change tracking file is current.
\nStarting background process CTWR
\nCTWR started with pid=22, OS id=4796
\nBlock change tracking service is active.
\nMon Mar\u00a0 8 16:07:21 2015
\nCompleted: alter database enable block change tracking using file
\n‘\/u01\/oracle\/product\/10.2.0\/db_1\/oradata\/mydb\/blk_track.trc’<\/span><\/p>\n<\/div>\n

And the new CTWR process will be created to track the changes:<\/p>\n

\n

[oracle@localhost ~]$ ps -ef | grep ctwr
\noracle\u00a0\u00a0\u00a0 4796\u00a0\u00a0\u00a0\u00a0 1\u00a0 0 16:07 ?\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 00:00:00 ora_ctwr_mydb<\/span><\/p>\n<\/div>\n

 <\/p>\n

Rman Performance of Block change Tracking in Oracle 12c<\/h1>\n

 <\/p>\n

lock Change Tracking :<\/p>\n

 <\/p>\n

* Block Change Tracking Feature is used to speed up the RMAN incremental backup.<\/p>\n

 <\/p>\n

*After Enabling this feature the records modified since the last backup and log stored of it in a block change tracking file using the change<\/p>\n

Tracking writer(CTWR) Process.<\/p>\n

 <\/p>\n

*Records modified since the last backup and stores log of it in the blcok change tracking file.<\/p>\n

 <\/p>\n

*During backup RMAN uses the logfile to identify the specific blocks that must be backedup.<\/p>\n

 <\/p>\n

*Block Change Tracking is not read the whole database blocks but only read the changed blocks which results in the block change tracking file.<\/p>\n

 <\/p>\n

*Block Change Tracking file is not read all the datafile blocks but read the changed blocks and take backups.<\/p>\n

 <\/p>\n

STEP 1:<\/p>\n

 <\/p>\n

Enable the Block Change Tracking Feature.<\/p>\n

 <\/p>\n

SQL>alter database enable block change tracking using file \u2018\/u02\/prod\/blockfile.log\u2019<\/p><\/blockquote>\n

 <\/p>\n

 <\/p>\n

STEP 2:<\/p>\n

 <\/p>\n

Check the status of the enabled block change tracking file.<\/p>\n

SQL>select file_name,status from v$block_change_tracking<\/p><\/blockquote>\n

 <\/p>\n

 <\/p>\n

STEP 3:<\/p>\n

 <\/p>\n

Check the Change Tracking writer (CTWR) is started.<\/p>\n

 <\/p>\n

SQL>select * from v$sgastat where name like %CTWR%<\/p><\/blockquote>\n

 <\/p>\n

SQL>select sid,program,status from v$session where name like %CTWR%<\/p>\n

STEP 4:<\/p>\n

 <\/p>\n

Disable the Block change Tracking Feature.<\/p>\n

 <\/p>\n

SQL>alter database disable block change tracking;<\/p>\n

SQL>select sid,program,status from v$session where name like %CTWR%<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"

. \ub370\uc774\ud130 \ube14\ub85d\ub4e4\uc758 \ubcc0\uacbd\ub41c \ube14\ub85d\ub9cc \ucd94\uc801\ud558\ub294 \uae30\ub2a5 \ube14\ub85d\ub4e4\uc758 \ubcc0\uacbd\uc0ac\ud56d\uc740 \ud2b9\uc815 \ud30c\uc77c\uc5d0 \uc800\uc7a5 \ub418\uc5b4 \uad00\ub9ac\ub428 . RMAN \uc99d\ubd84 \ubc31\uc5c5 \uc18d\ub3c4 \uc640 \uc815\ud655\ub3c4\uac00 \ud5a5\uc0c1 \ub428     \uc124\uc815\ud558\uae30 1. \ud65c\uc131\ud654 1 2 3 4 5 SQL>\u00a0alter\u00a0database\u00a0enable\u00a0block\u00a0change\u00a0tracking\u00a0using\u00a0file\u00a0‘\/data\/backup\/rman\/block_tracking.txt’; $\u00a0cd\u00a0\/data\/backup\/rman $\u00a0ls\u00a0-lSh\u00a0*.txt $\u00a0vi\u00a0block_tracking.txt … \ubc14\uc774\ub108\ub9ac \ud30c\uc77c \ud615\ud0dc\uc784 2. \ube44\ud65c\uc131\ud654 1 SQL>\u00a0alter\u00a0database\u00a0disable\u00a0block\u00a0chang\u00a0tracking; 3. \ud65c\uc131\ud654 \uc0c1\ud0dc \uc870\ud68c \ud65c\uc131\ud654 \uc804 1 2 3 4 […]<\/p>\n","protected":false},"author":1,"featured_media":3406,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[9],"tags":[1514,1513,1515,1516,1518,1517],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/02\/Epi-194-M2M.jpg?fit=425%2C282","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4899"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4899"}],"version-history":[{"count":1,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4899\/revisions"}],"predecessor-version":[{"id":4900,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4899\/revisions\/4900"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/3406"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4899"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4899"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4899"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}