NetBackup 7.0 with Oracle 11g r1 on HP-UX issue
Now, I on the way to configure backup Oracle on HP-UX server.
I had NetBackup 7.0 master server on Windows 2003 server R2 (Service pack 2). --> cisrpt is master server
Oracle 11g R1 (11.1.6) run on cluster with HP Service Guard. (HP-UX v11.3)
node1: cisdb
node2: cisapp
virtual-name: pwacisdb
I install netbackup client on both node on cluster and run oracle_link command on both node:
oracle@cisdb:/u01/app/oracle/product/11.1.0/db_1/lib> ls -l libobk.*
lrwxr-xr-x 1 oracle oinstall 34 May 9 13:56 libobk.so -> /usr/openv/netbackup/bin/libobk.so
oracle@cisapp:/u01/app/oracle/product/11.1.0/db_1/lib> ls -l libobk.*
lrwxr-xr-x 1 oracle oinstall 34 May 9 14:23 libobk.so -> /usr/openv/netbackup/bin/libobk.so
I had configure netbackup to backup Oracle but had error occured.
My Backup Script:
---------------------------------------------------------------------------- BACKUP SCRIPT -----------------------------------------------------------------------------
RUN {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
SEND 'NB_ORA_CLIENT=pwacisdb,NB_ORA_SERV=cisrpt,NB_ORA_POLICY=PWACIS_ORACLE';
BACKUP
$BACKUP_TYPE
SKIP INACCESSIBLE
TAG hot_db_bk_level0
FILESPERSET 5
# recommended format
FORMAT 'bk_%s_%p_%t'
DATABASE;
sql 'alter system archive log current';
RELEASE CHANNEL ch00;
# backup all archive logs
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
SEND 'NB_ORA_CLIENT=pwacisdb,NB_ORA_SERV=cisrpt,NB_ORA_POLICY=PWACIS_ORACLE';
BACKUP
filesperset 20
FORMAT 'al_%s_%p_%t'
ARCHIVELOG ALL DELETE INPUT;
RELEASE CHANNEL ch00;
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
SEND 'NB_ORA_CLIENT=pwacisdb,NB_ORA_SERV=cisrpt,NB_ORA_POLICY=PWACIS_ORACLE';
BACKUP
# recommended format
FORMAT 'cntrl_%s_%p_%t'
CURRENT CONTROLFILE;
RELEASE CHANNEL ch00;
}
--------------------------------------------------------------------------------------------------------------------------------------------------------------
Error log from .out file
---------------------------- OUT FILE --------------------------------------------------------------------------------------------------------------------
Script /usr/openv/netbackup/pwacis_hot_database_backup.sh
==== started on Mon, May 10, 2010 10:50:58 AM ====
RMAN: /u01/app/oracle/product/11.1.0/db_1/bin/rman
ORACLE_SID: pwacis
ORACLE_USER: oracle
ORACLE_HOME: /u01/app/oracle/product/11.1.0/db_1
NB_ORA_FULL: 1
NB_ORA_INCR: 0
NB_ORA_CINC: 0
NB_ORA_SERV: cisrpt
NB_ORA_POLICY: PWACIS_ORACLE
Full backup requested
(c)Copyright 1983-2006 Hewlett-Packard Development Company, L.P.
(c)Copyright 1979, 1980, 1983, 1985-1993 The Regents of the Univ. of California
(c)Copyright 1980, 1984, 1986 Novell, Inc.
(c)Copyright 1986-2000 Sun Microsystems, Inc.
(c)Copyright 1985, 1986, 1988 Massachusetts Institute of Technology
(c)Copyright 1989-1993 The Open Software Foundation, Inc.
(c)Copyright 1990 Motorola, Inc.
(c)Copyright 1990, 1991, 1992 Cornell University
(c)Copyright 1989-1991 The University of Maryland
(c)Copyright 1988 Carnegie Mellon University
(c)Copyright 1991-2006 Mentat Inc.
(c)Copyright 1996 Morning Star Technologies, Inc.
(c)Copyright 1996 Progressive Systems, Inc.
Confidential computer software. Valid license from HP required for
possession, use or copying. Consistent with FAR 12.211 and 12.212,
Commercial Computer Software, Computer Software Documentation, and
Technical Data for Commercial Items are licensed to the U.S. Government
under vendor's standard commercial license.
"This system is a node in a high availability cluster.
Halting this system may cause applications and services to
start up on another node in the cluster."
You have mail.
[3g
H H H H H H H H H
Recovery Manager: Release 11.1.0.6.0 - Production on Mon May 10 10:50:58 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: PWACIS (DBID=265035905)
using target database control file instead of recovery catalog
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41>
allocated channel: ch00
channel ch00: SID=290 device type=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle - Release 7.0 (2010010419)
sent command to channel: ch00
Starting backup at 10-MAY-10
channel ch00: starting incremental level 0 datafile backup set
channel ch00: specifying datafile(s) in backup set
input datafile file number=00002 name=/u03/oradata/pwacis/sysaux01.dbf
input datafile file number=00005 name=/u03/oradata/pwacis/example01.dbf
input datafile file number=00007 name=/u03/oradata/pwacis/FLOW_1.dbf
input datafile file number=00004 name=/u03/oradata/pwacis/users01.dbf
input datafile file number=00003 name=/u03/oradata/pwacis/undotbs01.dbf
channel ch00: starting piece 1 at 10-MAY-10
released channel: ch00
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch00 channel at 05/10/2010 10:51:22
ORA-19506: failed to create sequential file, name="bk_205_1_718627860", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
VxBSAValidateFeatureId: Failed with error:
Server Status: unexpected message received
RMAN> RMAN>
Recovery Manager complete.
logout
Script /usr/openv/netbackup/pwacis_hot_database_backup.sh
==== ended in error on Mon, May 10, 2010 10:51:22 AM ====
--------------------------------------------------------------------------------------------------------------------------------------------------------------
and finally dbclient log:
------------------------------------ DBCLIENT ---------------------------------------------------------------------------------------------------------
10:51:00.199 [9479] <8> xbsa_GetEnv: WRN - NBBSA_SCHEDULE not found in environment block
10:51:00.200 [9479] <2> int_GetOracleVersion: INF - ORACLE_HOME= </u01/app/oracle/product/11.1.0/db_1>
10:51:00.200 [9479] <2> int_LogSystemInfo: INF -
Veritas NetBackup for Oracle - Release 7.0 (2010010419)
System name: HP-UX
Node name: cisdb
Release: B.11.31
Version: U
Machine: ia64
User name: oracle
Client Host: cisdb
10:51:00.200 [9479] <2> int_GetMMInfo: INF - Initialized Signal
10:51:00.200 [9479] <2> int_GetMMInfo: INF - support for Proxy Copy enabled
10:51:00.536 [9479] <4> int_ProcessCommandString: INF - cmd_key=<NB_ORA_CLIENT> cmd_val=<pwacisdb>
10:51:00.536 [9479] <2> int_ProcessCommand: INF - Client <pwacisdb> will be used for this API session.
10:51:00.536 [9479] <4> int_ProcessCommandString: INF - cmd_key=<NB_ORA_SERV> cmd_val=<cisrpt>
10:51:00.536 [9479] <2> int_ProcessCommand: INF - Server <cisrpt> will be used for this API session.
10:51:00.536 [9479] <4> int_ProcessCommandString: INF - cmd_key=<NB_ORA_POLICY> cmd_val=<PWACIS_ORACLE>
10:51:00.536 [9479] <2> int_ProcessCommand: INF - Policy <PWACIS_ORACLE> will be used for this API session.
10:51:07.870 [9479] <2> vnet_vnetd_service_socket: ../../libvlibs/vnet_vnetd.c.2053: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
10:51:07.870 [9479] <2> vnet_vnetd_service_socket: ../../libvlibs/vnet_vnetd.c.2068: service: bprd
10:51:08.002 [9479] <2> logconnections: BPRD CONNECT FROM 192.168.247.41.55498 TO 192.168.247.43.13724
10:51:12.596 [9479] <2> bprd_get_features: Cannot parse product and feature IDs from EXIT STATUS 23
10:51:12.640 [9479] <2> vnet_vnetd_service_socket: ../../libvlibs/vnet_vnetd.c.2053: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
10:51:12.640 [9479] <2> vnet_vnetd_service_socket: ../../libvlibs/vnet_vnetd.c.2068: service: bprd
10:51:12.815 [9479] <2> logconnections: BPRD CONNECT FROM 192.168.247.41.55500 TO 192.168.247.43.13724
10:51:17.409 [9479] <2> bprd_get_features: Cannot parse product and feature IDs from EXIT STATUS 23
10:51:17.452 [9479] <2> vnet_vnetd_service_socket: ../../libvlibs/vnet_vnetd.c.2053: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
10:51:17.453 [9479] <2> vnet_vnetd_service_socket: ../../libvlibs/vnet_vnetd.c.2068: service: bprd
10:51:17.628 [9479] <2> logconnections: BPRD CONNECT FROM 192.168.247.41.55503 TO 192.168.247.43.13724
10:51:22.222 [9479] <2> bprd_get_features: Cannot parse product and feature IDs from EXIT STATUS 23
10:51:22.222 [9479] <16> bsa_checkFeatureId: unable to check if feature <36> is licensed
10:51:22.222 [9479] <16> bsa_checkFeatureId: Server exit status = 43: unexpected message received
10:51:22.222 [9479] <16> xbsa_ValidateFeatureId: ERR - VxBSAValidateFeatureId: Failed with error:
Server Status: unexpected message received
10:51:22.912 [9479] <4> sbtend: INF - --- END of SESSION ---
--------------------------------------------------------------------------------------------------------------------------------------------------------------
I don't sure about bprd_get_featureId: error
Please sugguest me to finished this issue.
I had NetBackup 7.0 master server on Windows 2003 server R2 (Service pack 2). --> cisrpt is master server
Oracle 11g R1 (11.1.6) run on cluster with HP Service Guard. (HP-UX v11.3)
node1: cisdb
node2: cisapp
virtual-name: pwacisdb
I install netbackup client on both node on cluster and run oracle_link command on both node:
oracle@cisdb:/u01/app/oracle/product/11.1.0/db_1/lib> ls -l libobk.*
lrwxr-xr-x 1 oracle oinstall 34 May 9 13:56 libobk.so -> /usr/openv/netbackup/bin/libobk.so
oracle@cisapp:/u01/app/oracle/product/11.1.0/db_1/lib> ls -l libobk.*
lrwxr-xr-x 1 oracle oinstall 34 May 9 14:23 libobk.so -> /usr/openv/netbackup/bin/libobk.so
I had configure netbackup to backup Oracle but had error occured.
My Backup Script:
---------------------------------------------------------------------------- BACKUP SCRIPT -----------------------------------------------------------------------------
RUN {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
SEND 'NB_ORA_CLIENT=pwacisdb,NB_ORA_SERV=cisrpt,NB_ORA_POLICY=PWACIS_ORACLE';
BACKUP
$BACKUP_TYPE
SKIP INACCESSIBLE
TAG hot_db_bk_level0
FILESPERSET 5
# recommended format
FORMAT 'bk_%s_%p_%t'
DATABASE;
sql 'alter system archive log current';
RELEASE CHANNEL ch00;
# backup all archive logs
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
SEND 'NB_ORA_CLIENT=pwacisdb,NB_ORA_SERV=cisrpt,NB_ORA_POLICY=PWACIS_ORACLE';
BACKUP
filesperset 20
FORMAT 'al_%s_%p_%t'
ARCHIVELOG ALL DELETE INPUT;
RELEASE CHANNEL ch00;
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
SEND 'NB_ORA_CLIENT=pwacisdb,NB_ORA_SERV=cisrpt,NB_ORA_POLICY=PWACIS_ORACLE';
BACKUP
# recommended format
FORMAT 'cntrl_%s_%p_%t'
CURRENT CONTROLFILE;
RELEASE CHANNEL ch00;
}
--------------------------------------------------------------------------------------------------------------------------------------------------------------
Error log from .out file
---------------------------- OUT FILE --------------------------------------------------------------------------------------------------------------------
Script /usr/openv/netbackup/pwacis_hot_database_backup.sh
==== started on Mon, May 10, 2010 10:50:58 AM ====
RMAN: /u01/app/oracle/product/11.1.0/db_1/bin/rman
ORACLE_SID: pwacis
ORACLE_USER: oracle
ORACLE_HOME: /u01/app/oracle/product/11.1.0/db_1
NB_ORA_FULL: 1
NB_ORA_INCR: 0
NB_ORA_CINC: 0
NB_ORA_SERV: cisrpt
NB_ORA_POLICY: PWACIS_ORACLE
Full backup requested
(c)Copyright 1983-2006 Hewlett-Packard Development Company, L.P.
(c)Copyright 1979, 1980, 1983, 1985-1993 The Regents of the Univ. of California
(c)Copyright 1980, 1984, 1986 Novell, Inc.
(c)Copyright 1986-2000 Sun Microsystems, Inc.
(c)Copyright 1985, 1986, 1988 Massachusetts Institute of Technology
(c)Copyright 1989-1993 The Open Software Foundation, Inc.
(c)Copyright 1990 Motorola, Inc.
(c)Copyright 1990, 1991, 1992 Cornell University
(c)Copyright 1989-1991 The University of Maryland
(c)Copyright 1988 Carnegie Mellon University
(c)Copyright 1991-2006 Mentat Inc.
(c)Copyright 1996 Morning Star Technologies, Inc.
(c)Copyright 1996 Progressive Systems, Inc.
Confidential computer software. Valid license from HP required for
possession, use or copying. Consistent with FAR 12.211 and 12.212,
Commercial Computer Software, Computer Software Documentation, and
Technical Data for Commercial Items are licensed to the U.S. Government
under vendor's standard commercial license.
"This system is a node in a high availability cluster.
Halting this system may cause applications and services to
start up on another node in the cluster."
You have mail.
[3g
H H H H H H H H H
Recovery Manager: Release 11.1.0.6.0 - Production on Mon May 10 10:50:58 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: PWACIS (DBID=265035905)
using target database control file instead of recovery catalog
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41>
allocated channel: ch00
channel ch00: SID=290 device type=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle - Release 7.0 (2010010419)
sent command to channel: ch00
Starting backup at 10-MAY-10
channel ch00: starting incremental level 0 datafile backup set
channel ch00: specifying datafile(s) in backup set
input datafile file number=00002 name=/u03/oradata/pwacis/sysaux01.dbf
input datafile file number=00005 name=/u03/oradata/pwacis/example01.dbf
input datafile file number=00007 name=/u03/oradata/pwacis/FLOW_1.dbf
input datafile file number=00004 name=/u03/oradata/pwacis/users01.dbf
input datafile file number=00003 name=/u03/oradata/pwacis/undotbs01.dbf
channel ch00: starting piece 1 at 10-MAY-10
released channel: ch00
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch00 channel at 05/10/2010 10:51:22
ORA-19506: failed to create sequential file, name="bk_205_1_718627860", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
VxBSAValidateFeatureId: Failed with error:
Server Status: unexpected message received
RMAN> RMAN>
Recovery Manager complete.
logout
Script /usr/openv/netbackup/pwacis_hot_database_backup.sh
==== ended in error on Mon, May 10, 2010 10:51:22 AM ====
--------------------------------------------------------------------------------------------------------------------------------------------------------------
and finally dbclient log:
------------------------------------ DBCLIENT ---------------------------------------------------------------------------------------------------------
10:51:00.199 [9479] <8> xbsa_GetEnv: WRN - NBBSA_SCHEDULE not found in environment block
10:51:00.200 [9479] <2> int_GetOracleVersion: INF - ORACLE_HOME= </u01/app/oracle/product/11.1.0/db_1>
10:51:00.200 [9479] <2> int_LogSystemInfo: INF -
Veritas NetBackup for Oracle - Release 7.0 (2010010419)
System name: HP-UX
Node name: cisdb
Release: B.11.31
Version: U
Machine: ia64
User name: oracle
Client Host: cisdb
10:51:00.200 [9479] <2> int_GetMMInfo: INF - Initialized Signal
10:51:00.200 [9479] <2> int_GetMMInfo: INF - support for Proxy Copy enabled
10:51:00.536 [9479] <4> int_ProcessCommandString: INF - cmd_key=<NB_ORA_CLIENT> cmd_val=<pwacisdb>
10:51:00.536 [9479] <2> int_ProcessCommand: INF - Client <pwacisdb> will be used for this API session.
10:51:00.536 [9479] <4> int_ProcessCommandString: INF - cmd_key=<NB_ORA_SERV> cmd_val=<cisrpt>
10:51:00.536 [9479] <2> int_ProcessCommand: INF - Server <cisrpt> will be used for this API session.
10:51:00.536 [9479] <4> int_ProcessCommandString: INF - cmd_key=<NB_ORA_POLICY> cmd_val=<PWACIS_ORACLE>
10:51:00.536 [9479] <2> int_ProcessCommand: INF - Policy <PWACIS_ORACLE> will be used for this API session.
10:51:07.870 [9479] <2> vnet_vnetd_service_socket: ../../libvlibs/vnet_vnetd.c.2053: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
10:51:07.870 [9479] <2> vnet_vnetd_service_socket: ../../libvlibs/vnet_vnetd.c.2068: service: bprd
10:51:08.002 [9479] <2> logconnections: BPRD CONNECT FROM 192.168.247.41.55498 TO 192.168.247.43.13724
10:51:12.596 [9479] <2> bprd_get_features: Cannot parse product and feature IDs from EXIT STATUS 23
10:51:12.640 [9479] <2> vnet_vnetd_service_socket: ../../libvlibs/vnet_vnetd.c.2053: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
10:51:12.640 [9479] <2> vnet_vnetd_service_socket: ../../libvlibs/vnet_vnetd.c.2068: service: bprd
10:51:12.815 [9479] <2> logconnections: BPRD CONNECT FROM 192.168.247.41.55500 TO 192.168.247.43.13724
10:51:17.409 [9479] <2> bprd_get_features: Cannot parse product and feature IDs from EXIT STATUS 23
10:51:17.452 [9479] <2> vnet_vnetd_service_socket: ../../libvlibs/vnet_vnetd.c.2053: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
10:51:17.453 [9479] <2> vnet_vnetd_service_socket: ../../libvlibs/vnet_vnetd.c.2068: service: bprd
10:51:17.628 [9479] <2> logconnections: BPRD CONNECT FROM 192.168.247.41.55503 TO 192.168.247.43.13724
10:51:22.222 [9479] <2> bprd_get_features: Cannot parse product and feature IDs from EXIT STATUS 23
10:51:22.222 [9479] <16> bsa_checkFeatureId: unable to check if feature <36> is licensed
10:51:22.222 [9479] <16> bsa_checkFeatureId: Server exit status = 43: unexpected message received
10:51:22.222 [9479] <16> xbsa_ValidateFeatureId: ERR - VxBSAValidateFeatureId: Failed with error:
Server Status: unexpected message received
10:51:22.912 [9479] <4> sbtend: INF - --- END of SESSION ---
--------------------------------------------------------------------------------------------------------------------------------------------------------------
I don't sure about bprd_get_featureId: error
Please sugguest me to finished this issue.
Ah... I know my issue...
For oracle backup service, netbackup had check 3 things for online backup.
1. Policy --> use virtual name.
2. bp.conf --> use virtual name (or use virtual name to install)
3. send parameter on rman backup script.
and then backup, I use this solution and it can backup successful.
Thanks all.
