Migrating Oracle Single Instance to RAC Instance.
Conversion Methods
Convert Single Instance to RAC using EM
using DBCA
using RCONFIG
Test with out Actual Conversion
How to proceed from a failed conversion
Logs to be monitored
Post Conversion Steps
References.
#
Presuming that
GI configured up and running
Single instance databasee exists on same node.
DB Release is the same.
ASM and required DG are configured.
#
Conversion Methods
Expor/imp
Manual - Stream and datapump
RCONFIG
DBCA
Grid control.
#
Best Suited - Grid control,DBCA,RCONFIG
Best Suited for cross Platform - Exp/imp
#
Most Important - Backup.
#
Conversion using EM
Preassume - Single registerd with OEM
Login
Databases - Targets
change database - Database instance
Convert to cluster Database
sys with sysdba
on the convert to cluster database.
Prvide asm sys paswd.
select shared storage
#
Convert Single Instance to RAC using DBCA
2 Easy Steps
Create a template from single instance.
Manage templates
From an existing database (Structure as well as
data)
Choose Database name
Name of the template
Convert the file locations to use OFA structure.
Ok- Creation of clone template.
Yes- Continue with another operation.
Template location - home/assistance/templates
choose RAC database
Single Instance RAC DB.
11g R2 Two types- admin managed/Policy manged
Storage Type - ASM
Use OMF - +DG -> Select Disk Group
Create database.
#
Convertion Using RCONFIG ( Released in 10g R2- Non
interactive command lin)
Also used in Ebusiness single instance conve.
rconfig
Preassume- Sing ins with ASM Mounted.
released in
located under - $ORACLE_HOME/bin
Ability to Migrate nonasm to asm.
Takes in an xml input file.
11g r2 - two Xml files - admini/policy manged.
prerequisites
home/asssistants/rconfig/sampleXMLs/ConverttoRAC_AdminMana
ged.xml.
Three Parameters options
Convert verify="YES" verifies and convert
Convert Verify="NO" #By Pass verification checks
Convert Verify="ONLY" #
Change the values in xml
Source DB HOME,TARGET DB HOME
SID-
ServiceName
SharedStorage Type
TargetFlashRecoveryArea
Target
Execute as oracle user
./ORACLE_HOME/bin/rconfig Conver..AdminManaged.xml
srvctl config database -d racdb ( Used in 11gr2)
#
Test without Conversion
choose convert verify="Only"
Increase the process - Performance
RMAN>configure device type disk parallelism 6;