免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 2620 | 回复: 2
打印 上一主题 下一主题

[Veritas NBU] NBU windows 2003,sybase数据库配置问题 [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2013-09-05 22:15 |只看该作者 |倒序浏览
各位高手,我现在装sybase的系统和nbu软件的系统都是win2003,想请问在sybase客户端都需要做什么设置?找了好久了,都没有成功,还请大家帮帮忙哦
我在nbu服务器(名称sybase-b)端建立了本地基础磁盘作为存储单元,然后建立了策略sybase_p、建立了sybase_s备份时间日程,然后再客户端(名称sybase)的sybase里建立了脚本文件如下:
我的数据库是12.5版本,下面红色部分是我改动的内容,但是就是不成功,显示本分完成,但是没有生成文件,不知道什么原因,

@REM $Revision: 1.4 $

@REM bcpyrght
@REM **************************************************************************
@REM * $VRTScprght: Copyright 1993 - 2011 Symantec Corporation, All Rights Reserved $ *
@REM **************************************************************************
@REM ecpyrght

@setlocal
@echo off

@REM **************************************************************************
@REM Replace C:\Sybase below with your actual Sybase home directory
@REM **************************************************************************
@set SYBASE=C:\Sybase

@REM **************************************************************************
@REM Replace Sybase below with the actual name of your SQL Server
@REM **************************************************************************
@set SYBSERVER=SYBASE

@REM **************************************************************************
@REM Replace SYB_DB below with the actual name of your Sybase database
@REM **************************************************************************
@set DATABASE_NAME=TEST_JXC
if "%SYBASE_OCS%" == "" goto notsyb12
@REM ********* Sybase 12.0 or later ***********
@set OCS_QUAL=\%SYBASE_OCS%
goto cont1

:notsyb12
@REM ********* Sybase 11.9.2 or earlier **********
@set OCS_QUAL=

:cont1

@REM **************************************************************************
@REM These environment variables are set by NetBackup.  
@REM **************************************************************************
@echo SYBACKUP_SERVER = %SYBACKUP_SERVER%
@echo SYBACKUP_POLICY = %SYBACKUP_POLICY%
@echo SYBACKUP_SCHED = %SYBACKUP_SCHED%
@echo SYBACKUP_CLIENT = %SYBACKUP_CLIENT%
@echo SYBACKUP_SCHEDULED = %SYBACKUP_SCHEDULED%
@echo SYBACKUP_USER_INITIATED = %SYBACKUP_USER_INITIATED%

@REM **************************************************************************
@REM Replace "database_dump" below with your actual NetBackup schedule name
@REM which is used for a full backup of the Sybase database.
@REM **************************************************************************
if  "%SYBACKUP_SCHED%" == "sybase_s" goto dbdump

@REM *********** NetBackup has started a "transaction_dump" backup ***********
set DUMP_TYPE=TRANSACTION
       goto entercmd

:dbdump
@REM *********** NetBackup has started a "database_dump" backup ***********
set DUMP_TYPE=DATABASE

:entercmd

@REM **************************************************************************
@REM Replace "Default-Application-Backup" below with your actual NetBackup
@REM Application Backup type schedule name for the Sybase database.
@REM **************************************************************************
@echo dump %DUMP_TYPE% %DATABASE_NAME% to "sybackup::-SERV %SYBACKUP_SERVER% -CLIENT %SYBACKUP_CLIENT% -POL %SYBACKUP_POLICY% -SCHED Default-Application-Backup -STAT_FILE %STATUS_FILE%" > .\syb_%DATABASE_NAME%_dump

@REM **************************************************************************
@REM Remove the REM from the beginning of the line below if you are going to
@REM use multiple stripes for the backup. Repeat this line for each stripe.
@REM Replace "Default-Application-Backup" below with your actual NetBackup
@REM Application Backup type schedule name for the Sybase database.
@REM **************************************************************************
@REM echo stripe on "sybackup::-SERV %SYBACKUP_SERVER% -CLIENT %SYBACKUP_CLIENT% -POL %SYBACKUP_POLICY% -SCHED Default-Application-Backup -STAT_FILE %STATUS_FILE%" >> .\syb_%DATABASE_NAME%_dump

@echo go >> .\syb_%DATABASE_NAME%_dump

@REM **************************************************************************
@REM Log the isql command. This line may appear in NetBackup log files.
@REM Do NOT replace "xxxxxxxx" with a user id or password.  
@REM **************************************************************************
set PRT_LINE=%SYBASE%%OCS_QUAL%\bin\isql -Uxxxxxxxx -Pxxxxxxxx -I%SYBASE%\ini\sql.ini -S%SYBSERVER% -i .\syb_%DATABASE_NAME%_dump
@echo %PRT_LINE%

@REM **************************************************************************
@REM Replace "sa" with your Sybase server Administrator's login name.
@REM Replace "manager" with your Sybase server Administrator's password.
@REM **************************************************************************

set CMD_LINE=%SYBASE%%OCS_QUAL%\bin\isql -Usa -P12345678 -I%SYBASE%\ini\sql.ini -S%SYBSERVER% -i .\syb_%DATABASE_NAME%_dump

%CMD_LINE%
@set RSTAT=%ERRORLEVEL%
@set STATUS_MESSAGE=completed successfully

@REM **************************************************************************
@REM This script will return an error status back to the NetBackup client if
@REM the isql command fails.
@REM **************************************************************************

if %RSTAT% NEQ 0 set STATUS_MESSGAGE=failed
echo Execution of isql command %STATUS_MESSAGE% - exiting

if exist "%STATUS_FILE%" echo %RSTAT% > "%STATUS_FILE%"

@echo on
@endlocal

不知道还需要修改什么部分,还请各位给指点一下?兄弟感激不尽!

论坛徽章:
0
2 [报告]
发表于 2013-09-06 13:36 |只看该作者
哪位高手给指点看看啊,?

论坛徽章:
0
3 [报告]
发表于 2013-09-10 10:34 |只看该作者
没有人路过吗。我自己顶一下。
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP