RMAN: delete obsolete no prompt issue

[matthew00]

Hi all,

part of of my RMAN backup script, I have set "delete FORCE noprompt obsolete" , but I have the errors on the log file:

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 7 days
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 1992 29-MAR-06
Backup Piece 2013 29-MAR-06 C:\BACKUP\FULL\TESTDF_TEST_01HF67LJ_1_1
Backup Set 1994 30-MAR-06
Backup Piece 2015 30-MAR-06 C:\BACKUP\FULL\TESTDF_TEST_04HF8BOU_1_1
Backup Set 1995 30-MAR-06
Backup Piece 2016 30-MAR-06 C:\BACKUP\FULL\TESTDF_TEST_05HF8CGV_1_1
Backup Set 1996 30-MAR-06
Backup Piece 2017 30-MAR-06 C:\BACKUP\FULL\TESTCF_TEST_C-90972527-20060330-00
Backup Set 1997 31-MAR-06
Backup Piece 2018 31-MAR-06 C:\BACKUP\FULL\TESTDF_TEST_07HFC2HD_1_1
Backup Set 1998 31-MAR-06
Backup Piece 2019 31-MAR-06 C:\BACKUP\FULL\TESTDF_TEST_08HFC2HG_1_1
Backup Set 1999 31-MAR-06
Backup Piece 2020 31-MAR-06 C:\BACKUP\FULL\TESTDF_TEST_09HFC3JG_1_1
Backup Set 2000 31-MAR-06
Backup Piece 2021 31-MAR-06 C:\BACKUP\FULL\TESTCF_TEST_C-90972527-20060331-00
Backup Set 2001 03-APR-06
Backup Piece 2022 03-APR-06 C:\BACKUP\DIFFERENTIAL\TESTDF_TEST_0BHFJVLF_1_1
Backup Set 2002 03-APR-06
Backup Piece 2023 03-APR-06 C:\BACKUP\DIFFERENTIAL\TESTDF_TEST_0CHFJVLJ_1_1
Backup Set 2003 03-APR-06
Backup Piece 2024 03-APR-06 C:\BACKUP\DIFFERENTIAL\TESTDF_TEST_0DHFK05O_1_1
Backup Set 2004 03-APR-06
Backup Piece 2025 03-APR-06 C:\BACKUP\DIFFERENTIAL\TESTCF_TEST_C-90972527-20060403-00
Backup Set 2005 04-APR-06
Backup Piece 2026 04-APR-06 C:\BACKUP\DIFFERENTIAL\TESTDF_TEST_0FHFMK1F_1_1
Backup Set 2006 04-APR-06
Backup Piece 2027 04-APR-06 C:\BACKUP\DIFFERENTIAL\TESTDF_TEST_0GHFMK1K_1_1
Backup Set 2007 04-APR-06
Backup Piece 2028 04-APR-06 C:\BACKUP\DIFFERENTIAL\TESTDF_TEST_0HHFMKHP_1_1
Backup Set 2008 04-APR-06
Backup Piece 2029 04-APR-06 C:\BACKUP\DIFFERENTIAL\TESTCF_TEST_C-90972527-20060404-00
Backup Set 2009 05-APR-06
Backup Piece 2030 05-APR-06 C:\BACKUP\DIFFERENTIAL\TESTDF_TEST_0JHFP8DG_1_1
Backup Set 2010 05-APR-06
Backup Piece 2031 05-APR-06 C:\BACKUP\DIFFERENTIAL\TESTDF_TEST_0KHFP8DK_1_1
Backup Set 2011 05-APR-06
Backup Piece 2032 05-APR-06 C:\BACKUP\DIFFERENTIAL\TESTDF_TEST_0LHFP8RU_1_1
Backup Set 2012 05-APR-06
Backup Piece 2033 05-APR-06 C:\BACKUP\DIFFERENTIAL\TESTCF_TEST_C-90972527-20060405-00
Backup Set 2305 06-APR-06
Backup Piece 2306 06-APR-06 C:\BACKUP\FULL\TESTDF_TEST_0NHFRBKR_1_1
Backup Set 13948 06-APR-06
Backup Piece 13949 06-APR-06 C:\BACKUP\FULL\TESTDF_TEST_0OHFRBKV_1_1
Backup Set 14006 06-APR-06
Backup Piece 14007 06-APR-06 C:\BACKUP\FULL\TESTDF_TEST_0PHFRCB1_1_1
Backup Set 15877 06-APR-06
Backup Piece 15878 06-APR-06 C:\BACKUP\FULL\TESTCF_TEST_C-90972527-20060406-00
Backup Set 25989 06-APR-06
Backup Piece 25990 06-APR-06 C:\BACKUP\FULL\TESTDF_TEST_0RHFRENG_1_1
Backup Set 26106 06-APR-06
Backup Piece 26107 06-APR-06 C:\BACKUP\FULL\TESTDF_TEST_0SHFRENI_1_1
Backup Set 26161 06-APR-06
Backup Piece 26162 06-APR-06 C:\BACKUP\FULL\TESTDF_TEST_0THFRFT9_1_1
Backup Set 26165 06-APR-06
Backup Piece 26166 06-APR-06 C:\BACKUP\FULL\TESTCF_TEST_C-90972527-20060406-01
Backup Set 53104 07-APR-06
Backup Piece 53105 07-APR-06 C:\BACKUP\FULL\TESTDF_TEST_0VHFUH5D_1_1
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of delete command on default channel at 04/17/2006 08:37:49
ORA-19569: no device is allocated to this session

Recovery Manager complete.

all of the backup files does exist and I don't know why RMAN think there are no devices to this backup session which I don't understand.

[CENSUSDBA]

Is your device allocated anywhere within the script?

If not, try this:

configure device type 'ZZZZ' clear;
allocate channel c1 device type 'ZZZZ' PARMS="ZZZZZ"
connect 'zzz/zzz' rate=2m;

[LKBrwn_DBA]

Did you issue:

allocate channel for maintenance type disk;

[matthew00]

Lk_brown,

thanks for replying back, I do have "configure" set in my backup script, the reason being b/c we want to seperate FULL and DIFFERENTIAL into seperate folder on the bakcup so we can move them to tape. below is what I have"

run {
	CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'C:\BACKUP\FULL\TESTCF_TEST_%F';
     	allocate channel c1 device type disk format 'C:\BACKUP\FULL\TESTDF_TEST_%U';
      	backup INCREMENTAL level=0 database plus archivelog delete input;
	delete FORCE noprompt obsolete;
    }

Please advie if you see better method.

[CENSUSDBA]

Add this:

allocate channel c1 device type disk;
allocate channel for maintenance type disk;
release channel c1;

[ebrian]

A maintenance channel is not required when DELETE is used with a file that is disk-only. I would try adding a release channel c1; in the code:

{
	CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'C:\BACKUP\FULL\TESTCF_TEST_%F';
     	allocate channel c1 device type disk format 'C:\BACKUP\FULL\TESTDF_TEST_%U';
      	backup INCREMENTAL level=0 database plus archivelog delete input;
	release channel c1;
	delete FORCE noprompt obsolete;
    }