请问一个关于RMAN脚本分配通道的问题~！

蜗牛 · 发表于 2010-10-26 06:57:14

脚本如下:
run
{
allocate channel t1 type 'sbt_tape'
parms 'ENV=(NSR_SERVER=BAKSERVER,NSR_DATA_VOLUME_POOL=Default,NSR_CLIENT=crmserver)';
backup full database filesperset 1 format 'full_%d_%u';
CONFIGURE retention policy to recovery window of 7 days;
#release channel t1;
configure controlfile autobackup on;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/data2/oradata/ctlbak/%F';
allocate channel d1 device type disk format '/data1/backup/oradata/%U';
backup database skip inaccessible filesperset 10 plus archivelog filesperset 20 delete all input;
#release channel d1;
#allocate channel a1 for mainaintnance device type disk;
crosscheck backupset;
delete noprompt obsolete;
#release channel a1;
release channel d1;
release channel t1;
}
跑到差不多最后他提示我
channel t1: deleting archive log(s)
archive log filename=/sandata/archive/1_613.dbf recid=621 stamp=732124600
Finished backup at 11-OCT-10
Starting Control File and SPFILE Autobackup at 11-OCT-10
piece handle=c-1909588747-20101011-0a comment=API Version 2.0,MMS Version 4.2.0.0
Finished Control File and SPFILE Autobackup at 11-OCT-10
released channel: t1
released channel: d1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of crosscheck command at 10/11/2010 15:56:48
RMAN-06091: no channel allocated for maintenance (of an appropriate type)
请各位帮忙看看~！谢谢~！

wanenjie · 发表于 2010-10-26 08:11:33

跑到delete noprompt obsolete;这步出错
Backup Set          3738 11-OCT-10
  Backup Piece    3739 11-OCT-10       c-1909588747-20101011-0b
Controlfile Copy    380 20-MAY-08       /testdev/backup/rman/ctl.bak
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of delete command at 10/11/2010 16:54:51
RMAN-06091: no channel allocated for maintenance (of an appropriate type)

duolanshizhe · 发表于 2010-10-26 09:24:52

根据报错信息提示，你没有分配合适的维护channel
请把上面的脚本修改成如下然后尝试
allocate channel for mainaintnance device type disk;
crosscheck backupset;
delete noprompt obsolete;

renxiao2003 · 发表于 2010-10-26 10:02:10

有时间得研究一下RMAN了。最近家里的机器也没有安装ORACLE。不好搞。

wanenjie · 发表于 2010-10-26 10:51:32

改了~！改成这样
run
{
allocate channel t1 type 'sbt_tape'
parms 'ENV=(NSR_SERVER=BAKSERVER,NSR_DATA_VOLUME_POOL=Default,NSR_CLIENT=crmserver)';
backup full database filesperset 1 format 'full_%d_%u';
CONFIGURE retention policy to recovery window of 7 days;
#release channel t1;
configure controlfile autobackup on;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/data2/oradata/ctlbak/%F';
allocate channel d1 device type disk format '/data1/backup/oradata/%U';
backup database skip inaccessible filesperset 10 plus archivelog filesperset 20 delete all input;
#release channel d1;
#allocate channel a1 for mainaintnance device type disk;
#crosscheck backupset;
#delete noprompt obsolete;
#release channel a1;
release channel d1;
release channel t1;
}
allocate channel for mainaintnance device type disk;
crosscheck backupset;
delete noprompt obsolete;

duolanshizhe · 发表于 2010-10-26 11:57:15

修改后应该就可以了吧