Wednesday, April 10, 2013

Create BCT on ASM at auxiliary for RMAN duplicate



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

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

------------------------------------------------------------------------------------------------------------------------------------
Notes : Refer to Metalink Note 1480112.1

No comments:

Post a Comment