Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

migrating large database without downtime and data loss

860661May 9 2011 — edited May 10 2011

Hi all,
I am planning to migrate a DB of size 1 TB from DB to DB (10g both) by expdp/impdp. I estimate it will take more than 24 hrs. So my DB will be down during migration. My questions are:
1. If I make the source DB accessible to users during migration, after migration can I get the data updated and inserted during migration?
2. If not, how can I minimize the downtime? transportable tablespace is confusing for me. I am familiar with expdp.

I will appreciate any suggestion.
thanks in advance

Selami

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 7 2011

Added on May 9 2011

#general-database-discussions, #migration

3 comments

525 views