Managing templates for Oracle RAC databases on Linux and UNIX

When working with the template for creating a Real Applications Cluster (RAC) database, you can customize the default template, as follows:

Adding custom initialization parameters

If you want to add custom initialization parameters into the template for creating a RAC database, insert the following content in the CDATA section of the template:

<custom_init_parameters>
         <![CDATA[
                <initParam name="db_create_online_log_dest_1" value="+REDO1"/>
                <initParam name="db_create_online_log_dest_2" value="+REDO2"/>
                <initParam name="db_create_file_dest" value="+DATA"/>
                <initParam name="log_archive_dest_1"
value="location=USE_DB_RECOVERY_FILE_DEST mandatory"/>
                <initParam name="nls_date_format" value="YYYY-MON-DD HH:MI:SS
PM"/>
                        ]]>
                </custom_init_parameters>

Adding redo log member directory names

If you want to add the directory names for Redo Log Member Directories into the template for creating a RAC database, use the following structure:

<templates>
  <template>/oradata/1/{DB_UNIQUE_NAME}/</template>
  <template>/oradata/2/{DB_UNIQUE_NAME}/</template>
</templates>
<redo_log_member_file name_template>%t%g%.log</redo_log_member_file name_template>
<num_of_redo_log_groups>2</num_of_redo_log_groups>
<num_of_redo_log_members>2</num_of_redo_log_members

Creating a separate disk group for GIMR data

NEW IN 8.9.02(Applies to 12.2.0.1 only) If you want to create a separate disk group for the Grid Infrastructure Management Repository (GIMR) data to segregate it from the Cluster Ready Services (CRS) data, insert the following content in the template:

<gimr_configure>TRUE</gimr_configure>
<gimr_diskgroup_name>DGIMRG</gimr_diskgroup_name>                              
<gimr_disks>
	<gimr_disk>/dev/oracle/post11gR2/GRID6</gimr_disk>  
</gimr_disks>
<gimr_au_size>4</gimr_au_size>
<gimr_redundancy>EXTERNAL</gimr_redundancy>



Was this page helpful? Yes No Submitting... Thank you

Comments