Database migration 9.2(sun) to 11.2(AIX)
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)
0