[求助]legato备份oracle问题

jimmyhjm

手动备份成功，但用计划起就失败，如下：

手动备份
[oracle@rhel4 /]$ rman cmdfile '/u02/rman_scripts/fullbkup'

Recovery Manager: Release 10.2.0.1.0 - Production on Thu Apr 3 18:39:24 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

RMAN> connect target *
2> connect rcvcat *
3> run {
4> allocate channel t1 type 'SBT_TAPE';
5> allocate channel t2 type 'SBT_TAPE';
6> send 'NSR_ENV=(NSR_DATA_VOLUME_POOL=files)';
7> backup database format 'archive_%d_%U';
8> release channel t1;
9> release channel t2;
10> }
11>
connected to target database: ORCL (DBID=1178697595)

connected to recovery catalog database

allocated channel: t1
channel t1: sid=142 devtype=SBT_TAPE
channel t1: NMO v4.2.0.0

allocated channel: t2
channel t2: sid=153 devtype=SBT_TAPE
channel t2: NMO v4.2.0.0

sent command to channel: t1
sent command to channel: t2

Starting backup at 03-APR-08
channel t1: starting full datafile backupset
channel t1: specifying datafile(s) in backupset
input datafile fno=00001 name=/u02/oradata/orcl/system01.dbf
input datafile fno=00004 name=/u02/oradata/orcl/users01.dbf
channel t1: starting piece 1 at 03-APR-08
channel t2: starting full datafile backupset
channel t2: specifying datafile(s) in backupset
input datafile fno=00003 name=/u02/oradata/orcl/sysaux01.dbf
input datafile fno=00005 name=/u02/oradata/orcl/rman_ts01.dbf
input datafile fno=00002 name=/u02/oradata/orcl/undotbs01.dbf
channel t2: starting piece 1 at 03-APR-08
channel t1: finished piece 1 at 03-APR-08
piece handle=archive_ORCL_1qjctn6v_1_1 tag=TAG20080403T183926 comment=API Version 2.0,MMS Version 4.2.0.0
channel t1: backup set complete, elapsed time: 00:01:25
channel t2: finished piece 1 at 03-APR-08
piece handle=archive_ORCL_1rjctn6v_1_1 tag=TAG20080403T183926 comment=API Version 2.0,MMS Version 4.2.0.0
channel t2: backup set complete, elapsed time: 00:01:25
Finished backup at 03-APR-08

Starting Control File and SPFILE Autobackup at 03-APR-08
piece handle=c-1178697595-20080403-06 comment=API Version 2.0,MMS Version 4.2.0.0
Finished Control File and SPFILE Autobackup at 03-APR-08

released channel: t1

released channel: t2

Recovery Manager complete.


