legato 备份oracle请教各位大虾
msn:mlsm@eyou.com,Email:kissma@gmail.com
环境:
windows2000 server+oracle9i+legato networker 7.2
networker 已经配置好了,测试备份普通文件没有问题,oracle通过rman 手工备份也没有问题,可是用自动策略备份就不行,大家帮忙看看,分析分析会是那里出了问题呀
rman备份脚本保存到:c:\a.txt文件了)
connect target sys/oracle@ora22;
connect catalog rman/rman@rcat;
run {
allocate channel t1 type 'SBT_TPAE'
parms 'ENV=(NSR_SERVER=SERVER2000,
NSR_DATA_VOLUME_POOL=Default)';
allocate channel t2 type 'SBT_TPAE';
parms 'ENV=(NSR_SERVER=server2000,
NSR_DATA_VOLUME_POOL=Defaul)';
backup full filesperset 4
format '/full_%s_%p_%u/' (database include current controlfile);
release channel t1;
release channel t2;
}
下面是备份的日志,
二月 17 11:47:48 server2000: * cluster2:C:\a.txt savegrp: suppressed 256 lines of output -
二月 17 11:47:48 server2000: check daemon.log for details.
二月 17 11:47:48 server2000: * cluster2:C:\a.txt
二月 17 11:47:48 server2000: * cluster2:C:\a.txt E:\>REM Default value: NONE
二月 17 11:47:48 server2000: * cluster2:C:\a.txt
二月 17 11:47:48 server2000: * cluster2:C:\a.txt E:\>REM Description: This variable needs to be set if Oracle Net configuration
二月 17 11:47:48 server2000: * cluster2:C:\a.txt
二月 17 11:47:48 server2000: * cluster2:C:\a.txt E:\>REM files are not located in default locations.
二月 17 11:47:48 server2000: * cluster2:C:\a.txt
二月 17 11:47:48 server2000: * cluster2:C:\a.txt E:\>REM
二月 17 11:47:48 server2000: * cluster2:C:\a.txt
二月 17 11:47:48 server2000: * cluster2:C:\a.txt E:\>SET TNS_ADMIN=C:\oracle\ora92\network\admin
二月 17 11:47:48 server2000: * cluster2:C:\a.txt
二月 17 11:47:48 server2000: * cluster2:C:\a.txt E:\>REM
二月 17 11:47:48 server2000: * cluster2:C:\a.txt
二月 17 11:47:48 server2000: * cluster2:C:\a.txt E:\>REM Execute the backup command
二月 17 11:47:48 server2000: * cluster2:C:\a.txt
二月 17 11:47:48 server2000: * cluster2:C:\a.txt E:\>REM
二月 17 11:47:48 server2000: * cluster2:C:\a.txt
二月 17 11:47:48 server2000: * cluster2:C:\a.txt E:\>SET args=-s server2000 -g Default -LL -m cluster2 -l full -q -W 78 -N "C:\a.txt" "C:\a.txt"
二月 17 11:47:48 server2000: * cluster2:C:\a.txt
二月 17 11:47:48 server2000: * cluster2:C:\a.txt E:\>nsrnmostart -s server2000 -g Default -LL -m cluster2 -l full -q -W 78 -N "C:\a.txt" "C:\a.txt"
二月 17 11:47:48 server2000: * cluster2:C:\a.txt
二月 17 11:47:48 server2000: * cluster2:C:\a.txt RMAN script execution is not successful. RMAN exited with return code '3'.
二月 17 11:47:48 server2000: --- Successful Save Sets ---
二月 17 11:47:48 server2000: server2000: index:cluster2 level=9, 14 KB 00:00:04 10 files
二月 17 11:47:48 server2000: server2000: bootstrap level=full, 82 KB 00:00:02 95 files
二月 17 11:47:48 server2000: * server2000:bootstrap nsrlpr: Either a printer isn't defined for printing the Bootstrap for this savegroup,
二月 17 11:47:48 server2000: * server2000:bootstrap or the '-PPRINTER' part of the notification resource is absent.
二月 17 11:47:48 server2000: * server2000:bootstrap Please correct as appropriate.
二月 17 11:47:48 server2000: * server2000:bootstrap printing bootstrap information failed (reproduced below).
二月 17 11:47:48 server2000: * server2000:bootstrap
二月 17 11:47:48 server2000: * server2000:bootstrap
二月 17 11:47:48 server2000: * server2000:bootstrap 二月 17 11:47 2006 server2000's bootstrap information Page 1
二月 17 11:47:48 server2000: * server2000:bootstrap
二月 17 11:47:48 server2000: * server2000:bootstrap date time level ssid file record volume
二月 17 11:47:48 server2000: * server2000:bootstrap 2006-02-15 10:41:12 full 4226979016 14 0 server2000.001
二月 17 11:47:48 server2000: * server2000:bootstrap 2006-02-15 10:44:39 full 4193424791 16 0 server2000.001
二月 17 11:47:48 server2000: * server2000:bootstrap 2006-02-15 14:13:19 full 4159882879 18 0 server2000.001
二月 17 11:47:48 server2000: * server2000:bootstrap 2006-02-15 14:32:07 full 4126329575 20 0 server2000.001
二月 17 11:47:48 server2000: * server2000:bootstrap 2006-02-15 14:37:23 full 4092775459 22 0 server2000.001
二月 17 11:47:48 server2000: * server2000:bootstrap 2006-02-15 14:38:39 full 4059221103 24 0 server2000.001
二月 17 11:47:48 server2000: * server2000:bootstrap 2006-02-17 10:11:02 full 4260704438 4260704438 0 server2000.002
二月 17 11:47:48 server2000: * server2000:bootstrap 2006-02-17 10:33:23 full 4227151347 4227151347 0 server2000.002
二月 17 11:47:48 server2000: * server2000:bootstrap 2006-02-17 10:51:39 full 4193598011 4193598011 0 server2000.002
二月 17 11:47:48 server2000: * server2000:bootstrap 2006-02-17 11:47:45 full 4109715297 4109715297 0 server2000.002
二月 17 11:54:28 server2000: NetWorker savegroup: (alert) Default completed, total 2 client(s), 0 Hostname(s) Unresolved, 1 Failed, 1 Succeeded. (cluster2 Failed)
二月 17 11:54:28 server2000: Start time: Fri Feb 17 11:53:28 2006
二月 17 11:54:28 server2000: End time: Fri Feb 17 11:54:28 2006
二月 17 11:54:28 server2000: --- Unsuccessful Save Sets ---
二月 17 11:54:28 server2000: * cluster2:C:\a.txt savegrp: suppressed 254 lines of output -
二月 17 11:54:28 server2000: check daemon.log for details.
二月 17 11:54:28 server2000: * cluster2:C:\a.txt
二月 17 11:54:28 server2000: * cluster2:C:\a.txt E:\>REM Default value: NONE
二月 17 11:54:28 server2000: * cluster2:C:\a.txt
二月 17 11:54:28 server2000: * cluster2:C:\a.txt E:\>REM Description: This variable needs to be set if Oracle Net configuration
二月 17 11:54:28 server2000: * cluster2:C:\a.txt
二月 17 11:54:28 server2000: * cluster2:C:\a.txt E:\>REM files are not located in default locations.
二月 17 11:54:28 server2000: * cluster2:C:\a.txt
二月 17 11:54:28 server2000: * cluster2:C:\a.txt E:\>REM
二月 17 11:54:28 server2000: * cluster2:C:\a.txt
二月 17 11:54:28 server2000: * cluster2:C:\a.txt E:\>SET TNS_ADMIN=C:\oracle\ora92\network\admin
二月 17 11:54:28 server2000: * cluster2:C:\a.txt
二月 17 11:54:28 server2000: * cluster2:C:\a.txt E:\>REM
二月 17 11:54:28 server2000: * cluster2:C:\a.txt
二月 17 11:54:28 server2000: * cluster2:C:\a.txt E:\>REM Execute the backup command
二月 17 11:54:28 server2000: * cluster2:C:\a.txt
二月 17 11:54:28 server2000: * cluster2:C:\a.txt E:\>REM
二月 17 11:54:28 server2000: * cluster2:C:\a.txt
二月 17 11:54:28 server2000: * cluster2:C:\a.txt E:\>SET args=-s server2000 -g Default -LL -m cluster2 -l full -q -W 78 -N "C:\a.txt" "C:\a.txt"
二月 17 11:54:28 server2000: * cluster2:C:\a.txt
二月 17 11:54:28 server2000: * cluster2:C:\a.txt E:\>nsrnmostart -s server2000 -g Default -LL -m cluster2 -l full -q -W 78 -N "C:\a.txt" "C:\a.txt"
二月 17 11:54:28 server2000: * cluster2:C:\a.txt
二月 17 11:54:28 server2000: * cluster2:C:\a.txt RMAN script execution is not successful. RMAN exited with return code '3'.
二月 17 11:54:28 server2000: --- Successful Save Sets ---
二月 17 11:54:28 server2000: server2000: index:cluster2 level=9, 14 KB 00:00:01 10 files
二月 17 11:54:28 server2000: server2000: bootstrap level=full, 83 KB 00:00:01 95 files
二月 17 11:54:28 server2000: * server2000:bootstrap nsrlpr: Either a printer isn't defined for printing the Bootstrap for this savegroup,
二月 17 11:54:28 server2000: * server2000:bootstrap or the '-PPRINTER' part of the notification resource is absent.
二月 17 11:54:28 server2000: * server2000:bootstrap Please correct as appropriate.
二月 17 11:54:28 server2000: * server2000:bootstrap printing bootstrap information failed (reproduced below).
二月 17 11:54:28 server2000: * server2000:bootstrap
二月 17 11:54:28 server2000: * server2000:bootstrap
二月 17 11:54:28 server2000: * server2000:bootstrap 二月 17 11:54 2006 server2000's bootstrap information Page 1
二月 17 11:54:28 server2000: * server2000:bootstrap
二月 17 11:54:28 server2000: * server2000:bootstrap date time level ssid file record volume
二月 17 11:54:28 server2000: * server2000:bootstrap 2006-02-15 10:41:12 full 4226979016 14 0 server2000.001
二月 17 11:54:28 server2000: * server2000:bootstrap 2006-02-15 10:44:39 full 4193424791 16 0 server2000.001
二月 17 11:54:28 server2000: * server2000:bootstrap 2006-02-15 14:13:19 full 4159882879 18 0 server2000.001
二月 17 11:54:28 server2000: * server2000:bootstrap 2006-02-15 14:32:07 full 4126329575 20 0 server2000.001
二月 17 11:54:28 server2000: * server2000:bootstrap 2006-02-15 14:37:23 full 4092775459 22 0 server2000.001
二月 17 11:54:28 server2000: * server2000:bootstrap 2006-02-15 14:38:39 full 4059221103 24 0 server2000.001
二月 17 11:54:28 server2000: * server2000:bootstrap 2006-02-17 10:11:02 full 4260704438 4260704438 0 server2000.002
二月 17 11:54:28 server2000: * server2000:bootstrap 2006-02-17 10:33:23 full 4227151347 4227151347 0 server2000.002
二月 17 11:54:28 server2000: * server2000:bootstrap 2006-02-17 10:51:39 full 4193598011 4193598011 0 server2000.002
二月 17 11:54:28 server2000: * server2000:bootstrap 2006-02-17 11:47:45 full 4109715297 4109715297 0 server2000.002