RMAN-06091 error
EmJun 29 2007 — edited Aug 16 2007I've searched the forums, but am still not sure what action to take on this. Please see the error in my output, below -- why am I getting this, and is it actually preventing the "cleanup" of my archivelog files?
HERE'S WHAT I ENTERED AS RMAN COMMANDS:
RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT 'd:\DB-BackupS\RMAN\%d_%T-%s.rbk';
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'd:\DB-BackupS\RMAN\%d_%F';
RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 4 DAYS;
RMAN> CONFIGURE BACKUP OPTIMIZATION ON;
RMAN> backup database;
RMAN> delete force noprompt obsolete recovery window of 4 days;
RMAN> delete force noprompt copy of archivelog all completed before 'sysdate-4';
RMAN> crosscheck backup;
RMAN> crosscheck archivelog all;
RMAN> exit
HERE'S THE RESULTS:
Recovery Manager: Release 9.2.0.6.0 - Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
connected to target database: P2KLIVE (DBID=2051172780)
using target database controlfile instead of recovery catalog
RMAN>
old RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT 'd:\DB-BackupS\RMAN\%d_%T-%s.rbk';
new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT 'd:\DB-BackupS\RMAN\%d_%T-%s.rbk';
new RMAN configuration parameters are successfully stored
RMAN>
old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'd:\DB-BackupS\RMAN\%d_%F';
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'd:\DB-BackupS\RMAN\%d_%F';
new RMAN configuration parameters are successfully stored
RMAN>
old RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 4 DAYS;
new RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 4 DAYS;
new RMAN configuration parameters are successfully stored
RMAN>
old RMAN configuration parameters:
CONFIGURE BACKUP OPTIMIZATION ON;
new RMAN configuration parameters:
CONFIGURE BACKUP OPTIMIZATION ON;
new RMAN configuration parameters are successfully stored
RMAN>
Starting backup at 29-JUN-07
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=14 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00004 name=E:\ORACLE\ORADATA\P2KLIVE\P2K_DATA01.DBF
input datafile fno=00005 name=E:\ORACLE\ORADATA\P2KLIVE\P2K_INDX01.DBF
input datafile fno=00008 name=\\HRIS\E$\ORACLE\ORADATA\P2KLIVE\UNDOTBS02.DBF
input datafile fno=00001 name=E:\ORACLE\ORADATA\P2KLIVE\SYSTEM01.DBF
input datafile fno=00007 name=E:\ORACLE\ORADATA\P2KLIVE\XDB01.DBF
input datafile fno=00003 name=E:\ORACLE\ORADATA\P2KLIVE\DRSYS01.DBF
input datafile fno=00006 name=E:\ORACLE\ORADATA\P2KLIVE\TOOLS01.DBF
channel ORA_DISK_1: starting piece 1 at 29-JUN-07
channel ORA_DISK_1: finished piece 1 at 29-JUN-07
piece handle=D:\DB-BACKUPS\RMAN\P2KLIVE_20070629-287.RBK comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:45
Finished backup at 29-JUN-07
Starting Control File and SPFILE Autobackup at 29-JUN-07
piece handle=D:\DB-BACKUPS\RMAN\P2KLIVE_C-2051172780-20070629-05 comment=NONE
Finished Control File and SPFILE Autobackup at 29-JUN-07
RMAN>
using channel ORA_DISK_1
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 244 25-JUN-07
Backup Piece 244 25-JUN-07 D:\DB-BACKUPS\RMAN\P2KLIVE_20070625-257.RBK
Backup Set 245 25-JUN-07
Backup Piece 245 25-JUN-07 D:\DB-BACKUPS\RMAN\P2KLIVE_C-2051172780-20070625-00
Backup Set 248 25-JUN-07
Backup Piece 248 25-JUN-07 BE_85il57nn_1_1
Archive Log 308 25-JUN-07 D:\ORACLE\ORA920\RDBMS\ARC00410.001
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of delete command at 06/29/2007 10:20:13
RMAN-06091: no channel allocated for maintenance (of an appropriate type)
RMAN>
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=14 devtype=DISK
List of Archived Log Copies
Key Thrd Seq S Low Time Name
------- ---- ------- - --------- ----
308 1 410 A 22-JUN-07 D:\ORACLE\ORA920\RDBMS\ARC00410.001
309 1 411 A 25-JUN-07 D:\ORACLE\ORA920\RDBMS\ARC00411.001
deleted archive log
archive log filename=D:\ORACLE\ORA920\RDBMS\ARC00410.001 recid=308 stamp=626171155
deleted archive log
archive log filename=D:\ORACLE\ORA920\RDBMS\ARC00411.001 recid=309 stamp=626171708
Deleted 2 objects
RMAN>
using channel ORA_DISK_1
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\DB-BACKUPS\RMAN\P2KLIVE_20070625-257.RBK recid=244 stamp=626148299
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\DB-BACKUPS\RMAN\P2KLIVE_C-2051172780-20070625-00 recid=245 stamp=626148374
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\DB-BACKUPS\RMAN\P2KLIVE_20070627-265.RBK recid=252 stamp=626321096
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\DB-BACKUPS\RMAN\P2KLIVE_C-2051172780-20070627-00 recid=253 stamp=626321180
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\DB-BACKUPS\RMAN\P2KLIVE_20070627-267.RBK recid=254 stamp=626353277
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\DB-BACKUPS\RMAN\P2KLIVE_C-2051172780-20070627-01 recid=255 stamp=626353363
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\DB-BACKUPS\RMAN\P2KLIVE_20070628-269.RBK recid=256 stamp=626407499
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\DB-BACKUPS\RMAN\P2KLIVE_C-2051172780-20070628-00 recid=257 stamp=626407583
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\DB-BACKUPS\RMAN\P2KLIVE_20070629-275.RBK recid=262 stamp=626493868
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\DB-BACKUPS\RMAN\P2KLIVE_C-2051172780-20070629-00 recid=263 stamp=626493963
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\DB-BACKUPS\RMAN\P2KLIVE_20070629-281.RBK recid=268 stamp=626517547
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\DB-BACKUPS\RMAN\P2KLIVE_C-2051172780-20070629-02 recid=269 stamp=626517652
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\DB-BACKUPS\RMAN\P2KLIVE_20070629-283.RBK recid=270 stamp=626519017
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\DB-BACKUPS\RMAN\P2KLIVE_C-2051172780-20070629-03 recid=271 stamp=626519112
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\DB-BACKUPS\RMAN\P2KLIVE_20070629-285.RBK recid=272 stamp=626519863
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\DB-BACKUPS\RMAN\P2KLIVE_C-2051172780-20070629-04 recid=273 stamp=626519958
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\DB-BACKUPS\RMAN\P2KLIVE_20070629-287.RBK recid=274 stamp=626523108
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\DB-BACKUPS\RMAN\P2KLIVE_C-2051172780-20070629-05 recid=275 stamp=626523214
Crosschecked 18 objects
RMAN>
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=14 devtype=DISK
validation succeeded for archived log
archive log filename=D:\ORACLE\ORA920\RDBMS\ARC00412.001 recid=310 stamp=626449016
validation succeeded for archived log
archive log filename=D:\ORACLE\ORA920\RDBMS\ARC00413.001 recid=311 stamp=626449031
validation succeeded for archived log
archive log filename=D:\ORACLE\ORA920\RDBMS\ARC00414.001 recid=312 stamp=626449097
validation succeeded for archived log
archive log filename=D:\ORACLE\ORA920\RDBMS\ARC00415.001 recid=313 stamp=626449113
validation succeeded for archived log
archive log filename=D:\ORACLE\ORA920\RDBMS\ARC00416.001 recid=314 stamp=626449333
validation succeeded for archived log
archive log filename=D:\ORACLE\ORA920\RDBMS\ARC00417.001 recid=315 stamp=626449434
validation succeeded for archived log
archive log filename=D:\ORACLE\ORA920\RDBMS\ARC00418.001 recid=316 stamp=626449464
validation succeeded for archived log
archive log filename=D:\ORACLE\ORA920\RDBMS\ARC00419.001 recid=317 stamp=626449525
validation succeeded for archived log
archive log filename=D:\ORACLE\ORA920\RDBMS\ARC00420.001 recid=318 stamp=626449551
validation succeeded for archived log
archive log filename=D:\ORACLE\ORA920\RDBMS\ARC00421.001 recid=319 stamp=626449609
validation succeeded for archived log
archive log filename=D:\ORACLE\ORA920\RDBMS\ARC00422.001 recid=320 stamp=626451732
validation succeeded for archived log
archive log filename=D:\ORACLE\ORA920\RDBMS\ARC00423.001 recid=321 stamp=626451741
validation succeeded for archived log
archive log filename=D:\ORACLE\ORA920\RDBMS\ARC00424.001 recid=322 stamp=626451812
validation succeeded for archived log
archive log filename=D:\ORACLE\ORA920\RDBMS\ARC00425.001 recid=323 stamp=626451841
validation succeeded for archived log
archive log filename=D:\ORACLE\ORA920\RDBMS\ARC00426.001 recid=324 stamp=626451885
validation succeeded for archived log
archive log filename=D:\ORACLE\ORA920\RDBMS\ARC00427.001 recid=325 stamp=626451965
validation succeeded for archived log
archive log filename=D:\ORACLE\ORA920\RDBMS\ARC00428.001 recid=326 stamp=626451976
validation succeeded for archived log
archive log filename=D:\ORACLE\ORA920\RDBMS\ARC00429.001 recid=327 stamp=626455769
validation succeeded for archived log
archive log filename=D:\ORACLE\ORA920\RDBMS\ARC00430.001 recid=328 stamp=626463508
validation succeeded for archived log
archive log filename=D:\ORACLE\ORA920\RDBMS\ARC00431.001 recid=329 stamp=626463801
validation succeeded for archived log
archive log filename=D:\ORACLE\ORA920\RDBMS\ARC00432.001 recid=330 stamp=626501782
validation succeeded for archived log
archive log filename=D:\ORACLE\ORA920\RDBMS\ARC00433.001 recid=331 stamp=626501975
Crosschecked 22 objects
RMAN>
Recovery Manager complete.