DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: daily backup strategies

  1. #1
    Join Date
    Apr 2008
    Posts
    59

    daily backup strategies

    hi DBA gurus, i've an another question regarding the backup strategies which is followed by DBA's on basis? regarding RMAN or logical backup.. thanks in advance

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    not a logical backup - that would be crazy

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092

  4. #4
    Join Date
    Dec 2008
    Location
    Easton,MA
    Posts
    13
    Quick answer to your question:

    From a database recoverability, business continuity etc., you need a to have the DB in archivelog mode and use either traditional hot/cold and archivelog backups OR Rman online/offline + archivelog backups. This will be backup you use if anything gets corrupted in the database structure (blocks, files, etc.,) or you loose files. This guarantees that you can restore the file/db from the backup and roll-forward and recover the database fully without any loss of data.

    In addition to this, its good practice to have logical backups. For databases that hosts multiple application, this is a good practices for :

    1. Recovering from any user errors (users messing up data by fat-fingering)
    2. Recovering any code/privileges/structures (stored proc, privs, object structures) if code promotion goes bad.
    3. use the logical backup to recover objects/schema's in non-prod environments etc,,


    Its ours standard practice to have logical backup everyday and rman backup weekly with archivelog backups (based on FS full threshold OR no. of archives cut). We do this for ALL db's that are less than 200-300GB in size. Any db with size higher than that, we skip data exports and take only empty exports to capture only structure/code/privs.

    Regards,

    Shaji
    Shaji
    DBA(oracle,sqlserver,hyperion essbase,peoplesoft).

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