规划单节点迁移到rac

用户现在只有一个主机，但很快就会购买第二个主机，并肯定要采用rac系统。用户要求先安装成rac，然后扩节点。

考虑了一次，这样确实比较简单方便。安装单节点rac，crs全部安装完成。上面是一个节点的服务。一切按照标准的步骤安装。

建库，一定要建在asm上。

现在，第二台主机到货，一切比较简单，全部操作完成总共停库不足20分钟。

首先按照增加节点的办法把新主机加到rac里面。上面的文章已经有了。

然后把asm迁移到rac。asm的实例名字会自动加上1 2。

然后运行rconfig脚本，把单实例的数据库迁移成rac。

rconfig真tmd的好用，自动加redo，undo，改实例名，所有一切一切全部自动搞定，太好用了，

参考下面文档

RCONFIG : Frequently Asked Questions [ID 387046.1]

--------------------------------------------------------------------------------
 
  Modified 03-MAR-2008     Type FAQ     Status PUBLISHED  

In this Document
  Purpose
  Questions and Answers
     What is rconfig ?
     How does rconfig works ?
     What are the prerequisites before we use rconfig ?
     How to test rconfig before converting to RAC ?
     Where are the rconfig log files located ?
      How to restart Rconfig ?
    
  References

 

--------------------------------------------------------------------------------

 

Applies to:
Oracle Application Object Library - Version: 11.5.10 to 11.5.10
Information in this document applies to any platform.

Purpose
This FAQ explains the "rconfig" tool introduced in Oracle Database Version 10.2. This is also used extensively when Oracle E-Business Suite 11i Customers convert their Single Instance Database to RAC.
Questions and Answers
What is rconfig ?
rconfig is a command line tool introduced in Oracle Database 10g R2 to convert Single-Instance 10g R2 Database to RAC(Real Application Cluster). The other option is to use Convert to RAC option on the single-instance database target of Oracle Enterprise Manager Grid Control.

How does rconfig works ?
rconfig is located at $ORACLE_HOME/bin/. rconfig takes in a xml input file and convert the Single Instance database whose information is provided in the xml.This tool is documented in the RAC Admin Guide and a sample xml can be found $ORACLE_HOME/assistants/rconfig/sampleXMLs/ConvertToRAC.xml.

rconfig performs following steps :

?Migrate the database to ASM storage (Only if ASM is specified as storage option in the configuration xml file above) 
?Create Database Instances on all nodes in the cluster 
?Configure Listener and NetService entries
?Configure and register CRS resources 
?Start the instances on all nodes in the cluster.
What are the prerequisites before we use rconfig ?
Before you convert a single-instance database to a RAC database using rconfig, ensure that the following conditions are met for each cluster node that you intend to make a RAC database node:

?Oracle Clusterware 10g Release 2 (10.2) is installed, configured, and running.
?Oracle Real Application Clusters 10g Release 2 (10.2) software is installed.
?The Oracle binary is enabled for RAC.
?Shared storage, either Oracle Cluster File System or ASM, is available and accessible from all nodes.
?User equivalence exists for the oracle user.
How to test rconfig before converting to RAC ?
Oracle 10g R2 Install has provided a sample rconfig input XML file called ConvertToRAC.xml at directory $ORACLE_HOME/assistants/rconfig/sampleXMLs. Make a copy of the sample XML file & make your own customised copy of input giving your Instance specific details. The Sample XML file includes comments to make understand how to edit each variable.

For testing purpose you need to modify the "Convert verify = "ONLY" option in the xml file.Then run the tool :

$ ./rconfig convert.xml

The Convert verify option in the ConvertToRAC.xml file has three options:

?Convert verify="YES": rconfig performs checks to ensure that the prerequisites for single-instance to RAC conversion have been met before it starts conversion
?Convert verify="NO": rconfig does not perform. prerequisite checks, and starts conversion
?Convert verify="ONLY" : rconfig only performs prerequisite checks; it does not start conversion after completing prerequisite checks

Where are the rconfig log files located ?
rconfig log files are located at  $ORACLE_HOME/cfgtoollogs/rconfig

Also one important thing to note is that rconfig re-writes the log file everytime you run the rconfig tool. So make sure have a copy in case you want to refer to the results of earlier run

 How to restart Rconfig ?
After running RCONFIG in Convert verify="YES" Mode, if you get any fatal error(e.g. Disk space not available, Some issue with 10g Parameters, Shared Storage Issues) which exits the rconfig tool & stops the conversion. You can restart the rconfig tool again by running the command " $ ./rconfig convert.xml ". This will perform. the clean-up operation on converted Instance or will delete the files created by earlier run. It again starts the process of conversion from start i.e. taking rman backup of Single Instance. After the conversion you can check the filesystem to verify if there is anything left from the previous failed run.

 

 

References
NOTE:371519.1 - Rconfig Error When Converting From Single Instance To RAC
NOTE:375472.1 - RCONFIG FAILS with an null pointer EXCEPTION
NOTE:362135.1 - Configuring Oracle Applications Release 11i with 10g R2 RAC and ASM
Oracle? Database Oracle Clusterware and Oracle Real Application Clusters Installation Guide Rel. 10.2

--------------------------------------------------------------------------------

 Related

 

--------------------------------------------------------------------------------
Products
--------------------------------------------------------------------------------

?Oracle E-Business Suite > Applications Technology > Application Object Library > Oracle Application Object Library
Keywords
--------------------------------------------------------------------------------
RCONFIG; REAL APPLICATION CLUSTERS

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/13337857/viewspace-713706/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/13337857/viewspace-713706/