Chinaunix

标题: 求救：legato备份失败问题. [打印本页]

作者: chinaboycj 时间: 2010-06-02 18:59
标题: 求救：legato备份失败问题.
利用legato软件同时备份四台小机ORACLE DB数据库,一份到磁带，一份到存储，其他三台都能备份，有一台以前都是好的，今天在networker图像界面中在“管理”中“监视”。
单击“组”选项卡，出现备份失败，右键单击要启动的组，然后选择“启动”，持续一段时间显示正在运行，过一会儿还是出现失败。
networker图像界面报错如下：

已重试 1 次。
off
cmd_args = nocatalog msglog '/nsr/applogs/msglog_trade_every_day_full_tape.log'
cmd_args = send 'NSR_ENV=(NSR_GROUP=trade_every_day_tape,NSR_SERVER=backupserver.cssfintra.com,NSR_SAVESET_NAME=RMAN:/oracle/scripts/trade_prod_full_tape)'
rman_script = /oracle/scripts/trade_prod_full_tape
saveset_name = RMAN:/oracle/scripts/trade_prod_full_tape
Launching backup process
RMAN exited with return code '1'.
nsrnmostart returned status of 255
/opt/networker/bin/nsrnmo2 exiting.

登陆服务器查看RMAN log报错日志如下：

..............
Starting backup at 02-JUN-10
channel ch1: starting full datafile backupset
channel ch1: specifying datafile(s) in backupset
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
cannot make a snapshot controlfile
released channel: ch1
released channel: ch2
released channel: ch3
released channel: ch4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch1 channel at 06/02/2010 14:06:12
ORA-00230: operation disallowed: snapshot controlfile enqueue unavailable

Recovery Manager complete.

...............

是怎么回事？其他几台都是好好的。

1.GIF (44.8 KB, 下载次数: 35)

3_报错信息.GIF (12.72 KB, 下载次数: 40)

作者: chinaboycj 时间: 2010-06-02 19:05
还有legato怎么在图像界面下做一个全备份，我找不到该按钮。

作者: 100心 时间: 2010-06-02 19:11
无法备份控制文件。

脚本贴出来？

作者: chinaboycj 时间: 2010-06-02 19:13
脚本应该没问题，以前一直都能做备份的。

tmsm[/nsr/applogs]#tail -n 500 msglog_trade_every_day_full_disk.log
11>    (tablespace 'SYSTEM'
12>    ,'TRADE'
13>    ,'TRADEINDEX'
14>    include current controlfile);
15>
16> release channel ch1;
17> release channel ch2;
18> release channel ch3;
19> release channel ch4;
20> }
21>
connected to target database: TRADE (DBID=2338289953)
using target database controlfile instead of recovery catalog

allocated channel: ch1
channel ch1: sid=90 devtype=SBT_TAPE
channel ch1: NMO v4.5.0.0
sent command to channel: ch1

allocated channel: ch2
channel ch2: sid=88 devtype=SBT_TAPE
channel ch2: NMO v4.5.0.0
sent command to channel: ch2

allocated channel: ch3
channel ch3: sid=97 devtype=SBT_TAPE
channel ch3: NMO v4.5.0.0
sent command to channel: ch3

allocated channel: ch4
channel ch4: sid=96 devtype=SBT_TAPE
channel ch4: NMO v4.5.0.0
sent command to channel: ch4

sent command to channel: ch1
sent command to channel: ch2
sent command to channel: ch3
sent command to channel: ch4

Starting backup at 02-JUN-10
channel ch1: starting full datafile backupset
channel ch1: specifying datafile(s) in backupset
including current controlfile in backupset
input datafile fno=00001 name=/oradata/system01.dbf
channel ch1: starting piece 1 at 02-JUN-10
channel ch2: starting full datafile backupset
channel ch2: specifying datafile(s) in backupset
input datafile fno=00011 name=/oradata/TRADE.dbf
channel ch2: starting piece 1 at 02-JUN-10
channel ch3: starting full datafile backupset
channel ch3: specifying datafile(s) in backupset
input datafile fno=00013 name=/oradata/TRADEINDEX.dbf
channel ch3: starting piece 1 at 02-JUN-10

