Database is "UP" but Veritas Netbackup detect that the oracle db is down and cannot create template from Netbackup Java Console.
Because of this error, than I try to configure the Hot Backup Oracle using RMAN script provided by Netbackup on "/usr/openv/netbackup/ext/db_ext/oracle/samples/rman". Using this script, I also found the same error.
Here is our environtment variables on this server :
To SOLVE the problem, we "add" the ORACLE_BASE parameter to the Script :
Because of this error, than I try to configure the Hot Backup Oracle using RMAN script provided by Netbackup on "/usr/openv/netbackup/ext/db_ext/oracle/samples/rman". Using this script, I also found the same error.
We can connect locally to RMAN, and test the link to Veritas Netbackup with successfully.RMAN-00571:=============================================
RMAN-00569:======== ERROR MESSAGE STACK FOLLOWS =========
RMAN-00571:=============================================
RMAN-03002: failure of allocate command at 02/25/2008 15:12:29
RMAN-06403: could not obtain a fully authorized session
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory
bash-2.05$ pwd
/rdbms/oracle9
bash-2.05$ rman target veritas/veritasBut using the netbackup Java Console & Netbackup Script still the same error. After discuss with the DBA, refer to documentation support from Veritas Netbackup, and some tries, we found that, the problem is on environtment variables :
Recovery Manager: Release 9.2.0.6.0 - 64bit Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
connected to target database: ODONG2 (DBID=1263713746)
RMAN> RUN {
2> ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
3> RELEASE CHANNEL ch00;
4> }
using target database controlfile instead of recovery catalog
allocated channel: ch00
channel ch00: sid=38 devtype=SBT_TAPE
channel ch00: VERITAS NetBackup for Oracle - Release 5.0GA (2003103006)
released channel: ch00
RMAN> quit
Recovery Manager complete.
bash-2.05$
Here is our environtment variables on this server :
bash-2.05$ envAnd the problem is we cannot go directly to ORACLE_HOME using the script, but must be used "ORACLE_HOME=$ORACLE_BASE/OraHome1/" .
PWD=/rdbms/oracle9
ORACLE_SID=test
HOSTNAME=odong2
LD_LIBRARY_PATH=/rdbms/oracle9/OraHome1/lib
MACHTYPE=sparc-sun-solaris2.9
MAIL=/var/mail/oracle9
EDITOR=vi
ORACLE_BASE=/rdbms/oracle9/
ORACLE_HOME=/rdbms/oracle9//OraHome1/
LOGNAME=oracle9
SHELL=/bin/bash
HOSTTYPE=sparc
OSTYPE=solaris2.9
HOME=/rdbms/oracle9
To SOLVE the problem, we "add" the ORACLE_BASE parameter to the Script :
# ----------------------------------------------------------After adding the ORACLE_BASE parameter, Hot Backup Online Oracle running normal.
# Replace /db/oracle81, below, with the Oracle home path.
# ----------------------------------------------------------
ORACLE_BASE=/rdbms/oracle9/
export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/OraHome1/
export ORACLE_HOME