GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Database migration 9.2(sun) to 11.2(AIX)

edited Aug 16, 2013 7:24AM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered
Dear Experts, Need your advise, We've to migrate  data(3 TB) from 9.2 2-node rac to 11.2 rac 
9.2 rac currently has a standby database(standalone)
Following is my approach(summarized) :
1.Do necessary setup including installation in 9.2 and 11.2 servers.
2.Identify tables,enable suppl logging, etc
3.Start extract on node1 of 9.2 rac
4.Startup datapump extract on node1 o 9.2 rac
5.Open 9.2standby databae in RO mode
6.Select first_change# next_change# from v$archived_log where sequence#= <last al sequence applied to standby db>
7.Export tables,schemas from standby db
8.Import dmp ( from step 7) into 11.2
9.Start replicat in 11.2 astscn <next_change#>( from step 6)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center