1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Oracle Backup Best Practices

Discussion in 'Server Administration and Options' started by Arju, Oct 9, 2008.

  1. Arju

    Arju Forum Expert

    Messages:
    107
    Likes Received:
    5
    Trophy Points:
    240
    Location:
    Bangladesh
    Planning a good Backup Strategy

    Backup of your Oracle Database can be taken through two ways.

    1. Through Recovery Manager
    2. User Managed Backup​

    Whatever the ways you take backup your backup must satisfy its goal. Backup is not something just to keep in a shelf, It must ensure the minimal downtime to recover database in case if a failure happens to the database.

    So what are the considerations for a good backup strategy?

    A good backup strategy must satisfy the following scenarios or questions. Based on the questions below you should determine your backup strategy.

    1. If some records are wrongly deleted or updated from one or more tables then how quickly you can get back your data.

    2. If someone drops any table or drops any database objects then how to recover that.

    3. How we will take a backup so that it ensure minimal recovery time if the dba mistakenly drops any tablespace or datafile.

    4. How will backup plan be so that if one of your disks containing datafiles/ online redo log files/ controlfiles /archived redo log files gets corrupted.

    5. If data block corruption takes place in a table then how you will repair that? Your backup strategy should be such that it can achieve a repair.

    6. If your entire database gets corrupted then can you perform recovery of the database? Does your backup strategy satisfy that?

    7. How you will perform recovery if some physical disaster happens like an earthquake and everything of the server is lost. Does you backup strategy support recovering of entire data?

    8. While deciding your backup strategy have you thought about hardware costs, amount of storage disk, the total involved persons to take the backup.

    9. Is your backup documented and automated? If you are absent during a failure, then can someone else recover from the failure.

    Based on the answer to these questions you should plan how your backup strategy will be.
     
  2. sameer

    sameer Forum Advisor

    Messages:
    105
    Likes Received:
    6
    Trophy Points:
    240
    Hi arju, very decisive questions for backup strategy... can u also provide some examples of what some good backup strategies would be?

    Thanks in advance...
     
  3. Arju

    Arju Forum Expert

    Messages:
    107
    Likes Received:
    5
    Trophy Points:
    240
    Location:
    Bangladesh
    Yes, I will give a detail of this how you will take backup to satisfy all requirements.