Backup Using Export
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Backup Using Export

  1. #1
    Join Date
    Oct 2007
    Posts
    1

    Backup Using Export

    Hi, i am using Oracle 8i, and for my class they asked me if it was a really good idea to use as a backup method the export function that oracle uses. I wanna know if you would really recommend using this method as a backup method?

    Thanks in Advance.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    nope

  3. #3
    Join Date
    May 2005
    Location
    AZ, USA
    Posts
    131
    http://download.oracle.com/docs/cd/B....htm#sthref606

    "Logical-level backups, such as exporting database objects like tables or tablespaces, are a useful supplement to physical backups for some purposes. Nevertheless, logical backups cannot protect your entire database. An effective backup strategy must be based on physical-level backups."

  4. #4
    Join Date
    Sep 2007
    Location
    Mexico
    Posts
    19
    Talking about release 8i, export is fine ... but try to restrict access to users in order to get a good picture of data. Yes , it's analogous to taking pictures on the road: the faster you travel, more blur is your photo -> user's transactions will make 'blur' your backup. May use exp parameter CONSISTENT=y to reduce in some extent this effect.

    If you're learning Oracle, my suggestion is a jump to 9i or better 10g (Oracle will put 9i on extended support beginning mid 2008) and getting into RMAN.

  5. #5
    Join Date
    May 2005
    Location
    AZ, USA
    Posts
    131
    "export is fine" for what?

    http://download-west.oracle.com/docs...pst.htm#423496

    "Note that Database exports are not a substitute for whole database backups and cannot provide the same complete recovery advantages that the built-in functionality of Oracle offers."
    Last edited by dbtoo; 10-11-2007 at 11:38 AM. Reason: change comment

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    fine to restore some static tables and pl/sql codes but nothing else

  7. #7
    Join Date
    May 2005
    Location
    AZ, USA
    Posts
    131
    Exactly Pando - my concern was that one junior member may mislead another junior member by their choice of words. In the original post, the question came out of information from a class. I hope that the class would not leave the student with any doubt as to what backup and recovery is.

    http://download-west.oracle.com/docs...tro.htm#423027

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