Oracle RAC configuration for EBR.

We have decided to go with EBR as the backup startegy for RAC. This is bit tricky we have to first register the EBR VIP into the CRS Stack and then start the resources for the EBR to actually backup the database. First let us see few characteristics of EBR_VIP as follows:

The EBR_VIP is required to be configured on only one node of the cluster
• The EBR_VIP can be moved to any node in the cluster providing each node has NICs
configured on the EBR network
• The EBR_VIP exists on only one node in the cluster at any time
• The EBR_VIP IP address is provided in the EBR Client Design document, provided by
the EBR Team
• The EBR backup server only communicates with the node on which the EBR_VIP
resides, hence the entire backup or restore datastream is via this node
• The EBR_VIP is configured in DNS with the name provided in the Client EBR Design
document. This name is the Netbackup Client Name.


Creating EBR VIP
------------------------------------------------

crs_profile –create ebr_vip1 -t application \
-a $CRS_HOME/bin/usrvip \
-o oi=nxge6,ov=10.106.194.87,on=255.255.252.0

• ebr_vip1 is the name assigned to the new CRS resource

• $CRS_HOME is the home directory for the Oracle Clusterware installation.

• nxge6 is the name of the public network adapter

• 10.106.194.87 is the EBR_VIP1 cluster IP address that will be used by EBR to

• connect regardless of the node it is running on.

• 255.255.252.0 is the netmask for the public IP address

Registering the EBR VIP in CRS stack
-----------------------------------------
crs_register ebr_vip1

as root user
-----------------------------------------
./crs_setperm ebr_vip1 –o root

./crs_setperm ebr_vip1 –u user:oracle:r-x

as oracle user start the ebr_vip1
----------------------------------------
crs_start ebr_vip1

check the resource is started
---------------------------------------
crs_stat | grep ebr_vip1

If there are two databases register EBR VIP per database create the EBR_VIP2 same as the above.

Check the resource has been started:

cd $ORA_CRS_HOME/bin

crs_stat | grep ebr_vip1

Once the VIP is registered create the TNS alias entries Add the service names to tnsnames.ora on both the nodes If its is two node RAC configuration as follows:

Node1:

EBR_RACDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = node1-oravip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = node2-oravip)(PORT = 1521))
(LOAD_BALANCE=OFF)

)
(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = RACDB1))
)

Node2:

EBR_RACDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = node1-oravip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = node2-oravip)(PORT = 1521))
(LOAD_BALANCE=OFF)

)
(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = RACDB2))
)

Create the EBR database user and grant necessary privileges
--------------------------------------------------------------
create user EBR identified by
2 default tablespace USERS
3 temporary tablespace TEMP;

grant SYSDBA to EBR;
grant create, Alter session privilege to EBR;

Now test the connectivity on both the nodes as follows:

Node1-> sqlplus EBR/password@EBR_RACDB as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production on Thu Feb 21 14:19:46 2008
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit
Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining
options