user interrupt received
Finished backup at 02-JUN-10

Recovery Manager: Release 9.2.0.7.0 - 64bit Production

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

RMAN> connect target rman/rman@trade;
2> run {
3> allocate channel ch1 type 'SBT_TAPE';
4> allocate channel ch2 type 'SBT_TAPE';
5> allocate channel ch3 type 'SBT_TAPE';
6> allocate channel ch4 type 'SBT_TAPE';
7> send 'NSR_ENV=(NSR_DATA_VOLUME_POOL=trade disk backup pool,NSR_SERVER=backupserver.cssfintra.com)';
8>
9> backup
10>    format 'Trade_full%d_%U'
11>    (tablespace 'SYSTEM'
12>    ,'TRADE'
13>    ,'TRADEINDEX'
14>    include current controlfile);
15>
16> release channel ch1;
17> release channel ch2;
18> release channel ch3;
19> release channel ch4;
20> }
21>
connected to target database: TRADE (DBID=2338289953)
using target database controlfile instead of recovery catalog

allocated channel: ch1
channel ch1: sid=101 devtype=SBT_TAPE
channel ch1: NMO v4.5.0.0
sent command to channel: ch1

allocated channel: ch2
channel ch2: sid=102 devtype=SBT_TAPE
channel ch2: NMO v4.5.0.0
sent command to channel: ch2

allocated channel: ch3
channel ch3: sid=107 devtype=SBT_TAPE
channel ch3: NMO v4.5.0.0
sent command to channel: ch3

allocated channel: ch4
channel ch4: sid=100 devtype=SBT_TAPE
channel ch4: NMO v4.5.0.0
sent command to channel: ch4

sent command to channel: ch1
sent command to channel: ch2
sent command to channel: ch3
sent command to channel: ch4

Starting backup at 02-JUN-10
channel ch1: starting full datafile backupset
channel ch1: specifying datafile(s) in backupset
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
cannot make a snapshot controlfile
released channel: ch1
released channel: ch2
released channel: ch3
released channel: ch4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch1 channel at 06/02/2010 14:06:12
ORA-00230: operation disallowed: snapshot controlfile enqueue unavailable

Recovery Manager complete.

Recovery Manager: Release 9.2.0.7.0 - 64bit Production

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

RMAN> connect target rman/rman@trade;
2> run {
3> allocate channel ch1 type 'SBT_TAPE';
4> allocate channel ch2 type 'SBT_TAPE';
5> allocate channel ch3 type 'SBT_TAPE';
6> allocate channel ch4 type 'SBT_TAPE';
7> send 'NSR_ENV=(NSR_DATA_VOLUME_POOL=trade disk backup pool,NSR_SERVER=backupserver.cssfintra.com)';
8>
9> backup
10>    format 'Trade_full%d_%U'
11>    (tablespace 'SYSTEM'
12>    ,'TRADE'
13>    ,'TRADEINDEX'
14>    include current controlfile);
15>
16> release channel ch1;
17> release channel ch2;
18> release channel ch3;
19> release channel ch4;
20> }
21>
connected to target database: TRADE (DBID=2338289953)
using target database controlfile instead of recovery catalog

allocated channel: ch1
channel ch1: sid=107 devtype=SBT_TAPE
channel ch1: NMO v4.5.0.0
sent command to channel: ch1

allocated channel: ch2
channel ch2: sid=102 devtype=SBT_TAPE
channel ch2: NMO v4.5.0.0
sent command to channel: ch2

allocated channel: ch3
channel ch3: sid=101 devtype=SBT_TAPE
channel ch3: NMO v4.5.0.0
sent command to channel: ch3

allocated channel: ch4
channel ch4: sid=95 devtype=SBT_TAPE
channel ch4: NMO v4.5.0.0
sent command to channel: ch4

