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

Thread: Value of having a db export

  1. #1
    Join Date
    Jan 2001
    Posts
    216

    Value of having a db export

    I know db export gives us a logical backup of the database. But is it really necessary to regularly export backup the database (like once a week) in addition to hot backups? If the dump files are huge (>10G), it will take forever to use them to restore. In what scenarios are export backups useful?

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    exports are not a backup tool - period

  3. #3
    Join Date
    Jan 2001
    Posts
    216
    In my company, the previous dba had setup export backups for once a week in addition to hot backups everyday. Agree with you that export will not provide us any value, but I just dont want to make the change and remove the backup job without careful consideration. Please advise.

  4. #4
    Join Date
    May 2005
    Location
    AZ, USA
    Posts
    131
    We've had a situation where there was data deleted from tables (version 7.3), with data being added every day. The users were able to restore a copy of a table from the export to a different schema, determine the deltas and restore the data.
    It may be beneficial for instances not in archive log mode, that is to say, development or oracle 7.3. Databases in archivelog mode can use logminer (above version 8).

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    export is a complementary tool to a backup strategy

    for example it's useful in environments where tons of PL/SQL is used

  6. #6
    Join Date
    Jan 2001
    Posts
    216
    Thank you all. Then I guess it doesnt hurt to leave it in there... just in case, you never know..

    Thanks again!

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