Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> Migrating DATABASE : Exp and LOGMINER
h.mahmoud
post Jun 22 2012, 03:19 AM
Post #1


Newbie
*

Group: Members
Posts: 1
Joined: 8-May 12
Member No.: 47,181



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

Go to the top of the page
 
+Quote Post
burleson
post Jun 22 2012, 08:22 AM
Post #2


Advanced Member
***

Group: Members
Posts: 11,335
Joined: 26-January 04
Member No.: 13



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


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 31st July 2014 - 08:39 PM