sent command to channel: ch1
sent command to channel: ch2
sent command to channel: ch3
sent command to channel: ch4

Starting backup at 02-JUN-10
channel ch1: starting full datafile backupset
channel ch1: specifying datafile(s) in backupset
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
cannot make a snapshot controlfile
released channel: ch1
released channel: ch2
released channel: ch3
released channel: ch4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch1 channel at 06/02/2010 14:08:46
ORA-00230: operation disallowed: snapshot controlfile enqueue unavailable

Recovery Manager complete.

Recovery Manager: Release 9.2.0.7.0 - 64bit Production

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

RMAN> connect target rman/rman@trade;
2> run {
3> allocate channel ch1 type 'SBT_TAPE';
4> allocate channel ch2 type 'SBT_TAPE';
5> allocate channel ch3 type 'SBT_TAPE';
6> allocate channel ch4 type 'SBT_TAPE';
7> send 'NSR_ENV=(NSR_DATA_VOLUME_POOL=trade disk backup pool,NSR_SERVER=backupserver.cssfintra.com)';
8>
9> backup
10>    format 'Trade_full%d_%U'
11>    (tablespace 'SYSTEM'
12>    ,'TRADE'
13>    ,'TRADEINDEX'
14>    include current controlfile);
15>
16> release channel ch1;
17> release channel ch2;
18> release channel ch3;
19> release channel ch4;
20> }
21>
connected to target database: TRADE (DBID=2338289953)
using target database controlfile instead of recovery catalog

allocated channel: ch1
channel ch1: sid=105 devtype=SBT_TAPE
channel ch1: NMO v4.5.0.0
sent command to channel: ch1

allocated channel: ch2
channel ch2: sid=110 devtype=SBT_TAPE
channel ch2: NMO v4.5.0.0
sent command to channel: ch2

allocated channel: ch3
channel ch3: sid=106 devtype=SBT_TAPE
channel ch3: NMO v4.5.0.0
sent command to channel: ch3

allocated channel: ch4
channel ch4: sid=95 devtype=SBT_TAPE
channel ch4: NMO v4.5.0.0
sent command to channel: ch4

sent command to channel: ch1
sent command to channel: ch2
sent command to channel: ch3
sent command to channel: ch4

Starting backup at 02-JUN-10
channel ch1: starting full datafile backupset
channel ch1: specifying datafile(s) in backupset
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
cannot make a snapshot controlfile
released channel: ch1
released channel: ch2
released channel: ch3
released channel: ch4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch1 channel at 06/02/2010 14:20:35
ORA-00230: operation disallowed: snapshot controlfile enqueue unavailable

Recovery Manager complete.

Recovery Manager: Release 9.2.0.7.0 - 64bit Production

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

RMAN> connect target rman/rman@trade;
2> run {
3> allocate channel ch1 type 'SBT_TAPE';
4> allocate channel ch2 type 'SBT_TAPE';
5> allocate channel ch3 type 'SBT_TAPE';
6> allocate channel ch4 type 'SBT_TAPE';
7> send 'NSR_ENV=(NSR_DATA_VOLUME_POOL=trade disk backup pool,NSR_SERVER=backupserver.cssfintra.com)';
8>
9> backup
10>    format 'Trade_full%d_%U'
11>    (tablespace 'SYSTEM'
12>    ,'TRADE'
13>    ,'TRADEINDEX'
14>    include current controlfile);
15>
16> release channel ch1;
17> release channel ch2;
18> release channel ch3;
19> release channel ch4;
20> }
21>
connected to target database: TRADE (DBID=2338289953)
using target database controlfile instead of recovery catalog

allocated channel: ch1
channel ch1: sid=110 devtype=SBT_TAPE
channel ch1: NMO v4.5.0.0
sent command to channel: ch1

allocated channel: ch2
channel ch2: sid=105 devtype=SBT_TAPE
channel ch2: NMO v4.5.0.0
sent command to channel: ch2

