Oracle Applications DBA: May 2011

Sunday, 8 May 2011

Non-RAC to RAC Conversion

There are several methods that every one use for Non-RAC to RAC Conversion database .
Here iam going to use a "rconfig" utility for the conversion.
Steps:-
1> Convert from Non-ASM to ASM filesystem as per my previous post .

2> Go to ORACLE_HOME/assistants/rconfig/sampleXMLS
In the above path we get to see a file " convertToRac.xml "

3> Copy the above file to some location as below
cp $ORACLE_HOME/assistants/rconfig/sampleXMLS/convertToRac.xml /tmp/convert2RAC.xml

4> Change the following parameters in /tmp/convert2RAC.xml file
a) Database SID b) ASM SID c) ASM pwd d) Node names e) Listener port (accordingly)

Sample file:-
========================================================================
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"--
--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="YES"--
--!--Specify current OracleHome of non-rac database for SourceDBHome ----
--n:SourceDBHome--/u01/app/oracle/product/10g/db_1--/n:SourceDBHome-----your source database home
--!--Specify OracleHome where the rac database should be configured. It can be same as SourceDBHome ----
--n:TargetDBHome--/u01/app/oracle/product/10g/db_1--/n:TargetDBHome-- ---your target database home
--!--Specify SID of non-rac database and credential. User with sysdba role is required to perform conversion ----
--n:SourceDBInfo SID="PROD"---------------your database name
--n:Credentials--
--n:User--sys--/n:User--
--n:Password--oracle--/n:Password--
--n:Role--sysdba--/n:Role--
--/n:Credentials--
--/n:SourceDBInfo--
--!--ASMInfo element is required only if the current non-rac database uses ASM Storage ----
--n:ASMInfo SID="+ASM1"---------------------your ASM Instance name
--n:Credentials--
--n:User--sys--/n:User--
--n:Password--oracle--/n:Password-- ----your ASM instance password
--n:Role--sysdba--/n:Role--
--/n:Credentials--
--/n:ASMInfo--
--!--Specify the list of nodes that should have rac instances running. LocalNode should be the first node in this nodelist. ----
--n:NodeList--
--n:Node name="rac1"/-------your rac1 hostname--n:Node name="rac2"/------your rac2 hostname
--/n:NodeList--
--!--Specify prefix for rac instances. It can be same as the instance name for non-rac database or different. The instance number will be attached to this prefix. ----
--n:InstancePrefix--PROD--/n:InstancePrefix-----your database name
--!--Specify port for the listener to be configured for rac database.If port="", alistener existing on localhost will be used for rac database.The listener will be extended to all nodes in the nodelist ----
--n:Listener port="1551"/-----listener port number
--!--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. ----
--n:SharedStorage type="ASM"------your storage type
--!--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 will have directory path. ----
--n:TargetDatabaseArea-- --/n:TargetDatabaseArea------leave blank
--!--Specify Flash 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 database. If current database is not using recovery Area, the resulting rac database will not have a recovery area. ----
--n:TargetFlashRecoveryArea-- --/n:TargetFlashRecoveryArea---leave blank
--/n:SharedStorage--
--/n:Convert--
--/n:ConvertToRAC--
--/n:RConfig--
=================================================================================
5> After modifying the convert2RAC.xml file as above under /tmp/convert2RAC.xml , run rconfig tool as below

cd $ORACLE_HOME/bin
./rconfig /tmp/convert2RAC.xml

6> Change SID in /etc/oratab as PROD1 in rac1 m/c & PROD2 in rac2 m/c .

7> Finally run srvctl to configure the database
srvctl config database -d PROD
srvctl config database -d PROD

Thanks

Saturday, 7 May 2011

Convert ASM to Non-ASM File system

Steps:-
1>
/u01/oracle>export ORACLE_SID=PROD
/u01/oracle>sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Thu May 06 13:09:07 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

2>

Go to init file or spfile , then modify the parameters mentioned above.
/u01/oracle/product/10.2.0/db_1>
/u01/oracle/product/10.2.0/db_1/database>vi initprod.ora
Eg: control_files='/U01/ORACLE/PRODUCT/10.2.0/ORADATA/PROD/CONTROL01.CTL','/U01/ORACLE/PRODUCT/10.2.0/ORADATA/PROD/CONTROL02.CTL’,’/U01/ORACLE/PRODUCT/10.2.0/ORADATA/PROD/CONTROL03.CTL'

Accordingly change the other paths ASM DISK GROUP to normal file system.

u01/oracle/product/10.2.0/db_1/database>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Feb 18 13:24:33 2010

Connected to an idle instance.

SQL> STARTUP NOMOUNT PFILE='/u01/oracle/product/10.2.0/db_1/database/initPROD.ora

ORACLE instance started.

Total System Global Area 612368384 bytes

Fixed Size 1250428 bytes

Variable Size 192940932 bytes

Database Buffers 411041792 bytes

Redo Buffers 7135232 bytes

Open a new session and connect to RMAN and then copy the controlfile from older location to non-ASM location using the following command:

/u01/oracle/rman>export ORACLE_SID=PROD

/u01/oracle/rman>rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Thu May 06 13:27:40 2011

connected to target database: prod (not mounted)

RMAN> restore controlfile from '+data/control01.ctl';

Starting restore at 06-MAY-11

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=156 devtype=DISK

channel ORA_DISK_1: copied control file copy

output filename=/u01/oracle/product/10.2.0/oradata/PROD/CONTROL01.CTL

output filename=/u01/oracle/product/10.2.0/oradata/PROD/CONTROL02.CTL

output filename=/u01/oracle/product/10.2.0/oradata/PROD/CONTROL03.CTL

Finished restore at 06-MAY-11

Now mount the database from existing RMAN session

RMAN> alter database mount;

database mounted

released channel: ORA_DISK_1

Now take a backup copy into a file system location, this copied file system Database backup will be used as the actual non-ASM database files .

RMAN> backup as copy database format '/u01/oracle/product/10.2.0/oradata/prod/%U.dbf';

Starting backup at 06-MAY-11

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=154 devtype=DISK