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

Thread: backup question

  1. #1
    Join Date
    Jun 2000

    Would you recommend a backup plan for a production database to include only backup of datafiles and control files, and no export files.

    Is there any oracle site with a list a recommended backup plans based on the organization's needs.

    Thanks in advance!

  2. #2
    Join Date
    Apr 2001

    Backup Plans

    Well, I sure wouldn't recommend a backup plan that relyed on a database export only. An export is an enhancement to a backup plan, but not a main pin. Velpuri wrote the Oracle Press Backup and Recovery books and shows various options for planning a successful backup and recovery plan. I would suggest that you look into these books for some ideas.

    As an aside, I use export in my backup plans, but only for single table recovery when I don't have to worry about having the table with up to date data. If it's a static table I can restore from the previous nights export and it's faster than restoring the entire database. But then again it depends on why the database needs recovery in the first place. There is no one correct answer, it depends on your needs.
    Eric Hanson

    There are 10 types of people in the world:

    Those who understand binary and those who don't!

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.