Results 1 to 9 of 9

Thread: Oracle 9i. Full backup and restore with imp/exp

  1. #1
    Join Date
    Sep 2007
    Posts
    3

    Oracle 9i. Full backup and restore with imp/exp

    Hello folks.


    I am currently on a system using Oracle 9i. We don't have RMAN setup, and im curious as to what exactly Im going to have to do to perform an import/export to fully backup and restore a schema.

    Ive been doing my exp with FULL=Y DIRECT=Y CONSISTENT=Y

    what is NOT included for a schema in this export? Users/roles/etc??

    If I have a backup from say 5 minutes ago and I want to completely reload the dmp file, what do I have to drop first, just the tables, or can I blow away the entire schema/tablespace and reload from the dmp?

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Export does not include sys schema all other things are included.

  3. #3
    Join Date
    Sep 2007
    Posts
    3
    If I create a fresh db with the proper settings and then do the full imp, am I missing anything?

  4. #4
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    No, you should get all the users and objects.

  5. #5
    Join Date
    Sep 2007
    Posts
    3
    Thanks a bunch.

    I'm used to working primarily with mysql and mssql and its a bit of adjusting for me.

  6. #6
    Join Date
    Oct 2005
    Posts
    2,557
    If a full=y export does not include the sys schema, then why does the Utilities documentation state the following:

    Points to Consider for Full Database Exports and Imports

    A full database export and import can be a good way to replicate or clean up a database. However, to avoid problems be sure to keep the following points in mind:

    * A full export does not export triggers owned by schema SYS. You must manually re-create SYS triggers either before or after the full import. Oracle recommends that you re-create them after the import in case they define actions that would impede progress of the import.

  7. #7
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    I have never seen full=y exporting any sys objects.

    Could you please post the link for the section of the document.

  8. #8
    Join Date
    Oct 2005
    Posts
    2,557
    At 10g Utilities.http://download.oracle.com/docs/cd/B...p.htm#i1023130 I was curious about the sys reference there because when doing a full, I've always done it as system and never gave sys a second thought. Part of the reason why is not doing things as sys unless you absolutely have to.

    SYSDBA is used internally and has specialized functions; its behavior is not the same as for generalized users. Therefore, you should not typically need to invoke Export or Import as SYSDBA, except in the following situations:

    *At the request of Oracle technical support
    *When importing a transportable tablespace set

  9. #9
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Thanks, I was looking in 9i documentation.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •