Objective: Migration of Production database with Minimal downtime

Hardware and Software:



1. Source Database: AIX-Based Systems (64-bit)

   OS Version: AIX 5.2


   Endrian Format of Source Database: Big


2. Target Database:


   OS Version: Linux 5.6

   Endrian Format of Source Database: Little






Migration Strategy:


• Transportable Tablespace using RMAN

AND

• Oracle Downstream Replication (Schema Level)


Steps Action



1 Create New production database


2 Setup Oracle Stream environment in Source Database


3 Setup Oracle Stream environment in Target Database


4 Setup Heartbeat table in both Source and Target Database


5 Start and Stop Oracle Downstream


6 Verify Transport tablespace prerequisites


7 Create users in Target database


8 Restart Source database in read only mode


9 Export Metadata (for transport tablespace) from source db


10 Convert datafiles to target db’s Endrian format


11 Restart Source Database in normal read/write mode


12 Collect SCN number of Source Database


13 Move backup datafiles and dumpfile to Target database(Linux)


14 Import Dumpfile into Target database


15 Restart Target Database in normal read/write mode


16 Create Roles and Directory


17 Export and Import DBA objects from Source to target


18 Compile invalided objects


19 Setup Schema for downstream


20 Start Stream Process with using source scn (from Step 12)


21 Stop Oracle Stream process when heartbeat value same as source