ITPUB??ì3
新一届的微软MVP评选已经开始,欢迎各位推荐!
ITPUB论坛 » Oracle专题深入讨论 » rman备份时报错,请高手指点

标题: rman备份时报错,请高手指点
离线 xcsars
初级会员



精华贴数 0
个人空间 0
技术积分 225 (8520)
社区积分 7 (13482)
注册日期 2007-9-28
论坛徽章:0
      
      

发表于 2008-5-23 11:00 
rman备份时报错,请高手指点

1、我的平台 rhel4u4 上装的9204
2、我的脚本,

rman nocatalog target / log=/opt/rmanbak/rmanlog/backupall_`date +"%Y%m%d%H%M%S"`.log<<EOF
run
{
allocate channel ch1 device type disk;
allocate channel ch2 device type disk;
allocate channel ch3 device type disk;
allocate channel ch4 device type disk;
sql 'alter system archive log current';
backup database format '/opt/rmanbak/dbbak/db_%d_%T_%U';
sql 'alter system archive log current';
backup archivelog all format '/opt/rmanbak/arcbak/arc_%T_%s' delete all input;
backup current controlfile format '/opt/rmanbak/dbbak/ctl_%s_%p_%T';
crosscheck backup;
crosscheck archivelog all;
report obsolete;
delete noprompt obsolete;
release channel ch1;
release channel ch2;
release channel ch3;
release channel ch4;
}
EOF


3、日志文件里面的信息

Recovery Manager: Release 9.2.0.4.0 - Production

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

connected to target database: ORADB (DBID=2407010394)
using target database controlfile instead of recovery catalog

RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20>
allocated channel: ch1
channel ch1: sid=17 devtype=DISK

allocated channel: ch2
channel ch2: sid=12 devtype=DISK

allocated channel: ch3
channel ch3: sid=16 devtype=DISK

allocated channel: ch4
channel ch4: sid=22 devtype=DISK

sql statement: alter system archive log current

Starting backup at 23-MAY-08
channel ch1: starting full datafile backupset
channel ch1: specifying datafile(s) in backupset
input datafile fno=00010 name=/opt/ora9/oradata/oradb/xdb01.dbf
input datafile fno=00006 name=/opt/ora9/oradata/oradb/indx01.dbf
input datafile fno=00009 name=/opt/ora9/oradata/oradb/users01.dbf
channel ch1: starting piece 1 at 23-MAY-08
channel ch2: starting full datafile backupset
channel ch2: specifying datafile(s) in backupset
input datafile fno=00005 name=/opt/ora9/oradata/oradb/example01.dbf
input datafile fno=00003 name=/opt/ora9/oradata/oradb/cwmlite01.dbf
input datafile fno=00004 name=/opt/ora9/oradata/oradb/drsys01.dbf
channel ch2: starting piece 1 at 23-MAY-08
channel ch3: starting full datafile backupset
channel ch3: specifying datafile(s) in backupset
input datafile fno=00002 name=/opt/ora9/oradata/oradb/undotbs01.dbf
input datafile fno=00007 name=/opt/ora9/oradata/oradb/odm01.dbf
input datafile fno=00008 name=/opt/ora9/oradata/oradb/tools01.dbf
channel ch3: starting piece 1 at 23-MAY-08
channel ch4: starting full datafile backupset
channel ch4: specifying datafile(s) in backupset
input datafile fno=00001 name=/opt/ora9/oradata/oradb/system01.dbf
channel ch4: starting piece 1 at 23-MAY-08
channel ch1: finished piece 1 at 23-MAY-08
piece handle=/opt/rmanbak/dbbak/db_ORADB_20080523_4tjh39md_1_1 comment=NONE
channel ch1: backup set complete, elapsed time: 00:00:08
channel ch2: finished piece 1 at 23-MAY-08
piece handle=/opt/rmanbak/dbbak/db_ORADB_20080523_4ujh39md_1_1 comment=NONE
channel ch2: backup set complete, elapsed time: 00:00:33
channel ch3: finished piece 1 at 23-MAY-08
piece handle=/opt/rmanbak/dbbak/db_ORADB_20080523_4vjh39me_1_1 comment=NONE
channel ch3: backup set complete, elapsed time: 00:00:57
channel ch4: finished piece 1 at 23-MAY-08
piece handle=/opt/rmanbak/dbbak/db_ORADB_20080523_50jh39me_1_1 comment=NONE
channel ch4: backup set complete, elapsed time: 00:01:04
Finished backup at 23-MAY-08

