please help to ******** some concepts about Oracle Export/Import
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: please help to ******** some concepts about Oracle Export/Import

  1. #1
    Join Date
    Jul 2002
    Location
    Taiwan
    Posts
    9

    please help to ******** some concepts about Oracle Export/Import

    Hi, all:
    could you please kindly help me to ******** the following concepts about Oracle Export/Import:
    1. "Oracle Export can be done while the exported DB is open.
    Therefore, Oracle Export can be used as an alternative On-line Hot backup"
    Is this correct??
    2. When using Oracle Export to export the "Full DB", instead of export to one big .dmp file,
    how can we export to several smaller .dmp files with the same size (ex:1GB each)??
    3. " in a DB with inconsistant Database files, we can export the entire DB and then import it back. Oracle will then see these Database files as consistant"
    Is this true?? and how come after export and import Oracle will treat them as consistant??

    thank you very very much for your help!!

    wayne

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    1. export can be done when db is open, itīs not an alternative backup method
    2. look export filesize parameter, or split command if you are using linux/unix
    3. No, because export is not a proper backup method

  3. #3
    Join Date
    Jan 2004
    Posts
    3
    1. "Oracle Export can be done while the exported DB is open.
    Therefore, Oracle Export can be used as an alternative On-line Hot backup"
    Is this correct??

    >> NO. Oracle Provides logical and physical backup mode. Export belong to the logical back and the hot backup belong to Physical one.
    Export can not be considered as alternative to the physical backup because

    1. incase of your db crash u will have to recreate the database
    2. time take to import is much higher than that of hot backup.
    3. U can not go for point in time recovery.

    When using Oracle Export to export the "Full DB", instead of export to one big .dmp file,
    how can we export to several smaller .dmp files with the same size (ex:1GB each)??

    >> u can use FILESIZ parameter to restrict this

    3. " in a DB with inconsistant Database files, we can export the entire DB and then import it back. Oracle will then see these Database files as consistant"
    Is this true?? and how come after export and import Oracle will treat them as consistant??

    >> NO. This is not True

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