Pages

Search This Blog ...

Friday, April 1, 2016

Migrating Oracle Single Instance to RAC in Oracle 11g R2

In this tutorial i am show you How to Convert oracle single instance to multipal instance [ RAC ]

You can convert single to multipal instance through may way like
  1.  DBCA
  2. IMPORT/EXPORT 
  3.  Manual
  4.  Streams and Datapump
  5. Grid Control
  6. RConfig  and some more..
Here i am show you 1st one that is DBCA
  It's some steps as given below
  1. Connect with your running database as a sys user with sysdba privileges .
  2. Start your database [ If your database is close ].
  3. Take a database backup. [ Because of your doing convert your database single instance to multipal instance in this time may be resize any some failure at that time it will be helpful to doing a restore operation and come back ].
  4. Start DBCA.
  5. Then Create a template of your current running database.
    • Start DBCA.
    • Select 3rd option that is Oracle Single Instance Database.
    • Inside select 4thoption that is Manage Template.
    • Inside select Structure With Data. 
    • Inside select Database Name.
    • Inside give some information that is It's name, Description, path.
    • Inside select 2nd option that is convert database to ASM.
    • After generate Conformation Box and then click on Yes Button.
    • Then start to creating template it take time according to size of your database.

      6.  Again start DBCA
      7.  Select 1st option that is Preconfigure single database instance.
      8.  Inside select 1st option that is Create Database.
      9.  Inside select Created Template Name that has been created.
    10.  Inside select Admin Manage Database Or Policy Manage Database [ this is come since oracle
           11g R2 ].
    11.  Enter Old Database name and also enter New Database name.
    12.  Then Enter password for SYS OR SYSTEM user.
    13.  Then select storage option it may be File system or ASM [ ASM is recommended ].
    14.  And also select Disk group.
    15.  Then check box to check it which for Create Database.
    16.  Press Next [ Finish ]  Button.
   
That's are those steps to convert single instance database to RAC [ Real Application Cluster ].



No comments:

Post a Comment

Thank you for give me feedback : )