用legato启动后报错日志：
04/03/08 18:53:29 nsrd: savegroup info: starting  oracle (with 1 client(s))
04/03/08 18:53:48 savegrp: command ' nsrnmo -s rhel4 -g oracle -LL -m rhel4 -l full -q -W 78 -N rman:/u02/rman_scripts/fullbkup rman
:/u02/rman_scripts/fullbkup' for client rhel4 exited with return code 1
* rhel4:rman:/u02/rman_scripts/fullbkup
* rhel4:rman:/u02/rman_scripts/fullbkup Recovery Manager: Release 10.2.0.1.0 - Production on Thu Apr 3 18:53:30 2008
* rhel4:rman:/u02/rman_scripts/fullbkup
* rhel4:rman:/u02/rman_scripts/fullbkup Copyright (c) 1982, 2005, Oracle.  All rights reserved.
* rhel4:rman:/u02/rman_scripts/fullbkup
* rhel4:rman:/u02/rman_scripts/fullbkup RMAN> connect ********
* rhel4:rman:/u02/rman_scripts/fullbkup 2> connect ********
* rhel4:rman:/u02/rman_scripts/fullbkup 3> run {
* rhel4:rman:/u02/rman_scripts/fullbkup 4> allocate channel t1 type 'SBT_TAPE';
* rhel4:rman:/u02/rman_scripts/fullbkup 5> allocate channel t2 type 'SBT_TAPE';
* rhel4:rman:/u02/rman_scripts/fullbkup 6> send 'NSR_ENV=(NSR_DATA_VOLUME_POOL=files)';
* rhel4:rman:/u02/rman_scripts/fullbkup 7> backup database format 'archive_%d_%U';
* rhel4:rman:/u02/rman_scripts/fullbkup 8> release channel t1;
* rhel4:rman:/u02/rman_scripts/fullbkup 9> release channel t2;
* rhel4:rman:/u02/rman_scripts/fullbkup 10> }
* rhel4:rman:/u02/rman_scripts/fullbkup 11>
* rhel4:rman:/u02/rman_scripts/fullbkup connected to target database: ORCL (DBID=1178697595)
* rhel4:rman:/u02/rman_scripts/fullbkup
* rhel4:rman:/u02/rman_scripts/fullbkup connected to recovery catalog database
* rhel4:rman:/u02/rman_scripts/fullbkup
* rhel4:rman:/u02/rman_scripts/fullbkup allocated channel: t1
* rhel4:rman:/u02/rman_scripts/fullbkup channel t1: sid=159 devtype=SBT_TAPE
* rhel4:rman:/u02/rman_scripts/fullbkup channel t1: NMO v4.2.0.0
* rhel4:rman:/u02/rman_scripts/fullbkup sent command to channel: t1
* rhel4:rman:/u02/rman_scripts/fullbkup
* rhel4:rman:/u02/rman_scripts/fullbkup allocated channel: t2
* rhel4:rman:/u02/rman_scripts/fullbkup channel t2: sid=141 devtype=SBT_TAPE
* rhel4:rman:/u02/rman_scripts/fullbkup channel t2: NMO v4.2.0.0
* rhel4:rman:/u02/rman_scripts/fullbkup sent command to channel: t2
* rhel4:rman:/u02/rman_scripts/fullbkup
* rhel4:rman:/u02/rman_scripts/fullbkup sent command to channel: t1
* rhel4:rman:/u02/rman_scripts/fullbkup sent command to channel: t2
* rhel4:rman:/u02/rman_scripts/fullbkup
* rhel4:rman:/u02/rman_scripts/fullbkup Starting backup at 03-APR-08
* rhel4:rman:/u02/rman_scripts/fullbkup channel t1: starting full datafile backupset
* rhel4:rman:/u02/rman_scripts/fullbkup channel t1: specifying datafile(s) in backupset
* rhel4:rman:/u02/rman_scripts/fullbkup input datafile fno=00001 name=/u02/oradata/orcl/system01.dbf
* rhel4:rman:/u02/rman_scripts/fullbkup input datafile fno=00004 name=/u02/oradata/orcl/users01.dbf
* rhel4:rman:/u02/rman_scripts/fullbkup channel t1: starting piece 1 at 03-APR-08
* rhel4:rman:/u02/rman_scripts/fullbkup channel t2: starting full datafile backupset
* rhel4:rman:/u02/rman_scripts/fullbkup channel t2: specifying datafile(s) in backupset
* rhel4:rman:/u02/rman_scripts/fullbkup input datafile fno=00003 name=/u02/oradata/orcl/sysaux01.dbf
* rhel4:rman:/u02/rman_scripts/fullbkup input datafile fno=00005 name=/u02/oradata/orcl/rman_ts01.dbf
* rhel4:rman:/u02/rman_scripts/fullbkup input datafile fno=00002 name=/u02/oradata/orcl/undotbs01.dbf
* rhel4:rman:/u02/rman_scripts/fullbkup channel t2: starting piece 1 at 03-APR-08
* rhel4:rman:/u02/rman_scripts/fullbkup RMAN-03009: failure of backup command on t1 channel at 04/03/2008 18:53:35
* rhel4:rman:/u02/rman_scripts/fullbkup ORA-19506: failed to create sequential file, name="archive_ORCL_1tjcto1e_1_1", parms=""
* rhel4:rman:/u02/rman_scripts/fullbkup ORA-27028: skgfqcre: sbtbackup returned error
* rhel4:rman:/u02/rman_scripts/fullbkup ORA-19511: Error received from media manager layer, error text:
* rhel4:rman:/u02/rman_scripts/fullbkup    The RMAN prefix 'RMAN:' must not contain lower case characters:
* rhel4:rman:/u02/rman_scripts/fullbkup         rman:/u02/rman_scripts/fullbkup (105:2:0)
* rhel4:rman:/u02/rman_scripts/fullbkup channel t1 disabled, job failed on it will be run on another channel
* rhel4:rman:/u02/rman_scripts/fullbkup RMAN-03009: failure of backup command on t2 channel at 04/03/2008 18:53:35
* rhel4:rman:/u02/rman_scripts/fullbkup ORA-19506: failed to create sequential file, name="archive_ORCL_1ujcto1e_1_1", parms=""
* rhel4:rman:/u02/rman_scripts/fullbkup ORA-27028: skgfqcre: sbtbackup returned error
* rhel4:rman:/u02/rman_scripts/fullbkup ORA-19511: Error received from media manager layer, error text:
* rhel4:rman:/u02/rman_scripts/fullbkup    The RMAN prefix 'RMAN:' must not contain lower case characters:
* rhel4:rman:/u02/rman_scripts/fullbkup         rman:/u02/rman_scripts/fullbkup (105:2:0)
* rhel4:rman:/u02/rman_scripts/fullbkup channel t2 disabled, job failed on it will be run on another channel
* rhel4:rman:/u02/rman_scripts/fullbkup released channel: t1
* rhel4:rman:/u02/rman_scripts/fullbkup released channel: t2
* rhel4:rman:/u02/rman_scripts/fullbkup RMAN-00571: ===========================================================
* rhel4:rman:/u02/rman_scripts/fullbkup RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
* rhel4:rman:/u02/rman_scripts/fullbkup RMAN-00571: ===========================================================
* rhel4:rman:/u02/rman_scripts/fullbkup
* rhel4:rman:/u02/rman_scripts/fullbkup RMAN-03009: failure of backup command on t1 channel at 04/03/2008 18:53:35
* rhel4:rman:/u02/rman_scripts/fullbkup ORA-19506: failed to create sequential file, name="archive_ORCL_1tjcto1e_1_1", parms=""
* rhel4:rman:/u02/rman_scripts/fullbkup ORA-27028: skgfqcre: sbtbackup returned error
* rhel4:rman:/u02/rman_scripts/fullbkup ORA-19511: Error received from media manager layer, error text:
* rhel4:rman:/u02/rman_scripts/fullbkup    The RMAN prefix 'RMAN:' must not contain lower case characters:
* rhel4:rman:/u02/rman_scripts/fullbkup         rman:/u02/rman_scripts/fullbkup (105:2:0)
* rhel4:rman:/u02/rman_scripts/fullbkup RMAN-03009: failure of backup command on t2 channel at 04/03/2008 18:53:35
* rhel4:rman:/u02/rman_scripts/fullbkup ORA-19506: failed to create sequential file, name="archive_ORCL_1ujcto1e_1_1", parms=""
* rhel4:rman:/u02/rman_scripts/fullbkup ORA-27028: skgfqcre: sbtbackup returned error
* rhel4:rman:/u02/rman_scripts/fullbkup ORA-19511: Error received from media manager layer, error text:
* rhel4:rman:/u02/rman_scripts/fullbkup    The RMAN prefix 'RMAN:' must not contain lower case characters:
* rhel4:rman:/u02/rman_scripts/fullbkup         rman:/u02/rman_scripts/fullbkup (105:2:0)
* rhel4:rman:/u02/rman_scripts/fullbkup
* rhel4:rman:/u02/rman_scripts/fullbkup Recovery Manager complete.
* rhel4:rman:/u02/rman_scripts/fullbkup
* rhel4:rman:/u02/rman_scripts/fullbkup RMAN script execution is not successful. RMAN exited with return code '1'.
* rhel4:rman:/u02/rman_scripts/fullbkup nsrnmostart returned status of 254
* rhel4:rman:/u02/rman_scripts/fullbkup /usr/sbin/nsrnmo exiting.
04/03/08 18:53:48 savegrp: rhel4:rman:/u02/rman_scripts/fullbkup failed.
04/03/08 18:53:48 savegrp: rhel4:rman:/u02/rman_scripts/fullbkup will retry 1 more time(s)
04/03/08 18:54:07 savegrp: command ' nsrnmo -s rhel4 -g oracle -LL -m rhel4 -l full -q -W 78 -N rman:/u02/rman_scripts/fullbkup rman
:/u02/rman_scripts/fullbkup' for client rhel4 exited with return code 1
* rhel4:rman:/u02/rman_scripts/fullbkup 1 retry attempted
* rhel4:rman:/u02/rman_scripts/fullbkup
* rhel4:rman:/u02/rman_scripts/fullbkup Recovery Manager: Release 10.2.0.1.0 - Production on Thu Apr 3 18:53:49 2008
* rhel4:rman:/u02/rman_scripts/fullbkup
* rhel4:rman:/u02/rman_scripts/fullbkup Copyright (c) 1982, 2005, Oracle.  All rights reserved.
* rhel4:rman:/u02/rman_scripts/fullbkup
* rhel4:rman:/u02/rman_scripts/fullbkup RMAN> connect ********
* rhel4:rman:/u02/rman_scripts/fullbkup 2> connect ********
* rhel4:rman:/u02/rman_scripts/fullbkup 3> run {
* rhel4:rman:/u02/rman_scripts/fullbkup 4> allocate channel t1 type 'SBT_TAPE';
* rhel4:rman:/u02/rman_scripts/fullbkup 5> allocate channel t2 type 'SBT_TAPE';
* rhel4:rman:/u02/rman_scripts/fullbkup 6> send 'NSR_ENV=(NSR_DATA_VOLUME_POOL=files)';
* rhel4:rman:/u02/rman_scripts/fullbkup 7> backup database format 'archive_%d_%U';
* rhel4:rman:/u02/rman_scripts/fullbkup 8> release channel t1;
* rhel4:rman:/u02/rman_scripts/fullbkup 9> release channel t2;
* rhel4:rman:/u02/rman_scripts/fullbkup 10> }
* rhel4:rman:/u02/rman_scripts/fullbkup 11>
* rhel4:rman:/u02/rman_scripts/fullbkup connected to target database: ORCL (DBID=1178697595)
* rhel4:rman:/u02/rman_scripts/fullbkup
* rhel4:rman:/u02/rman_scripts/fullbkup connected to recovery catalog database
* rhel4:rman:/u02/rman_scripts/fullbkup
* rhel4:rman:/u02/rman_scripts/fullbkup allocated channel: t1
* rhel4:rman:/u02/rman_scripts/fullbkup channel t1: sid=140 devtype=SBT_TAPE
* rhel4:rman:/u02/rman_scripts/fullbkup channel t1: NMO v4.2.0.0
* rhel4:rman:/u02/rman_scripts/fullbkup sent command to channel: t1
* rhel4:rman:/u02/rman_scripts/fullbkup
* rhel4:rman:/u02/rman_scripts/fullbkup allocated channel: t2
* rhel4:rman:/u02/rman_scripts/fullbkup channel t2: sid=142 devtype=SBT_TAPE
* rhel4:rman:/u02/rman_scripts/fullbkup channel t2: NMO v4.2.0.0
* rhel4:rman:/u02/rman_scripts/fullbkup sent command to channel: t2
* rhel4:rman:/u02/rman_scripts/fullbkup
* rhel4:rman:/u02/rman_scripts/fullbkup sent command to channel: t1
* rhel4:rman:/u02/rman_scripts/fullbkup sent command to channel: t2
* rhel4:rman:/u02/rman_scripts/fullbkup
* rhel4:rman:/u02/rman_scripts/fullbkup Starting backup at 03-APR-08
* rhel4:rman:/u02/rman_scripts/fullbkup channel t1: starting full datafile backupset
* rhel4:rman:/u02/rman_scripts/fullbkup channel t1: specifying datafile(s) in backupset
* rhel4:rman:/u02/rman_scripts/fullbkup input datafile fno=00001 name=/u02/oradata/orcl/system01.dbf
* rhel4:rman:/u02/rman_scripts/fullbkup input datafile fno=00004 name=/u02/oradata/orcl/users01.dbf
* rhel4:rman:/u02/rman_scripts/fullbkup channel t1: starting piece 1 at 03-APR-08
* rhel4:rman:/u02/rman_scripts/fullbkup channel t2: starting full datafile backupset
* rhel4:rman:/u02/rman_scripts/fullbkup channel t2: specifying datafile(s) in backupset
* rhel4:rman:/u02/rman_scripts/fullbkup input datafile fno=00003 name=/u02/oradata/orcl/sysaux01.dbf
* rhel4:rman:/u02/rman_scripts/fullbkup input datafile fno=00005 name=/u02/oradata/orcl/rman_ts01.dbf
* rhel4:rman:/u02/rman_scripts/fullbkup input datafile fno=00002 name=/u02/oradata/orcl/undotbs01.dbf
* rhel4:rman:/u02/rman_scripts/fullbkup channel t2: starting piece 1 at 03-APR-08
* rhel4:rman:/u02/rman_scripts/fullbkup RMAN-03009: failure of backup command on t1 channel at 04/03/2008 18:53:53
* rhel4:rman:/u02/rman_scripts/fullbkup ORA-19506: failed to create sequential file, name="archive_ORCL_1vjcto1v_1_1", parms=""
* rhel4:rman:/u02/rman_scripts/fullbkup ORA-27028: skgfqcre: sbtbackup returned error
* rhel4:rman:/u02/rman_scripts/fullbkup ORA-19511: Error received from media manager layer, error text:
* rhel4:rman:/u02/rman_scripts/fullbkup    The RMAN prefix 'RMAN:' must not contain lower case characters:
* rhel4:rman:/u02/rman_scripts/fullbkup         rman:/u02/rman_scripts/fullbkup (105:2:0)
* rhel4:rman:/u02/rman_scripts/fullbkup channel t1 disabled, job failed on it will be run on another channel
* rhel4:rman:/u02/rman_scripts/fullbkup RMAN-03009: failure of backup command on t2 channel at 04/03/2008 18:53:53
* rhel4:rman:/u02/rman_scripts/fullbkup ORA-19506: failed to create sequential file, name="archive_ORCL_20jcto20_1_1", parms=""
* rhel4:rman:/u02/rman_scripts/fullbkup ORA-27028: skgfqcre: sbtbackup returned error
* rhel4:rman:/u02/rman_scripts/fullbkup ORA-19511: Error received from media manager layer, error text:
* rhel4:rman:/u02/rman_scripts/fullbkup    The RMAN prefix 'RMAN:' must not contain lower case characters:
* rhel4:rman:/u02/rman_scripts/fullbkup         rman:/u02/rman_scripts/fullbkup (105:2:0)
* rhel4:rman:/u02/rman_scripts/fullbkup channel t2 disabled, job failed on it will be run on another channel
* rhel4:rman:/u02/rman_scripts/fullbkup released channel: t1
* rhel4:rman:/u02/rman_scripts/fullbkup released channel: t2
* rhel4:rman:/u02/rman_scripts/fullbkup RMAN-00571: ===========================================================
* rhel4:rman:/u02/rman_scripts/fullbkup RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
* rhel4:rman:/u02/rman_scripts/fullbkup RMAN-00571: ===========================================================
* rhel4:rman:/u02/rman_scripts/fullbkup
* rhel4:rman:/u02/rman_scripts/fullbkup RMAN-03009: failure of backup command on t1 channel at 04/03/2008 18:53:53
* rhel4:rman:/u02/rman_scripts/fullbkup ORA-19506: failed to create sequential file, name="archive_ORCL_1vjcto1v_1_1", parms=""
* rhel4:rman:/u02/rman_scripts/fullbkup ORA-27028: skgfqcre: sbtbackup returned error
* rhel4:rman:/u02/rman_scripts/fullbkup ORA-19511: Error received from media manager layer, error text:
* rhel4:rman:/u02/rman_scripts/fullbkup    The RMAN prefix 'RMAN:' must not contain lower case characters:
* rhel4:rman:/u02/rman_scripts/fullbkup         rman:/u02/rman_scripts/fullbkup (105:2:0)
* rhel4:rman:/u02/rman_scripts/fullbkup RMAN-03009: failure of backup command on t2 channel at 04/03/2008 18:53:53
* rhel4:rman:/u02/rman_scripts/fullbkup ORA-19506: failed to create sequential file, name="archive_ORCL_20jcto20_1_1", parms=""
* rhel4:rman:/u02/rman_scripts/fullbkup ORA-27028: skgfqcre: sbtbackup returned error
* rhel4:rman:/u02/rman_scripts/fullbkup ORA-19511: Error received from media manager layer, error text:
* rhel4:rman:/u02/rman_scripts/fullbkup    The RMAN prefix 'RMAN:' must not contain lower case characters:
* rhel4:rman:/u02/rman_scripts/fullbkup         rman:/u02/rman_scripts/fullbkup (105:2:0)
* rhel4:rman:/u02/rman_scripts/fullbkup
* rhel4:rman:/u02/rman_scripts/fullbkup Recovery Manager complete.
* rhel4:rman:/u02/rman_scripts/fullbkup
* rhel4:rman:/u02/rman_scripts/fullbkup RMAN script execution is not successful. RMAN exited with return code '1'.
* rhel4:rman:/u02/rman_scripts/fullbkup nsrnmostart returned status of 254
* rhel4:rman:/u02/rman_scripts/fullbkup /usr/sbin/nsrnmo exiting.
04/03/08 18:54:07 savegrp: rhel4:rman:/u02/rman_scripts/fullbkup failed.
04/03/08 18:54:07 nsrd: rhel4:index:rhel4 saving to pool 'files' (files.000)
04/03/08 18:54:07 nsrd: rhel4:index:rhel4 done saving to pool 'files' (files.000) 12 KB
04/03/08 18:54:07 nsrd: rhel4:bootstrap saving to pool 'files' (files.000)
04/03/08 18:54:09 nsrmmdbd: media db is saving its data.  This may take a while.
04/03/08 18:54:09 nsrmmdbd: media db is open for business.
04/03/08 18:54:09 nsrd: rhel4:bootstrap done saving to pool 'files' (files.000) 200 KB
04/03/08 18:54:09 nsrd: savegroup failure alert: oracle Completed/Aborted, Total 1 client(s), 0 Clients disabled, 0 Hostname(s) Unre
solved, 1 Failed, 0 Succeeded.
04/03/08 18:54:10 nsrd: savegroup alert: oracle completed, Total 1 client(s), 1 Failed. Please see group completion details for more
information.

jimmyhjm

搞定了，saveset照legato文档写不行，不能加rman:

yddll

legato的文档教你这么写了？？

wolfheader

原帖由 jimmyhjm 于 2008-4-3 18:24 发表
搞定了，saveset照legato文档写不行，不能加rman:

难道是新的手册?没看过

w3wu

stornewer

不会吧,不加"RMAN:"?

redwaves

究竟是为何呀,贴出来?