allocated channel: ch3
channel ch3: sid=104 devtype=SBT_TAPE
channel ch3: NMO v4.5.0.0
sent command to channel: ch3

allocated channel: ch4
channel ch4: sid=106 devtype=SBT_TAPE
channel ch4: NMO v4.5.0.0
sent command to channel: ch4

sent command to channel: ch1
sent command to channel: ch2
sent command to channel: ch3
sent command to channel: ch4

Starting backup at 02-JUN-10
channel ch1: starting full datafile backupset
channel ch1: specifying datafile(s) in backupset
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
cannot make a snapshot controlfile
released channel: ch1
released channel: ch2
released channel: ch3
released channel: ch4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch1 channel at 06/02/2010 14:23:10
ORA-00230: operation disallowed: snapshot controlfile enqueue unavailable

Recovery Manager complete.

Recovery Manager: Release 9.2.0.7.0 - 64bit Production

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

RMAN> connect target rman/rman@trade;
2> run {
3> allocate channel ch1 type 'SBT_TAPE';
4> allocate channel ch2 type 'SBT_TAPE';
5> allocate channel ch3 type 'SBT_TAPE';
6> allocate channel ch4 type 'SBT_TAPE';
7> send 'NSR_ENV=(NSR_DATA_VOLUME_POOL=trade disk backup pool,NSR_SERVER=backupserver.cssfintra.com)';
8>
9> backup
10>    format 'Trade_full%d_%U'
11>    (tablespace 'SYSTEM'
12>    ,'TRADE'
13>    ,'TRADEINDEX'
14>    include current controlfile);
15>
16> release channel ch1;
17> release channel ch2;
18> release channel ch3;
19> release channel ch4;
20> }
21>
connected to target database: TRADE (DBID=2338289953)
using target database controlfile instead of recovery catalog

allocated channel: ch1
channel ch1: sid=109 devtype=SBT_TAPE
channel ch1: NMO v4.5.0.0
sent command to channel: ch1

allocated channel: ch2
channel ch2: sid=103 devtype=SBT_TAPE
channel ch2: NMO v4.5.0.0
sent command to channel: ch2

allocated channel: ch3
channel ch3: sid=102 devtype=SBT_TAPE
channel ch3: NMO v4.5.0.0
sent command to channel: ch3

allocated channel: ch4
channel ch4: sid=106 devtype=SBT_TAPE
channel ch4: NMO v4.5.0.0
sent command to channel: ch4

sent command to channel: ch1
sent command to channel: ch2
sent command to channel: ch3
sent command to channel: ch4

Starting backup at 02-JUN-10
channel ch1: starting full datafile backupset
channel ch1: specifying datafile(s) in backupset
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
cannot make a snapshot controlfile
released channel: ch1
released channel: ch2
released channel: ch3
released channel: ch4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch1 channel at 06/02/2010 14:32:42
ORA-00230: operation disallowed: snapshot controlfile enqueue unavailable

Recovery Manager complete.

Recovery Manager: Release 9.2.0.7.0 - 64bit Production

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

RMAN> connect target rman/rman@trade;
2> run {
3> allocate channel ch1 type 'SBT_TAPE';
4> allocate channel ch2 type 'SBT_TAPE';
5> allocate channel ch3 type 'SBT_TAPE';
6> allocate channel ch4 type 'SBT_TAPE';
7> send 'NSR_ENV=(NSR_DATA_VOLUME_POOL=trade disk backup pool,NSR_SERVER=backupserver.cssfintra.com)';
8>
9> backup
10>    format 'Trade_full%d_%U'
11>    (tablespace 'SYSTEM'
12>    ,'TRADE'
13>    ,'TRADEINDEX'
14>    include current controlfile);
15>
16> release channel ch1;
17> release channel ch2;
18> release channel ch3;
19> release channel ch4;
20> }
21>
connected to target database: TRADE (DBID=2338289953)
using target database controlfile instead of recovery catalog

allocated channel: ch1
channel ch1: sid=103 devtype=SBT_TAPE
channel ch1: NMO v4.5.0.0
sent command to channel: ch1

