Incremental export/import

76425c46-a19e-4509-b28d-b5c0fbb0b433 Apr 11, 2014 3:25 AM

Hi all,

I am migrating from Oracle 8i database on one DB server to Oracle 11g on another DB server. I am planning to use the export/import method.

As our environment is a production manufacturing environment, we want to keep the down time very low.

A normal export of our database takes about 4 hours for us.

Will incremental export/import shorten this time and will it work for me?

Thanks!

1. Re: Incremental export/import

Krishna-Oracle Apr 11, 2014 3:53 AM (in response to 76425c46-a19e-4509-b28d-b5c0fbb0b433)

Incremental export/import will shorten the time.
But remember during incremental backup it will take backup of modified table, not only modified records.
Suppose one row has been added into a table after full backup, then during incremental backup the whole table will be backed up again. It is again time consuming one.

During import first you apply full backup and while applying incremental backup it will delete the table and reimport the table from incremental backup

Thanks,
Krishna
Like Show 0 Likes(0)

Actions
2. Re: Incremental export/import

1011859 Apr 15, 2014 6:46 AM (in response to 76425c46-a19e-4509-b28d-b5c0fbb0b433)

you have to check the Compatibility Matrix for Export And Import Between Different Oracle Versions
Like Show 0 Likes(0)

Actions

Join the world’s largest interactive community dedicated to Oracle technologies.