Requesting a 2nd opinion on 10g RMAN backup strategy
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Requesting a 2nd opinion on 10g RMAN backup strategy

Threaded View

  1. #1
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577

    Requesting a 2nd opinion on 10g RMAN backup strategy

    Hi,

    I have a 10G R2 database running on RHL 4.0 AS.

    The flash recovery area is pointing to a windows server on our network having over a Terabyte of storage. This has been mounted using cifs.

    I have the following RMAN script which will take a daily full database backup of our database to the windows shared disk (flash recovery area).

    Code:
    connect target sys/passwd@targetsid
    connect catalog rman/passwd@catsid
    
    CONFIGURE CONTROLFILE AUTOBACKUP ON;
    CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS;
    
    run {
    allocate channel ch1 type disk maxpiecesize=2G;
    backup database plus archivelog;
    BACKUP ARCHIVELOG UNTIL TIME 'SYSDATE-7' delete input;
    
    }
    delete obsolete;
    The strategy is as follows

    1. The backups are taken to the disk and are picked up by tape on a daily basis.
    2. The tapes are recycled every 14 days hence our retention policy is 14 days after which RMAn will delete the backups if it needs to.

    I would really appreciate critical/non critical feedback on this strategy.

    One problem that we have though is that since we are using flash recovery area oracle is doing space management and occupies the space for 14 days backups even though they have been backedup on tape by our network administrator. I know that they have a backup of backupset option but thats not useful for us as I dont manage the tapes. I am looking for a way to have the Flash recovery area only occupy the space for 1 backup but still be able to have the 13 addiional backups in record and restore/recover when the need be.

    Please help.

    Thanks
    Ron
    Last edited by ronnie; 04-24-2006 at 06:40 PM.
    Ronnie
    ronnie_yours@yahoo.com

    You can if you think you can.

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