> CommCell Console > Backup and Restore Agents > Snapshot Management > Supported Agents > SAP for Oracle > SAP Oracle IntelliSnap Configuration > IntelliSnap Backup for SAP Split-Mirror Disks (Splitint Support)

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/initSID.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,

×

Loading...