11g RAC :Convert NON RAC database to RAC database using RCONFIG

 
       

        11g RAC :Convert NON RAC database to RAC database using RCONFIG



When you navigate through the $ORACLE_HOME/assistants/rconfig/sampleXMLS, you will find two sample XML input files.


– ConvertToRAC_AdminManaged.xml
– ConvertToRAC_PolicyManaged.xml


– Edit AdminManaged.xml and make following changes :

   . Specify current OracleHome of non-rac database for SourceDBHome
   . Specify OracleHome where the rac database should be configured. It can be same as SourceDBHome
   . Specify SID of non-rac database and credential. User with sysdba role is required to perform conversion
   . Specify the list of nodes that should have rac instances running for the Admin Managed Cluster Database. LocalNode should be the first node in this nodelist.
   . Instance Prefix tag is optional starting with 11.2. If left empty, it is derived from db_unique_name
   . Specify the type of storage to be used by rac database. Allowable values are CFS|ASM
   . Specify Database Area Location to be configured for rac database.
   . Specify Flash Recovery Area to be configured for rac database.

SAMPLE SCRIPT that changes were made in XML file to convert.



<?xml version=”1.0″ encoding=”UTF-8″?>
<n:RConfig xmlns:n=”http://www.oracle.com/rconfig”
           xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance”
           xsi:schemaLocation=”http://www.oracle.com/rconfig rconfig.xsd”>
    <n:ConvertToRAC>
<!– Verify does a precheck to ensure all pre-requisites are met, before the conversion is attempted. Allowable values are: YES|NO|ONLY –>
        <n:Convert verify=”ONLY”>
<!–Specify current OracleHome of non-rac database for SourceDBHome –>
              <n:SourceDBHome>/backup/PROD/db/tech_st/11.2.0</n:SourceDBHome>
<!–Specify OracleHome where the rac database should be configured. It can be same as SourceDBHome –>
              <n:TargetDBHome>/u01/app/oracle/product/11.2.0/dbhome_1</n:TargetDBHome>
<!–Specify SID of non-rac database and credential. User with sysdba role is required to perform conversion –>
              <n:SourceDBInfo SID=”PROD”>
                <n:Credentials>
                  <n:User>sys</n:User>
                  <n:Password>oracle</n:Password>
                  <n:Role>sysdba</n:Role>
                </n:Credentials>
              </n:SourceDBInfo>
<!–Specify the list of nodes that should have rac instances running for the Admin Managed Cluster Database. LocalNode should be the first node in this nodelist. –>
              <n:NodeList>
                <n:Node name=”hostname1″/>
                <n:Node name=”hostname2″/>
              </n:NodeList>
<!–Specify RacOneNode along with servicename to convert database to RACOne Node –>
              <!–n:RacOneNode  servicename=”salesrac1service”/–>
<!–Instance Prefix tag is optional starting with 11.2. If left empty, it is derived from db_unique_name.–>
              <n:InstancePrefix></n:InstancePrefix>
<!– Listener details are no longer needed starting 11.2. Database is registered with default listener and SCAN listener running from Oracle Grid Infrastructure home. –
->
<!–Specify the type of storage to be used by rac database. Allowable values are CFS|ASM. The non-rac database should have same storage type. ASM credentials are no nee
ded for conversion. –>
              <n:SharedStorage type=”ASM”>
<!–Specify Database Area Location to be configured for rac database.If this field is left empty, current storage will be used for rac database. For CFS, this field wil
l have directory path. –>
                <n:TargetDatabaseArea>+DISKNAME</n:TargetDatabaseArea>
<!–Specify Fast Recovery Area to be configured for rac database. If this field is left empty, current recovery area of non-rac database will be configured for rac data
base. If current database is not using recovery Area, the resulting rac database will not have a recovery area. –>
                <n:TargetFlashRecoveryArea>+DISKNAME</n:TargetFlashRecoveryArea>
              </n:SharedStorage>
        </n:Convert>
    </n:ConvertToRAC>

Note: In the xml file ,

<!– Verify does a precheck to ensure all pre-requisites are met, before the conversion is attempted. Allowable values are: YES|NO|ONLY –>
        <n:Convert verify=”ONLY”> ——> this value does only check the pre-requisites.

In order to convert we should specify YES value

<!– Verify does a precheck to ensure all pre-requisites are met, before the conversion is attempted. Allowable values are: YES|NO|ONLY –>
        <n:Convert verify=”YES”> ——> this value does the convention from non-rac to rac.

  • April 18, 2016 | 25 views
  • Comments