Migrating DATABASE : Exp and LOGMINER Options

[h.mahmoud]

Hello,

I have to migrate a 9i DATABASE from one platform (HP-UX V1 PARISC) to another platform (HP-UX V3 Itanium) and to upgrade it to 11Gr2.
I know that multiple scenario exist (Ex:Exp/Imp,DataGuard,GoldenGate,Dblink/Direct Load,etc) but i'am interested in another solution and i'am curious to konw if it work.


Scenario:

1-Activate force logging and suplemental logging in the source database.
2-Export the source database SCHEMA in consistent mode and import them in the 11gr2 database.
3-Record the scn of le last user transaction applied before the export.
4-Use LOGMINER to capture all the transaction applied after the export.
5-Stop the source database, applie the captured transaction by logminer and then switch the user to the new database.

I thougt that the down time will be minimal, it will take only the time of reapplieng the comited transaction captured by logminer.


It's feasible to do that or logminer have some limitation ?
It's recomended or difficult to do that ?

Thanks for you help,

PS: I'am not familiar with oracle LOGMINER

[burleson]

Hi Mahmoud,

>> Use LOGMINER to capture all the transaction applied after the export.

This MIGHT work, try it in your test environment and see!

However, expdp/impdp, Data Guard and Logminer were NOT designed to work together.

I would:

1 - Upgrade the database to 11gr2 (on both systems)

2 - Move the data over using CTAS

***********************************************

>> I thougt that the down time will be minimal, it will take only the time of reapplieng the comited transaction captured by logminer.

If downtime is an issue, see here:

http://www.dba-oracle.com/t_migration_error_message_tips.htm

http://www.dba-oracle.com/t_low_downtime_upgrades.htm

http://www.dba-oracle.com/t_mimimizing_dow...se_upgrades.htm