RMAN Redundancy
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: RMAN Redundancy

Hybrid View

  1. #1
    Join Date
    Jan 2001
    Posts
    515

    RMAN Redundancy

    I have an RMAN script that keeps two copies of the backupset at all times. I have a space issue at the moment and I can only hold one backupset.

    How do I get RMAN to delete all the backupsets first and then take a backup? Is there something I can do with the REDUNDANCY parameter? It would not let me set it to zero.

    I am in Oracle 9.2.0.3 on Solaris. Here is my current RMAN script.

    CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT = '$BKUPDIR/full_%d_%Y%M%D_%s';
    CONFIGURE CONTROLFILE AUTOBACKUP ON;
    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '$BKUPDIR/cf_%d_%F';
    CONFIGURE SNAPSHOT CONTROLFILE NAME TO '$BKUPDIR/snapcf_@.f';
    CONFIGURE DEFAULT DEVICE TYPE TO DISK;
    CONFIGURE RETENTION POLICY TO REDUNDANCY 1;

    run
    {
    delete noprompt obsolete;
    backup database plus archivelog delete input tag='$TAG';
    }

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    What happens when you do

    RMAN> LIST EXPIRED BACKUPSET;

    RMAN> DELETE EXPIRED BACKUPSET;

    you can also do
    DELETE OBSOLETE REDUNDANCY = 3 --->i see your redundancy is 1 but

    regards
    Hrishy

  3. #3
    Join Date
    Oct 2006
    Posts
    175
    How about dynamically changing the retention policy to recovery windows, lesser than the days of retention before taking the backup, run the backup code, and then change it back to redundancy 1. Just a thought. Please let us know your output.

    Thanks
    gtcol

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