急！跪求高手指点！！！INFORMIX使用NBU,ONBAR备份问题

NewLeaDeR

MASTER SERVER:Solaris8
SAN Media Server：HP-UX双机

informix有4个instance

我安装完NBU,配好设备之后，测试文件级备份没有问题。

之后安装informix agent，执行informix_config脚本，选择informix home path为/opt/informix

自动在/opt/informix/etc下的sm_versions文件中加入1|1.1.0|VERITAS-NetBackup|1|

然后Linking /opt/informix/lib/ibsad001.sl to /usr/openv/netbackup/bin/infxbsa.sl64.

然后编辑onconfig文件，修改以下参数

#TAPEDEV        /dev/null                        # Tape device path       
TAPEDEV                /dev/rmt/1m        # Tape device path       

#LTAPEDEV        /dev/null        # Log tape device path
LTAPEDEV        /opt/informix/nbu_log/logs        #Log tape device path

# Backup/Restore variables
BAR_ACT_LOG   /opt/informix/bar_act.log  # ON-Bar Log file - not in /tmp please
BAR_DEBUG_LOG /opt/informix/bar_dbug.log # ON-Bar Debug Log - not in /tmp please
BAR_MAX_BACKUP        0
BAR_RETRY        1
BAR_NB_XPORT_COUNT 10
BAR_XFER_BUF_SIZE 31
#RESTARTABLE_RESTORE        ON
#BAR_PROGRESS_FREQ        0
BAR_BSALIB_PATH /opt/informix/lib/ibsad001.sl

保存之后修改脚本进行备份，脚本如下：





#!/bin/sh
# $Revision: 1.3.10.1 $
#bcpyrght
#***************************************************************************
#* $VRTScprght: Copyright 1993 - 2004 VERITAS Software Corporation, All Rights Reserved $ *
#***************************************************************************
#ecpyrght

# Replace xxxxx below with the extention used for your onconfig file.
ONCONFIG=onconfig.omp

# Replace yyyyy below with the Informix home path.
INFORMIXDIR=/opt/informix

# Replace zzzzz below with the name of the Informix server.
INFORMIXSERVER=ompserver1

# Replace informix_etc below with the name of the NetBackup server policy
# to be used to back up the $INFORMIXDIR/etc directory.
INFX_ETC_POLICY=HBDB84_1_informix_etc


echo "Started `date`"

export ONCONFIG
echo "exported ONCONFIG"

export INFORMIXDIR
echo "exported INFORMIXDIR"

export INFORMIXSERVER
echo "exported INFORMIXSERVER"

echo "INFXBSA_SERVER = $INFXBSA_SERVER"
echo "INFXBSA_SCHEDULED = $INFXBSA_SCHEDULED"
echo "INFXBSA_USER_INITIATED = $INFXBSA_USER_INITIATED"
echo "INFXBSA_FULL = $INFXBSA_FULL"
echo "INFXBSA_INCR = $INFXBSA_INCR"
echo "INFXBSA_POLICY = $INFXBSA_POLICY"

RETURN_STATUS=0

if [ "${INFXBSA_INCR}" = "1" ]
then
#         Netbackup has started an incremental backup.
    echo "$INFORMIXDIR/bin/onbar -b -L 1 ompdb"
        $INFORMIXDIR/bin/onbar -b -L 1 ompdb
        RETURN_STATUS=$?
else

    echo "$INFORMIXDIR/bin/onbar -b -L 0 ompdb"
    $INFORMIXDIR/bin/onbar -b -L 0 ompdb
    RETURN_STATUS=$?
fi

if        [ "$RETURN_STATUS" -eq "0" ]
then

        # Initiate a backup of the directory that contains the onconfig,
        # sqlhosts, oncfg_$INFORMIXSERVER.SERVERNUM, and ixbar.SERVERNUM
        # files after doing the backup.

        echo "bpbackup -p $INFX_ETC_POLICY -w 0 $INFORMIXDIR/etc"
        /usr/openv/netbackup/bin/bpbackup -p $INFX_ETC_POLICY -w 0 $INFORMIXDIR/etc
        BPBACKUP_STATUS=$?

        if [ "$BPBACKUP_STATUS" -ne "0" ]
        then
                echo ""
                echo "bpbackup of $INFORMIXDIR/etc returned $BPBACKUP_STATUS"
        fi
fi

echo "Finished `date`"

echo "exit $RETURN_STATUS"
echo ""

exit $RETURN_STATUS




备份出错，NBU报的错是6，查看informix的bar_act.log，发现
2006-03-14 10:59:06 27499  27497 Working with veritas-netbackup as generic storage manager.
2006-03-14 10:59:06 27499  27497 Unable to open connection to database server: could not fork server connection, SQLCODE -23101.
2006-03-14 10:59:06 27499  27497 /opt/informix/bin/onbar_d complete, returning 130 (0x82)



sqlhosts文件如下，NBU备份使用的都是主机名，我使用物理节点或者虚拟节点的IP，主机名都试过，现象一样

#**************************************************************************
#
#  Licensed Material - Property Of IBM
#
#  "Restricted Materials of IBM"
#
#  IBM Informix Dynamic Server
#  (c) Copyright IBM Corporation 1996, 2004 All rights reserved.
#
#   Title:        sqlhosts.demo
#   Description:
#                Default sqlhosts file for running demos.
#
#**************************************************************************

demo_on        onipcshm        on_hostname        on_servername
wnmsserver3       onipcshm        10.120.136.6  8001
wnmsserver1       onsoctcp        10.120.136.6  8002
nmosserver3       onipcshm        10.120.136.6  8003
nmosserver1       onsoctcp        10.120.136.6  8004
eomsserver1       onipcshm        10.120.136.6  8005
eomsserver3       onsoctcp        10.120.136.6  8006
server                  onsoctcp          10.120.136.6        8007
ompserver3        onipcshm        10.120.136.6  8009
ompserver1        onsoctcp        10.120.136.6  8010





请指点到底是什么地方的问题，不胜感激！！

liaosnet

这是 VERITAS 双机。不会~~~

PS：沙发上的怎么就发现是河北移动问题哦。。沙发上的是厂家的？呵呵~

大梦

报23101的错?

你去检查一下,是不是字符集环境变量的问题!

zhan_yl

-23101  Unable to load locale categories.

An invalid locale name was supplied for the locale initialization.
The environment variable specifying the locale category has a wrong
value.

Check the value of the corresponding environment variable,
CLIENT_LOCALE or DB_LOCALE. If this error was encountered when using
the "SET COLLATION" statement, check that the value passed to the
statement is a valid locale. If this error was encountered when using
the "SET NO COLLATION" statement, check that the session's default
locale file is still available. Also check if INFORMIXDIR points to
a valid directory where IBM Informix products are installed.  

If a client application receives this error when it requests a database
server connection, check that the client and database locales are
compatible. They are compatible if a valid locale exists on the server
computer with the name lg_tr.codeset@mod, where lg_tr (language and
territory) and mod (locale modifier) are from the CLIENT_LOCALE and
codeset is from the database locale (from the DB_LOCALE, if it is set,
or as stored in the database).