In this first part of a 3 series article, I am going to provide a complete reference for Netbackup administrators in installing oracle agent, and configuring backups
Installing Netbackup for Oracle agent on Unix Servers
All the steps outlined below assume that you have already installed Netbackup client version 6.5 on the oracle server.
First we need to install Netbackup for oracle agent from the UnixOptions CD. If you have it handy, great, else refer the Required stuff section below . Mount the cd\iso image on your Unix system, and run the install script. Select the second option to install Database Agent software
--------------------------------------------------------
NetBackup Database Agent Installation
Choose the Database Agents you wish to install
one at a time or select Install All Database Agents.
1) NetBackup for DB2
2) NetBackup for Informix
3) NetBackup for Lotus Notes
4) NetBackup for Oracle
5) NetBackup for SAP
6) NetBackup for Sybase
7) Install All Database Agents
q) Done Selecting Agents
x) Exit from this Script
Choose an option: 4
Choose an option: q
You have chosen to install these Database Agents:
NetBackup for Oracle
Is this list correct? [y,n] (y) y
--------------------------------------------------------
This will put the required binaries in the /usr/openv/netbackup/bin directory
oracle@blaster:/usr/openv/netbackup/bin> ls -al libobk*
-r-xr-xr-x 1 root daemon 82663 2009-05-02 01:12 libobk.so
-r-xr-xr-x 1 root daemon 85913 2009-05-02 01:13 libobk.so64
Shutdown all oracle instances on this client. The reason: sometimes Oracle will take a shared library (such as ours) and place it into its shared memory space. Then each time RMAN runs it will use the library it has in shared memory, not the one on disk. So even though this upgrade will replace files on disk, Oracle will ignore the newly upgraded NetBackup library.
There are ways of pulling shared libraries out of a running Oracle instance, but if one is not experienced in doing this one can crash the Oracle instance hard. The easiest and safest way to force Oracle to replace a shared library is to stop/restart Oracle (as with any advice of this type, please confirm with Oracle support). These steps are also recommended by Oracle support in metalink article "341706.1" ("metalink.oracle.com") and at “http://support.veritas.com/docs/289237”. Some customers find it easier to reboot the host, which ensures all instances are down and that the cache comes up clean.
Technote: How to confirm that Oracle is loading the correct NBU Oracle extension library files for use?
http://seer.entsupport.symantec.com/docs/327725.htm
Now, as oracle user, run the /usr/openv/netbackup/bin/oracle_link script
Technote: Linking NetBackup for Oracle with RMAN
http://seer.entsupport.symantec.com/docs/311664.htm
This basically links the /usr/openv/netbackup/bin/libobk.so library with $ORACLE_HOME/lib/libobk.so i.e. creates a softlink to the libobk binary under netbackup/bin folder.
oracle@blaster:/opt/oracle/product/10.2/db_1/lib> ls -al libobk*
lrwxrwxrwx 1 oracle oinstall 34 2009-06-27 06:48 libobk.so -> /usr/openv/netbackup/bin/libobk.so
lrwxrwxrwx 1 oracle users 34 2009-06-25 08:37 libobk.so.back -> /usr/openv/netbackup/bin/libobk.so
Ok, the agent is installed and configured, how about testing if the linking has been done properly.
As Oracle user, go to rman prompt, and allocate a Tape channel
RMAN> allocate channel for maintenance type 'SBT_TAPE';
Example:
$ rman target sys/password@SID
Recovery Manager: Release 10.2.0.1.0 - Production on Mon Aug 3 21:46:08 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: VOLCANO (DBID=469066594)
RMAN> allocate channel for maintenance type 'SBT_TAPE';
using target database control file instead of recovery catalog
allocated channel: ORA_MAINT_SBT_TAPE_1
channel ORA_MAINT_SBT_TAPE_1: sid=153 devtype=SBT_TAPE
channel ORA_MAINT_SBT_TAPE_1: Veritas NetBackup for Oracle - Release 6.5 (2009050106)
********
Alternatively, you can allocate a channel in a run block as shown below:
$ rman target sys/password@SID
Recovery Manager: Release 10.2.0.1.0 - Production on Mon Aug 3 21:47:05 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: VOLCANO (DBID=469066594)
RMAN> run {
2> allocate channel ch00 type 'SBT_TAPE';
3> release channel ch00;
4> }
using target database control file instead of recovery catalog
allocated channel: ch00
channel ch00: sid=152 devtype=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle - Release 6.5 (2009050106)
released channel: ch00
******************
Congratulations!. Your Netbackup for Oracle agent is installed and configured for use. You can refer to the 2nd article in this series for a demo of backups.
====================================
NOTE: The instructions above were for installing Netbackup for Oracle agent v 6.5. To apply 6.5.2 or 6.5.4 patch, the Netbackup Client package must be at 6.5.2 or 6.5.4. i.e. Database agent must be at the same level as the Netbackup Client Steps for installation and configuration are the same
====================================
Required Stuff
Netbackup for Oracle 6.5 Base package
Netbackup_6.5UnixOptions.tar.gz
https://fileconnect.symantec.com
How to obtain the installation source download and license keys for NetBackup Server, NetBackup Enterprise Server, and components.
http://seer.entsupport.symantec.com/docs/308850.htm
