Loading...

Configuring BRBACKUP for Split-Mirror Disk Backups

You must configure a SAP Oracle instance for both the source and proxy client. You must configure the following on the production and proxy servers before performing split-mirror disk backups using BRBACKUP: 

  1. Create the SAP Instance from CommCell GUI for both Source and Proxy client. Install the Oracle SID on both the production and proxy servers. Make sure to install the same Oracle SID and maintain the same directory structure on both the production and proxy servers.

    Add the following parameter in the $ORACLE_HOME/dbs/init<SID>.utl file:

    CvSrcClient

    <Source_Client_Name>

    Example:

    Production=tigersnap
    Proxy=tigersnap2

    $ORACLE_HOME/dbs/init<SID>.utl file on the Proxy
    CvSrcClient
    tigersnap

  2. Configure the Snap-able volumes on the production server.

    Example:

    [root@tigersnap ~]# df -k
    Filesystem 1K-blocks Used Available Use% Mounted on
    /dev/mapper/VolGroup00-LogVol00
    32408432 30528060 207568 100% /
    /dev/sda1 101086 14827 81040 16% /boot
    tmpfs 972264 0 972264 0% /dev/shm
    /dev/sdj1 1031888 17736 961736 2% /home/oracle/product/10g/dbs
    /dev/sdg1 5156292 1373028 3521336 29% /home/oracle/product/10g/CER
    /dev/sdh1 3093976 831496 2105312 29% /home/oracle/product/10g/CER/DATA
    /dev/sde1 2062716 118036 1839900 7% /home/oracle/product/10g/CER/LOG
    [root@tigersnap ~]# ls -l /home/oracle/product/10g/CER
    total 48
    drwxrwx--- 9 oracle oracle 4096 Apr 27 17:52 DATA
    drwxrwx--- 7 oracle oracle 4096 May 29 16:34 LOG
    drwxrwxrwx 2 oracle oracle 16384 Apr 27 10:56 lost+found
    drwxrwxr-x 3 oracle oracle 4096 May 30 02:00 saparch
    drwxrwxr-x 2 oracle oracle 4096 May 29 16:37 sapbackup
    drwxrwxr-x 2 oracle oracle 4096 Apr 27 11:13 sapcheck
    drwxrwxr-x 2 oracle oracle 4096 Apr 30 11:11 sapreorg
    drwxrwxr-x 3 oracle oracle 4096 Apr 27 11:13 sapscripts
    drwxrwxr-x 4 oracle oracle 4096 Apr 27 11:13 saptrace
    [root@tigersnap ~]# ls -l /home/oracle/product/10g/CER/LOG
    total 76
    drwxrwxr-x 2 oracle oracle 4096 May 29 16:34 mirrlogA
    drwxrwxr-x 2 oracle oracle 4096 May 29 16:34 mirrlogB
    -rw-r----- 1 oracle oracle 2560 Oct 22 2010 orapwCER
    drwxrwx--- 2 oracle oracle 4096 May 29 16:34 origlogA
    drwxrwx--- 2 oracle oracle 4096 May 29 16:34 origlogB
    -rw-r----- 1 oracle oracle 2560 May 29 11:59 orapwCER
    [root@tigersnap ~]#

  3. Configure the volumes on the proxy server. Make sure that the data, logs, control files and the mirror are configured on separate volumes. This is to ensure that the sapbackup directory on the proxy is not replaced when you mount the snapshots /split-mirror disks on the proxy server.
  4. Configure the SSH with user equivalence (RSA Key sharing) between OraSID's on both the proxy server and production server. If you do not configure the SSH sharing, you will be prompted for the account passwords multiple times.

    You should meet the following User equivalency requirements:

    • You should have the same user name, UID and password on both the production and proxy servers
    • You should belong to the same group with the same group ID.

    Example:

    Make sure you get the same results on the production and the proxy:

    [oracle@tigersnap 10g]$ id oracle uid=501(oracle) gid=501(oracle) groups=501(oracle),502(dba)
    [oracle@tigersnap2 10g]$ id oracle
    uid=501(oracle) gid=501(oracle) groups=501(oracle),502(dba)

  5. Configure the Oracle Parameters on SID of both the production and proxy servers. Setup *.ora, *.sap, *.utl parameters on both the Production and Proxy servers.
  6. Configure the TNS names on the production and proxy servers.

    Example:

    [oracle@tigersnap admin]$ pwd
    /home/oracle/product/10g/network/admin
    [oracle@tigersnap admin]$ more tnsnames.ora
    # tnsnames.ora Network Configuration File: /home/oracle/product/10g/network/admin/tnsnames.ora
    # Generated by Oracle configuration tools.

    ORCL =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = tigersnap.commvault.com)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = orcl)
    )
    ) CER =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = tigersnap.commvault.com)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = CER)
    )
    ) CER.tigersnap =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = tigersnap.commvault.com)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = CER)
    )
    ) CER.tigersnap2 =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = tigersnap2.commvault.com)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = CER)
    )
    ) EXTPROC_CONNECTION_DATA =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
    (SID = PLSExtProc)
    (PRESENTATION = RO)
    )
    )

  7. Add the service name entries on the production server.

    Example:

    [oracle@tigersnap 10g]$ lsnrctl stop
    LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 06-OCT-2011 03:00:02
    Copyright (c) 1991, 2005, Oracle. All rights reserved.
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
    The command completed successfully

    [oracle@tigersnap 10g]$ sqlplus "/ as sysdba" SQL*Plus: Release 10.2.0.1.0 - Production on Thu Oct 6 03:00:13 2011
    Copyright (c) 1982, 2005, Oracle. All rights reserved.
    Connected to:
    Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
    With the Partitioning, OLAP and Data Mining options
    SQL> shutdown immediate;
    Database closed.
    Database dismounted.
    ORACLE instance shut down.
    SQL> startup nomount
    ORACLE instance started.
    Total System Global Area 88080384 bytes
    Fixed Size 1217836 bytes
    Variable Size 79694548 bytes
    Database Buffers 4194304 bytes
    Redo Buffers 2973696 bytes
    SQL> show parameters service_names
    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    service_names string CER
    SQL> alter system set service_names='CER,CER.tigersnap'
    2 ;
    System altered.
    SQL> show parameters service_names; NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    service_names string CER,CER.tigersnap
    SQL> shutdown immediate
    ORA-01507: database not mounted
    ORACLE instance shut down.
    SQL> startup
    ORACLE instance started.
    Total System Global Area 88080384 bytes
    Fixed Size 1217836 bytes
    Variable Size 79694548 bytes
    Database Buffers 4194304 bytes
    Redo Buffers 2973696 bytes
    Database mounted.
    Database opened.
    SQL> quit
    Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
    With the Partitioning, OLAP and Data Mining options
    [oracle@tigersnap 10g]$ lsnrctl start
    LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 30-MAY-2012 21:12:37
    Copyright (c) 1991, 2005, Oracle. All rights reserved.
    Starting /home/oracle/product/10g/bin/tnslsnr: please wait...
    TNSLSNR for Linux: Version 10.2.0.1.0 - Production
    System parameter file is /home/oracle/product/10g/network/admin/listener.ora
    Log messages written to /home/oracle/product/10g/network/log/listener.log
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=tigersnap.commvault.com)(PORT=1521)))
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
    Start Date 30-MAY-2012 21:12:39
    Uptime 0 days 0 hr. 0 min. 0 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP OFF
    Listener Parameter File /home/oracle/product/10g/network/admin/listener.ora
    Listener Log File /home/oracle/product/10g/network/log/listener.log
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=tigersnap.commvault.com)(PORT=1521)))
    Services Summary...
    Service "CER" has 1 instance(s).
    Instance "CER", status UNKNOWN, has 1 handler(s) for this service...
    Service "PLSExtProc" has 1 instance(s).
    Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    The command completed successfully
    [oracle@tigersnap 10g]$

  8. Configure the InitSID.* on the Production server.
    1. Add the following to initCER.sap

      RMAN_PARMS="BLKSIZE=1048576,SBT_LIBRARY=/opt/commvault/Base/libobk.so,
      ENV=(CvClientName=tigersnap,CvInstanceName=instance001)"
      _rman_sess_stmt = ("alter session set optimizer_mode=RULE")

    2. Add the following to initCER.ora

      remote_login_passwordfile = EXCLUSIVE
      control_file_record_keep_time = 100

    3. Add the following to initCER.utl

      CvInstanceName
      Instance001
      snapBackup
      1
      numstreams
      1
      CV_restCopyPrec
      0

  9. Configure the InitSID.* on the Proxy server.
    1. Add the following to initCER.sap

      primary_db = CER.tigersnap
      stage_copy_cmd = scp
      pipe_copy_cmd = ssh
      rman_channels = 1
      rman_filesperset = 64

      Example

      RMAN_PARMS="BLKSIZE=1048576,SBT_LIBRARY=/opt/commvault/Base/libobk.so,
      ENV=(CvClientName=tigersnap2,CvInstanceName=instance001,CvSrcClient=tigersnap)"
      _rman_sess_stmt = ("alter session set optimizer_mode=RULE")

    2. Add the following to initCER.ora

      control_file_record_keep_time = 100

    3. Add the following to initCER.utl

      CvInstanceName
      Instance001
      snapBackup
      0
      numstreams
      1

  10. The Snapshots/Split-mirror disks will be mounted (in place) on the proxy server. Make sure that those pertinent directories are empty on the proxy.
  11. Install the SAP Oracle iDataAgent on both the production and proxy servers.
  12. Configure the instance for the production server in the CommCell Console. See Configuration for instructions on how to configure an instance,

Last modified: 9/4/2018 6:34:38 PM