IMP / EXP
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: IMP / EXP

  1. #1
    Join Date
    Nov 2000
    Posts
    416
    If you have a full export of a Database , and you have a empty barnd new database and you want to import your dump file in this new database, DOES import create all necessary tablespaces, users, and every other things by itself ?

    An ounce of prevention is worth a pound of cure

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Yes. provided it was going to be a full import.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Nov 2000
    Posts
    65

    Post sync primary & secondary db

    Hi,

    Fine, I use the full db export dump, to populate this new (secondary) database.

    Now I want to take it to the next level.
    How do I keep the secondary db in sync with the primary.
    Do daily cumulative db export/import?
    May be this is the NOT suggested ? What do you guys say?

    thank you,
    nk


  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Cummulative would be a good choice if you plan to do things through the exp.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  5. #5
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    Another idea is replication, I don't know your reqirement
    Thanks
    Kishore Kumar

  6. #6
    Join Date
    Nov 2000
    Posts
    65
    Thank you Kishore & sambavan

    my requirement ?
    our backup & recovery strategy is rather limited.
    we do only a daily full db export !

    And I wanted to impove things and at the same time, wanted to set up a secondary db in sync (with the primary), so that it could serve as DSS (run only queries, no dml/ddl).

    It was in the of the light above that I was asking my question.

    thank you,
    nk




  7. #7
    Join Date
    Nov 2000
    Posts
    245

    use snapshot read-only replication, refresh once a day.

  8. #8
    Join Date
    Nov 2000
    Posts
    205
    If this is a production database, I would be a bit hesitant to rely on exp/imp as the only backup method.

    Nirasha
    Nirasha Jaganath

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