Veritas InfoScale™ 8.0.2 Storage and Availability Management for Oracle Databases - AIX, Linux, Solaris

To set up the secondary node

1. Create a disk group with the same name as the primary node disk group.

   # vxdg init vvrdg sdag sdah sdai sdaj

2. Create directories for the data volume and the archive log volume, and assign their ownership to the Oracle user.

   # mkdir -p /data
   # mkdir -p /arch
   # chown -R ora11gr2:dba /data
   # chown -R ora11gr2:dba /arch
   
   
   

3. Create a data volume and an archive log volume of the same names and lengths as the primary node volumes.

   # vxassist -g vvrdg make datavol 4500m alloc=sdj,sdk
   # vxassist -g vvrdg make archvol 4500m alloc=sdl,sdm

4. Add a DCM (Data Change Map) log to the data volume and the archive log volume.

   # vxassist -g vvrdg addlog datavol logtype=dcm nlog=2 logdisk=sdj,sdk
   # vxassist -g vvrdg addlog archvol logtype=dcm nlog=2 logdisk=sdl,sdm
   

5. Change the ownership and permission of the directories that contain data volumes and archive log volumes.

   # chown -R ora11gr2:dba /data*
   # chown -R ora11gr2:dba /arch* 
   
   
   

6. Prepare the data volume and the archive log volume for snapshot operations with DRL (Dirty Region Logging) disabled.

   # vxsnap -g vvrdg prepare datavol drl=no alloc=sdn,sdo
   # vxsnap -g vvrdg prepare archvol drl=no alloc=sdp,sdq
   

   Note:

   To use the data on the secondary host to perform off-host processing operations, use snapshots of the secondary data volumes. Do not mount the secondary RVG volumes directly, even in read-only mode.

   A snapshot is an image of the online data volumes at a specific point-in-time. The data on the original volumes may change but the data on the snapshot can still be used as a stable and independent copy for various purposes.

7. Verify that the data volume and the archive log volume are prepared for instant snapshots.

   # vxprint -g vvrdg -F%instant datavol
   # vxprint -g vvrdg -F%instant archvol
   

   Note:

   VVR provides two methods of creating snapshots: instant snapshots and traditional snapshots. You would require Veritas InfoScale Enterprise and Veritas InfoScale Storage licenses for the instant snapshot feature of VxVM.

8. Add mirrors to the data volume and the archive log volume for use in creating third-mirror break-off snapshots.

   # vxsnap -g vvrdg addmir datavol alloc=sdr
   # vxsnap -g vvrdg addmir archvol alloc=sds
   

9. Set the dbed_flashsnap tag on the break-off data plexes for the data volume and the archive log volume.

   # vxedit -g vvrdg set putil2=dbed_flashsnap datavol-04
   # vxedit -g vvrdg set putil2=dbed_flashsnap archvol-04
   

10. Create SRLs (Storage Replicator Logs) for data volumes and archive log volumes on the secondary node.

    # vxassist -g vvrdg make datavol_srl 4500M alloc=sdt
    # vxassist -g vvrdg make archvol_srl 4500M alloc=sdu
    

    Note:

    Create an SRL of the same name as the primary SRL. Please note that the SRL cannot be a volume set or a component volume of a volume set.

    If the Primary RVG (Replicated Volume Group) includes a volume set, make sure that the component volumes on the secondary to be added have identical names, lengths, and indices as the component volumes on the primary.