Create BCT on ASM at Auxiliary site
1) Check for location of BCT file at the source
SQL>SELECT filename bct_file, status, bytes FROM V$block_change_tracking;
BCT_FILE STATUS BYTES
------------------------------------------------------------ ---------------- -------------
+DATA1/oratst1/changetracking/oratst1.bct ENABLED 21577854
1 row selected.
ASMCMD> ls -l
Type Redund Striped Time Sys Name
CHANGETRACKING MIRROR COARSE APR 03 16:00:00 Y ctf.148.645783219
N oratst1.bct =>+DATA1/ORATST1/CHANGETRACKING/ctf.148.645783219
BCT_FILE STATUS BYTES
------------------------------------------------------------ ---------------- -------------
+DATA1/oratst1/changetracking/oratst1.bct ENABLED 21577854
1 row selected.
ASMCMD> ls -l
Type Redund Striped Time Sys Name
CHANGETRACKING MIRROR COARSE APR 03 16:00:00 Y ctf.148.645783219
N oratst1.bct =>+DATA1/ORATST1/CHANGETRACKING/ctf.148.645783219
2) Copy the Block change tracking file to Filesystem
ASMCMD> cp +DATA1/ORATST1/changetracking/oratst1.bct /tmp/.
copying +DATA1/ORATST1/changetracking/oratst1.bct -> /tmp/./oratst1.bct
3) Transfer the File to target server ( scp etc)
4) At the auxiliary site copy file from filesytem to ASM
$ cd /tmp
$ ls -ltr
-rw-r-----. 1 oracle oinstall 21578366 Apr 3 16:44 oratst1.bct
ASMCMD> cp /tmp/oratst1.bct .
copying /tmp/oratst1.bct -> +DATA1/tst/oratst1.bct
ASMCMD> ls -l oratst1.bct
Type Redund Striped Time Sys Name
N oratst1.bct => +DATA1/ASM/CHANGETRACKING/oratst1.bct. 146.345879567
$ ls -ltr
-rw-r-----. 1 oracle oinstall 21578366 Apr 3 16:44 oratst1.bct
ASMCMD> cp /tmp/oratst1.bct .
copying /tmp/oratst1.bct -> +DATA1/tst/oratst1.bct
ASMCMD> ls -l oratst1.bct
Type Redund Striped Time Sys Name
N oratst1.bct => +DATA1/ASM/CHANGETRACKING/oratst1.bct. 146.345879567
Notes : Refer to Metalink Note 1480112.1
No comments:
Post a Comment