allocated channel: ch2
channel ch2: sid=102 devtype=SBT_TAPE
channel ch2: NMO v4.5.0.0
sent command to channel: ch2

allocated channel: ch3
channel ch3: sid=101 devtype=SBT_TAPE
channel ch3: NMO v4.5.0.0
sent command to channel: ch3

allocated channel: ch4
channel ch4: sid=113 devtype=SBT_TAPE
channel ch4: NMO v4.5.0.0
sent command to channel: ch4

sent command to channel: ch1
sent command to channel: ch2
sent command to channel: ch3
sent command to channel: ch4

Starting backup at 02-JUN-10
channel ch1: starting full datafile backupset
channel ch1: specifying datafile(s) in backupset
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
cannot make a snapshot controlfile
released channel: ch1
released channel: ch2
released channel: ch3
released channel: ch4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch1 channel at 06/02/2010 14:35:17
ORA-00230: operation disallowed: snapshot controlfile enqueue unavailable

Recovery Manager complete.

作者: 100心 时间: 2010-06-02 19:22
不是日志啊，是原始脚本。
你现在是无法 SNAPSHOT CONTROLFILE 。要看你脚步里是否触发了这个动作。
还是系统设置每次备份做这个动作。

这个情况估计是数据库的原因较多。

作者: chinaboycj 时间: 2010-06-02 19:29
下班回来了。明天一早把脚本搞下来，给你看看。好像其他机器都一样的脚本，都能执行。

作者: 100心 时间: 2010-06-02 20:13

可以的话把你这个数据库重启下嘿嘿。

作者: chinaboycj 时间: 2010-06-02 21:35
好的。谢谢

作者: yddll 时间: 2010-06-03 01:15
有一次备份挂掉了，找找第一次备份失败的信息

找dba查查关于rman的session

作者: michael1983 时间: 2010-06-03 09:10
怀疑是DB的问题

作者: chinaboycj 时间: 2010-06-03 09:47
基于磁带备份：abc[/oracle/scripts]#cat trade_prod_full_tape
connect target rman/rman@trade;
run {
  allocate channel ch1 type 'SBT_TAPE';
  allocate channel ch2 type 'SBT_TAPE';
  allocate channel ch3 type 'SBT_TAPE';
  allocate channel ch4 type 'SBT_TAPE';
  send 'NSR_ENV=(NSR_DATA_VOLUME_POOL=trade tape backup pool,NSR_SERVER=backupse
rver.cssfintra.com)';

  backup
format 'Trade_prod_%d_%U'
(tablespace 'SYSTEM'
   ,'TRADE'
   ,'TRADEINDEX'
include current controlfile);

  release channel ch1;
  release channel ch2;
  release channel ch3;
  release channel ch4;
}

基于磁盘备份：aaa[/oracle/scripts]#trade_prod_full_disk
sh: trade_prod_full_disk:  not found.
tmsm[/oracle/scripts]#cat trade_prod_full_disk
connect target rman/rman@trade;
run {
  allocate channel ch1 type 'SBT_TAPE';
  allocate channel ch2 type 'SBT_TAPE';
  allocate channel ch3 type 'SBT_TAPE';
  allocate channel ch4 type 'SBT_TAPE';
  send 'NSR_ENV=(NSR_DATA_VOLUME_POOL=trade disk backup pool,NSR_SERVER=backupse
rver.cssfintra.com)';

  backup
format 'Trade_full%d_%U'
(tablespace 'SYSTEM'
   ,'TRADE'
   ,'TRADEINDEX'
include current controlfile);

  release channel ch1;
  release channel ch2;
  release channel ch3;
  release channel ch4;
}
aaa[/oracle/scripts]#

数据库应该没问题,一直跑着呢. oracle进程都正常,按照网上文档kill掉rman进程,重新启动legato运行,还是出现以上问题,

作者: 100心 时间: 2010-06-03 22:20
include current controlfile
不要看看。

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)