Converting Standalone database to RAC Using rconfig utility

RCONFIG UTILITY
—————–

> Oracle has introduced rconfig utility in version 10g of oracle.

> The pre-requisite for rconfig is database area location should either
Cluster filesystem or ASM.

———————————————————————-

#su – oracle
rac1>$crsctl check crs
$ps -ef|grep smon
$srvctl stop database -d hrms
(no need to shutdown the database it should be up and running while creating
a database)

>>>Creating a standalone database

#xhost +
.oracle single instance db
.next
.create database
.next
.General purpose
global database name:prod
next
next
.use same password
confirm password
next
.select asm
next
password:racdba
.select one disk group
next
.use common location for all data files
next
.click on browse
.select ASM_DG_FRA
.click on ok
.enable archiving
.edit archive mode parameters
Remove the entries
.click on ok
next>next>next>next>finish>ok

Note:To find a file location when the instance is not running

$find /u01 -name “alert_*.log”

rac1># su – oracle
$ ps-ef|grep smon
$ sqlplus / as sysdba

SQL> select name,open_mode,log_mode from v$database;
SQL>show parameter cluster
SQL>select name,open_mode,log_mode from v$database;
SQL>select name from v$controlfile;
SQL>select name from v$datafile;
SQL>select member from v$logfile;

# su – oracle
$cd $ORACLE_HOME/dbs
$ls
$cd assistants
$ls
$cd rconfig
$cd SampleXMLs/
$ls
$prod
$cp ConvertTORAC.xml ~
$cd
$ls
$vi ConvertTORAC.xml

specify current Oraclehome of non-rac database for source DBHome

<n:SourceDBHome>/u01/app/oracle/product/10.2.0/db_home

specify OracleHome where the rac database should be configured

<n:TargetDBHome>/u01/app/oracle/product/10.2.0/db_home

specify SID for non RAC database and credential

<n:Source DBInfo SID=”prod”>
<n:password>racdba</n:password>
<n:Role>sysdba</n:Role>

Note:asminfo element is required only if the current non-rac

<n:password>racdba
<n:Role>sysdba

specify prefix for RAC instances Specify the list on non rac

<n:InstancePrefix>prod <n:Node name=”rac1″>

<n:InstancePrefix>prod <n:Node name=”rac2″>

The non-Rac database should have some storage

<n:shared storage type=”ASM”

Specify database area location to be configured

<n:TrgetDatabaseArea=+ASM_DG_DATA>

Specify flash Recovery area

<n:TargetFRA=+ASM_DG_FRA>

$ rconfig ConvertTORAC.xml
—————————————————————————————————

Advertisements
Leave a comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: