Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

RMAN-06091 error

EmJun 29 2007 — edited Aug 16 2007
I'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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 13 2007
Added on Jun 29 2007
11 comments
5,709 views