关于NETWORKer备份数据库请教？

huashan

我在试用ＮＥＴＷＯＲＫＥＲ备份ＯＲＡＣＬＥ　９Ｉ数据库
目前我的环境是　ＲＥＤＨＡＴ　ＡＳ　３．Ｏ　安装数据库ＯＲＡＣＬＥ９２４
ＮＥＴＷＯＲＫＥＲ　服务　想利用ＮＥＲＷＯＲＫＥＲ备份数据库，ＲＭＡＮ数据库在另一台Ｗ２Ｋ的机器上
ＮＥＴＷＯＲＫＥＲ　ＭＯＤＵＬＥ　ＦＯＲ　ＯＲＡＣＬＥ　３．５安装在ＬＩＮＵＸ　服务器上下面是我的脚本

connect catalog rman/rman@rman
connect target sys/sys
run {
   allocate channel c1 type 'sbt_tape'
    parms='ENV=(NSR_SERVER=linux,NSR_CLIENT=linux,NSR_DATA_VOLUME_POOL=zxy)';
   backup full database include current controlfile filesperset 3
      (database format '/oracle/bk/FULL_%u_%s_%p');
   release channel c1;
   }
~
这个脚本在手工测试时备份成功，数据写到相应的池中
但在做自动备份是出现错误
这是   msglog.log的提示  


Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

RMAN>; connect catalog rman/rman@rman
2>; connect target sys/sys
3>; run {
4>;    allocate channel c1 type 'sbt_tape'
5>;     parms='ENV=(NSR_SERVER=linux,NSR_CLIENT=linux,NSR_DATA_VOLUME_POOL=zxy,
6>; NSR_SERVER=linux,
7>; NSR_GROUP=test,
8>; NSR_SAVESET_NAME=/oracle/script/backfullora)';
9>;    backup full database include current controlfile filesperset 3
10>;       (database format '/oracle/bk/FULL_%u_%s_%p');
11>;    release channel c1;
12>;    }
13>;
connected to recovery catalog database

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-07217: sltln: environment variable cannot be evaluated.

Recovery Manager complete.



请朋友们帮忙分析分析，另外我的同事说，就我这样的环境ＮＥＴＷＯＲＫer的客户端，和ＲＭＡＮ目录库应该在同一台机器上，是这样么，我认目录只记录备份信息，不在一台机器上也行，就我这样的环境是这样么

sonorous

我也碰到过这样的问题，不过是在SUN的机器上，没有用LGTO，只是用RMAN备份数据库到硬盘上。

huashan

老大们在看看这是 nsrnmostart.log的提示

(5143) Entering Function nwora_log_calling_args
(5143) argc = 16
(5143) Calling Summary
(5143) argv[ 0] = nsrnmostart
(5143) argv[ 1] = -s
(5143) argv[ 2] = linux
(5143) argv[ 3] = -g
(5143) argv[ 4] = Default
(5143) argv[ 5] = -LL
(5143) argv[ 6] = -m
(5143) argv[ 7] = linux
(5143) argv[ 8] = -l
(5143) argv[ 9] = full
(5143) argv[10] = -q
(5143) argv[11] = -W
(5143) argv[12] = 78
(5143) argv[13] = -N
(5143) argv[14] = /oracle/script/backfullora
(5143) argv[15] = /oracle/script/backfullora
(5143) Environment Read by nsrnmostart
(5143) ORACLE_HOME          = /opt/oracle/product/9.2.4
(5143) PATH                 = opt/oracle/product/9.2.4/bin:/usr/sbin:/nsr/bin
(5143) NSR_RMAN_ARGUMENTS   = msglog '/nsr/applogs/msglog.log' append
(5143) Variables defined but not processed by nsrnmostart to follow.
(5143) End of variables defined but not processed by nsrnmostart.
(5143) Leaving Function nwora_log_calling_args

(5143) Entering Function nwora_scan_rman_script
(5143) Checking rman script /oracle/script/backfullora for validity.
(5143) found connect target: connect target sys/***
(5143) found allocate channel:    allocate channel c1 type 'sbt_tape'
(5143) NSR_SERVER=linux
(5143) NSR_DATA_VOLUME_POOL=zxy
(5143) NSR_CLIENT=linux
(5143) Warning: connect rcvcat not found in rman script.
(5143) Completed checking of rman script.
(5143) Leaving Function nwora_scan_rman_script

(5143) Entering Function nwora_nsrnmostart_rman
(5143) Looking for rman in
(5143) /opt/oracle/product/9.2.4/bin/rman
(5143) stat = 0    stb.st_size = 8081893
(5143) nwora_find_rman_version: file /oracle/script/tmp4qDv1y created
(5143) nwora_find_rman_version: Cannot open pipe
(5143) nwora_delete_file: File /oracle/script/tmp4qDv1y deleted
(5143) savegrp information added to 1 channels
(5143) exepath = /opt/oracle/product/9.2.4/bin/rman
(5143) cmd_args = msglog '/nsr/applogs/msglog.log' append cmdfile '/oracle/scrip t/nmosbtpFddD'
(5143) rman_script = /oracle/script/nmosbtpFddD
(5143) saveset_name = /oracle/script/backfullora
(5143) Launching backup process
(5143) Backup process failed returning 1
(5143) rman_ret = 1
(5143) nwora_delete_file: File /oracle/script/nmosbtpFddD deleted
(5143) Leaving Function nwora_nsrnmostart_rman

楼上的兄弟,你是怎么处理的,感觉是与环境变量有关

sonorous

我已经试过了，只要设一个环境变量就好了TNS_ADMIN，指向你放网络配置文件的目录，通常是$ORACLE_HOME/network/admin

huashan

谢谢两位老大
根据两位老大的提示，我成功了
TNS_ADMIN如果安装配置在缺省的位置,是不用在NSRNMO.SH中设置的
不成功的关键原因是因为在连接TARGET 是没有加TNS连接串,我认为数据库可NETWORKER SERVER 是在一台机器上,所以我没加,但为什么要加呢?
再和一不老大描述一下,
我是用两台机器做的测试环境
  LINUX服务器 : REDHAT AS 3.0  (2.49)  ,ORACLE 9.2.0.4
                         NETWORKER 7.1    ,  NMO3.5
   WIN2000服务器：ＷＩＮ２０００　ＳＥＲＶＥＲ
　　　　　　　　　　ＯＲＡＣＬＥ　９．２．０
　　　　　　　　　　ＮＥＴＷＯＲＫＥＲ　７．１　
　回头有时间的话要试２０００上的数据库向ＬＩＮＵＸ上备份，有问题还要向两位请教

huashan

谢谢,我上午在不成功的时候,还在想,是不是要在NSRNMO.SH中加入SU到ORACLE用户的脚本呢

4nai

parms后面没有“=”号