Starting Control File and SPFILE Autobackup at 23-MAY-08
piece handle=/opt/rmanbak/autoctlbak/c-2407010394-20080523-0a comment=NONE
Finished Control File and SPFILE Autobackup at 23-MAY-08

sql statement: alter system archive log current

Starting backup at 23-MAY-08
current log archived
channel ch1: starting archive log backupset
channel ch1: specifying archive log(s) in backup set
input archive log thread=1 sequence=59 recid=59 stamp=655468237
channel ch1: starting piece 1 at 23-MAY-08
channel ch2: starting archive log backupset
channel ch2: specifying archive log(s) in backup set
input archive log thread=1 sequence=60 recid=60 stamp=655468305
channel ch2: starting piece 1 at 23-MAY-08
channel ch3: starting archive log backupset
channel ch3: specifying archive log(s) in backup set
input archive log thread=1 sequence=61 recid=61 stamp=655468305
channel ch3: starting piece 1 at 23-MAY-08
channel ch1: finished piece 1 at 23-MAY-08
piece handle=/opt/rmanbak/arcbak/arc_20080523_162 comment=NONE
channel ch1: backup set complete, elapsed time: 00:00:02
channel ch1: deleting archive log(s)
archive log filename=/opt/ora9/oradata/oradb/archive/1_59.dbf recid=59 stamp=655468237
channel ch2: finished piece 1 at 23-MAY-08
piece handle=/opt/rmanbak/arcbak/arc_20080523_163 comment=NONE
channel ch2: backup set complete, elapsed time: 00:00:02
channel ch2: deleting archive log(s)
archive log filename=/opt/ora9/oradata/oradb/archive/1_60.dbf recid=60 stamp=655468305
channel ch3: finished piece 1 at 23-MAY-08
piece handle=/opt/rmanbak/arcbak/arc_20080523_164 comment=NONE
channel ch3: backup set complete, elapsed time: 00:00:02
channel ch3: deleting archive log(s)
archive log filename=/opt/ora9/oradata/oradb/archive/1_61.dbf recid=61 stamp=655468305
Finished backup at 23-MAY-08

Starting backup at 23-MAY-08
channel ch1: starting full datafile backupset
channel ch1: specifying datafile(s) in backupset
including current controlfile in backupset
channel ch1: starting piece 1 at 23-MAY-08
channel ch1: finished piece 1 at 23-MAY-08
piece handle=/opt/rmanbak/dbbak/ctl_165_1_20080523 comment=NONE
channel ch1: backup set complete, elapsed time: 00:00:01
Finished backup at 23-MAY-08

Starting Control File and SPFILE Autobackup at 23-MAY-08
piece handle=/opt/rmanbak/autoctlbak/c-2407010394-20080523-0b comment=NONE
Finished Control File and SPFILE Autobackup at 23-MAY-08

released channel: ch1
released channel: ch4
released channel: ch2
released channel: ch3
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of crosscheck command at 05/23/2008 10:31:50
RMAN-06091: no channel allocated for maintenance (of an appropriate type)

RMAN>

Recovery Manager complete.


只看该作者    顶部
离线 xcsars
初级会员



精华贴数 0
个人空间 0
技术积分 225 (8520)
社区积分 7 (13482)
注册日期 2007-9-28
论坛徽章:0
      
      

发表于 2008-5-23 11:11 
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of crosscheck command at 05/23/2008 10:31:50
RMAN-06091: no channel allocated for maintenance (of an appropriate type)

日志后面抱了这一堆错误。
不分配管道的时候可以正常运行


只看该作者    顶部
离线 xcsars
初级会员



精华贴数 0
个人空间 0
技术积分 225 (8520)
社区积分 7 (13482)
注册日期 2007-9-28
论坛徽章:0
      
      

发表于 2008-5-23 11:13 
分配管道的时候只要在脚本中删除下面的语句也可以正常运行:
crosscheck backup;
crosscheck archivelog all;
report obsolete;
delete noprompt obsolete;


所以我怀疑是crosscheck引起的,但是问题出在哪呢?


