免费注册 查看新帖 |

Chinaunix

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

求救:legato备份失败问题. [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2010-06-02 18:59 |只看该作者 |倒序浏览
利用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, 下载次数: 30)

1.GIF

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

3_报错信息.GIF

论坛徽章:
0
2 [报告]
发表于 2010-06-02 19:05 |只看该作者
还有legato怎么在图像界面下做一个全备份,我找不到该按钮。

论坛徽章:
3
CU十二周年纪念徽章
日期:2013-10-24 15:41:34IT运维版块每日发帖之星
日期:2015-09-04 06:20:00数据库技术版块每日发帖之星
日期:2015-11-24 06:20:00
3 [报告]
发表于 2010-06-02 19:11 |只看该作者
无法备份控制文件。

脚本贴出来?

论坛徽章:
0
4 [报告]
发表于 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.

论坛徽章:
3
CU十二周年纪念徽章
日期:2013-10-24 15:41:34IT运维版块每日发帖之星
日期:2015-09-04 06:20:00数据库技术版块每日发帖之星
日期:2015-11-24 06:20:00
5 [报告]
发表于 2010-06-02 19:22 |只看该作者
不是日志啊, 是原始脚本。
你现在是无法 SNAPSHOT CONTROLFILE 。要看你脚步里是否触发了这个动作。
还是系统设置每次备份做这个动作。

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

论坛徽章:
0
6 [报告]
发表于 2010-06-02 19:29 |只看该作者
下班回来了。明天一早把脚本搞下来,给你看看。好像其他机器都一样的脚本,都能执行。

论坛徽章:
3
CU十二周年纪念徽章
日期:2013-10-24 15:41:34IT运维版块每日发帖之星
日期:2015-09-04 06:20:00数据库技术版块每日发帖之星
日期:2015-11-24 06:20:00
7 [报告]
发表于 2010-06-02 20:13 |只看该作者
可以的话把你这个数据库重启下嘿嘿。

论坛徽章:
0
8 [报告]
发表于 2010-06-02 21:35 |只看该作者
好的。谢谢

论坛徽章:
1
荣誉版主
日期:2011-11-23 16:44:17
9 [报告]
发表于 2010-06-03 01:15 |只看该作者
有一次备份挂掉了,找找第一次备份失败的信息

找dba查查关于rman的session

论坛徽章:
10
处女座
日期:2015-01-22 16:08:50技术图书徽章
日期:2018-09-13 11:25:52技术图书徽章
日期:2018-09-13 11:25:45技术图书徽章
日期:2018-09-13 11:25:37技术图书徽章
日期:2018-09-13 11:25:29黑曼巴
日期:2018-06-04 09:03:192017金鸡报晓
日期:2017-01-10 15:19:56极客徽章
日期:2016-12-07 14:03:402015年迎新春徽章
日期:2015-03-04 09:50:28技术图书徽章
日期:2018-09-13 11:26:01
10 [报告]
发表于 2010-06-03 09:10 |只看该作者
怀疑是DB的问题
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

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

清除 Cookies - ChinaUnix - Archiver - WAP - TOP