Posts

Showing posts from 2018

Migration from Oracle 9iR2 (9.2.0.4) database to Oracle 11gR2 (11.2.0.4) with 3 Node Real Application Cluster with ASM and 2 Node RAC DR site on Linux RHEL in Minimum Downtime.

Today i am sharing my experiance of one of the major database migration from oracle 9iR2 single instance to 11gR2 3 Node RAC instances. Existing Environment: --- Customer was using more than 200 mount point for keeping datafiles. --- Single Instance running on RHEL 32 bit Machine. --- Poor performance during peak time. --- No High Avilability Proposed solution: --- 3 Node RAC Instances on primary data centre (RHEL 64 bit) --- 2 Node RAC Instances on DR site (RHEL 64 bit) Before upgrade of Prod instance from 9ir2 to 11gR2 we need to do pre-requisite ============================================================ 1) Created standby database from exxisting 9iR2 2) Syned with 9iR2 primary DB and opened standby DB in READ WRITE mode and Keft Primary (PROD) as it is for backout in case happened. On Oracle 9iR2 DB on RHEL standby side ============================================================  select owner,status,object_type from dba_objects  where owner in('TEST1