只看该作者    顶部
离线 xcsars
初级会员



精华贴数 0
个人空间 0
技术积分 225 (8520)
社区积分 7 (13482)
注册日期 2007-9-28
论坛徽章:0
      
      

发表于 2008-6-2 13:15 
没有人回答啊


只看该作者    顶部
离线 randylin2006
踏实做事,老实做人


来自 杭州
精华贴数 0
个人空间 0
技术积分 2016 (793)
社区积分 21 (7459)
注册日期 2007-3-13
论坛徽章:2
授权会员ITPUB新首页上线纪念徽章    
      

发表于 2008-6-2 14:27 
crosscheck backup;
crosscheck archivelog all;
report obsolete;
delete noprompt obsolete

执行这些的时候只能用单个channel,这些命令是没有办法在多个channel情况下执行的!


__________________
不要停止脚步,不断学习研究是生存的基础!
我的邮箱  
JLcomputer  OraFaq  AskTom

只看该作者    顶部
离线 randylin2006
踏实做事,老实做人


来自 杭州
精华贴数 0
个人空间 0
技术积分 2016 (793)
社区积分 21 (7459)
注册日期 2007-3-13
论坛徽章:2
授权会员ITPUB新首页上线纪念徽章    
      

发表于 2008-6-2 14:29 
你可以写成这样:
rman nocatalog target / log=/opt/rmanbak/rmanlog/backupall_`date +"%Y%m%d%H%M%S"`.log<<EOF
run
{
allocate channel ch1 device type disk;
allocate channel ch2 device type disk;
allocate channel ch3 device type disk;
allocate channel ch4 device type disk;
sql 'alter system archive log current';
backup database format '/opt/rmanbak/dbbak/db_%d_%T_%U';
sql 'alter system archive log current';
backup archivelog all format '/opt/rmanbak/arcbak/arc_%T_%s' delete all input;
backup current controlfile format '/opt/rmanbak/dbbak/ctl_%s_%p_%T';
release channel ch1;
release channel ch2;
release channel ch3;
release channel ch4;
crosscheck backup;
crosscheck archivelog all;
report obsolete;
delete noprompt obsolete;

}
EOF


__________________
不要停止脚步,不断学习研究是生存的基础!
我的邮箱  
JLcomputer  OraFaq  AskTom

只看该作者    顶部
离线 xcsars
初级会员



精华贴数 0
个人空间 0
技术积分 225 (8520)
社区积分 7 (13482)
注册日期 2007-9-28
论坛徽章:0
      
      

发表于 2008-6-3 09:30 
回复 #6 randylin2006 的帖子

多谢 达人,这是个解决的好办法


只看该作者    顶部
离线 mang003
黄叶



精华贴数 0
个人空间 0
技术积分 835 (2266)
社区积分 2 (29838)
注册日期 2006-9-12
论坛徽章:1
授权会员     
      

发表于 2008-6-4 17:21 
以前没有注意过这个
今天又学了点

下班后请大家吃饭


__________________
生活有时候就像一块板砖拍向你的脑袋,请不要丧失信心,提起精神继续……
只看该作者    顶部
离线 zerocool88888888



精华贴数 0
个人空间 1076
技术积分 314 (6279)
社区积分 0 (1750335)
注册日期 2008-4-10
论坛徽章:0
      
      

发表于 2008-6-7 16:00 
如果CHANGE, CROSSCHECK, DELETE执行的是磁盘操作(DISK),不必手工分配维护同道(maintenance channel),以为ORACLE已经预配置了维护通道


只看该作者    顶部
离线 xcsars
初级会员



精华贴数 0
个人空间 0
技术积分 225 (8520)
社区积分 7 (13482)
注册日期 2007-9-28
论坛徽章:0
      
      

发表于 2008-6-10 11:17 
回复 #8 mang003 的帖子

我也是偶然发现的,在10g上试的时候没有问题,在9i上死活都过不去。 照 zerocool88888888 的理解,那10g没有出现过问题呢?难道10g和9i的rman管理机制上有变化。


只看该作者    顶部
相关内容


CopyRight 1999-2006 itpub.net All Right Reserved.
北京皓辰广域网络信息技术有限公司. 版权所有
E-mail:Webmaster@itpub.net
京ICP证:010037号 联系我们 法律顾问