- 论坛徽章:
- 0
|
采用rman定期备份oracle数据库,日志中最后总报这个错,请问高手什么原因
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of delete command at 02/23/2009 19:08:41
RMAN-06091: no channel allocated for maintenance (of an appropriate type)
RMAN>
released channel: ORA_MAINT_DISK_1
我的备份脚本如下:
#!/usr/bin/ksh
#
# Backup database instance PBANK at incremental level 1
#
export ORACLE_SID=DMCOW01
rman target / catalog rman/rman@RMAND << EOF_RMAN
run {
allocate channel d1 type disk;
allocate channel d2 type disk;
BACKUP
INCREMENTAL LEVEL 1 CUMULATIVE
FILESPERSET 10
FORMAT '/orabakpes02/dbsbackup/incr/incr_%T_%s_%p'
DATABASE;
BACKUP
FILESPERSET 10
MAXSETSIZE 10G
FORMAT '/orabakpes02/dbsbackup/incr/arch_%T_%s_%p'
SKIP INACCESSIBLE
ARCHIVELOG ALL;
release channel d2;
release channel d1;
}
EOF_RMAN
rman target / catalog rman/rman@RMAND << EOF_RMAN
allocate channel for maintenance device type disk;
crosscheck backup;
delete noprompt obsolete recovery window of 30 days;
release channel;
EOF_RMAN
#
请高手指点,谢谢 |
|