Thursday, January 31, 2008

Requirements :
Oracle DB Archivelog status = ON & Start …….. here
Controlfile Autobackup = ON…….. here
Default Autobackup device type = SBT_TAPE

Preparations :
Install Netbackup for Oracle Agent
Shutdown all of the Oracle instances (SIDs).
Login or su – from root to oracle user
# sqlplus /nolog
SQL> connect / as sysdba
SQL> shutdown immediate
SQL> exit

Link Netbackup to Oracle :
Automatically link :
/install_path /netbackup/bin/oracle_link
Manually Link :
ln -s /install_path /netbackup/bin/libobk.so.1 libobk.so (solaris)
ln -s /install_path /netbackup/bin/libobk.so64.1 libobk.so (solaris with 64-bit Oracle Software)
ln -s /install_path /netbackup/bin/libobk.a64 libobk.a (AIX)
ln -s /install_path /netbackup/bin/libobk.sl64 libobk.sl (HP-UX)
ln -s /install_path /netbackup/bin/libobk.so libobk.so (linux)
Test Connectivity from Oracle RMAN to Veritas Netbackup :
RMAN> run{allocate channel ch00 type 'SBT_TAPE';
2> release channel ch00;
3> }
Output :
using target database controlfile instead of recovery catalog
allocated channel: ch00
channel ch00: sid=14 devtype=SBT_TAPE
channel ch00: VERITAS NetBackup for Oracle - Release 5.0GA (2006030216)
released channel: ch00
RMAN> quit
Recovery Manager complete.

Hot Backup Oracle :

Create Online Backup Shell Script for Full DB & archivelogs refer to sample RMAN script on "/install_path/netbackup/ext/db_ext/oracle/samples/rman" or using template from Veritas Netbackup GUI Wizard.

Hot Backup Oracle SCRIPT…….. here
Hot Backup Oracle TEMPLATE…….. here

Create Policy for Full Online Backup & Archivelogs Backup.
Test Hot Backup Oracle using Veritas Netbackup.
Categories: ,

0 comments: