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.
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