-
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
-
Yes. provided it was going to be a full import.
Sam
Thanx
Sam
Life is a journey, not a destination!
-
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
-
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!
-
Another idea is replication, I don't know your reqirement
Thanks
Kishore Kumar
-
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
-
use snapshot read-only replication, refresh once a day.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|