This discussion is archived
2 Replies Latest reply: Sep 3, 2013 8:36 AM by DBA_Guide RSS

Need best practices PROCESS to schedule RMAN Backups.

DBA_Guide Newbie
Currently Being Moderated

Hi All,

 

I would like a suggestion on the following for RMAN Backups:

 

Details:

Database: - 11gR2, Size 3TB on ASM - DW database.

 

Like suggestions on:

 

1) What kind of backups to schedule - Incremental along with Block backups?

2) Size required to allocate for the Backup Space - Can it be ASM or Disk Space?

3) Anything else - please suggest.

 

Thank you.

  • 1. Re: Need best practices PROCESS to schedule RMAN Backups.
    Hemant K Chitale Oracle ACE
    Currently Being Moderated

    For that size, you might do weekly L0 and daily L1 (differential) backups.  Try to do L1 (cumulative) backups if possible.

     

    Getting the total sizes of Segments (from DBA_SEGMENTS) will give you an approximation for the minimum size.  (Tables/Indexes that have been dropped and are no longer in DBA_SEGMENTS wouldn't appear but the underlying blocks for them if unused by other Tables/Indexes would still be backed up as they'd have been formatted).

    You could run the Backup as a COMPRESSED BACKUPSET to reduce the size.

     

    Whether you want ASM or FileSystem depends on your comfort level.  If you run backups to ASM, you can only use RMAN to backup from ASM to Tape.  However, backups on FileSystem can be copied to tape using any other method (tape backup utility).  Also consider if you want to replicate/copy the backups to other servers and what methods you'd have available.

     

     

    Hemant K Chitale

  • 2. Re: Need best practices PROCESS to schedule RMAN Backups.
    DBA_Guide Newbie
    Currently Being Moderated

    Thank you Hemant, this is very helpful for me - the explanation is clear and much understandable.

     

    Thank you!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points