RMAN: delete obsolete no prompt issue
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: RMAN: delete obsolete no prompt issue

  1. #1
    Join Date
    Mar 2006
    Posts
    176

    RMAN: delete obsolete no prompt issue

    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.

  2. #2
    Join Date
    Feb 2006
    Posts
    37
    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;

  3. #3
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,458

    Cool


    Did you issue:
    Code:
    allocate channel for maintenance type disk;

    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  4. #4
    Join Date
    Mar 2006
    Posts
    176
    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"

    Code:
    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.

  5. #5
    Join Date
    Feb 2006
    Posts
    37
    Add this:

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

  6. #6
    Join Date
    Apr 2006
    Posts
    377
    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:

    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;
        }

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width