oracle 9i single instance convert to rac database
PURPOSE
-------
This article provides a method to convert a Single Instance 9i database to
a Real Application Clusters 9i database without using export/import tools.
SCOPE & APPLICATION
-------------------
This article is intended for Oracle Support Analysts and DBAs who support or
administrate Oracle Real Application Clusters databases. It is related to
databases running on any Cluster File System. (see Note: 183408.1 for more
information about CFS)
It is assumed that a Cluster File System (CFS) is used for your 9i Single
Instance database; therefore, you do not need to move your datafiles from
regular file system files to raw devices when switching from the Single
Instance Database to RAC.
This article is related to instance migration only, not software migration.
To install the RAC option, you will need to use the Oracle Universal Installer
and select this option.
For more details, please report to the Oracle 9i Installation Guide.
Steps to convert your existing 9i single instance database to RAC
-----------------------------------------------------------------
1. Make a full database backup before you change anything.
2. Copy the existing $ORACLE_HOME/dbs/init.ora to
$ORACLE_HOME/dbs/init.ora. Add the following parameters to
$ORACLE_HOME/dbs/init.ora:
*.cluster_database = TRUE
*.cluster_database_instances = 2
*.undo_management=AUTO (Add if you don't have it )
.undo_tablespace=undotbs (undo tablespace which already exists)
.instance_name=RAC1
.instance_number=1
.thread=1
.local_listener=LISTENER_RAC1
where LISTENER_RAC1 is an entry in the tnsnames.ora file like:
LISTENER_RAC1 =
(ADDRESS = (PROTOCOL = TCP)(HOST =)(PORT = 1521))
Keep only one line in $ORACLE_HOME/dbs/init.ora:
ifile=$ORACLE_HOME/dbs/init.ora
You could also create a common spfile from this pfile and add a line
like spfile=$ORACLE_HOME/dbs/spfile.ora in each init.ora
file. For more details about how to do this, please refer to Note 136327.1.
3. Open your database and run $ORACLE_HOME/rdbms/admin/catclust.sql to create
cluster database specific views within the existing instance.
4. Recreate control file if you defined maxinstances to be 1 when you created
the single instance database.
To check your current setting of maxinstances, run the following command
while the database is mounted or open and connected as a user with DBA
privileges:
% sqlplus /nolog
SQL> connect / as sysdba
SQL> startup mount
SQL> alter database backup controlfile to trace;
The trace file is located in udump directory. Check the maxinstance value
in the CREATE CONTROLFILE statement. Please refer to Note.118931.1
Recreating the Controlfile in RAC and OPS
5. Add instance specific parameters in the init.ora for the second
instance on the second node and set appropriate values for it:
*** Names may need to be modified
.instance_name=RAC2
.instance_number=2
.local_listener=LISTENER_RAC2
.thread=2
.undo_tablespace=UNDOTBS2
.cluster_database = TRUE
.cluster_database_instances = 2
where LISTENER_RAC2 is an entry in the tnsnames.ora file like:
LISTENER_RAC2 =
(ADDRESS = (PROTOCOL = TCP)(HOST =)(PORT = 1521))
6. From the first instance, mount the database and run the following command:
*** Path names, file names, and sizes will need to be modified
alter database
add logfile thread 2
group 3 ('/dev/RAC/redo2_01_100.dbf') size 100M,
group 4 ('/dev/RAC/redo2_02_100.dbf') size 100M;
alter database enable public thread 2;
7. Create a second Undo Tablespace from the existing instance:
*** Path names, file names, and sizes will need to be modified
CREATE UNDO TABLESPACE UNDOTBS2 DATAFILE
'/dev/RAC/undotbs_02_210.dbf' SIZE 200M ;
8. Set ORACLE_SID and ORACLE_HOME environment variables on the second node.
9. Start the second Instance.
-------
This article provides a method to convert a Single Instance 9i database to
a Real Application Clusters 9i database without using export/import tools.
SCOPE & APPLICATION
-------------------
This article is intended for Oracle Support Analysts and DBAs who support or
administrate Oracle Real Application Clusters databases. It is related to
databases running on any Cluster File System. (see Note: 183408.1 for more
information about CFS)
It is assumed that a Cluster File System (CFS) is used for your 9i Single
Instance database; therefore, you do not need to move your datafiles from
regular file system files to raw devices when switching from the Single
Instance Database to RAC.
This article is related to instance migration only, not software migration.
To install the RAC option, you will need to use the Oracle Universal Installer
and select this option.
For more details, please report to the Oracle 9i Installation Guide.
Steps to convert your existing 9i single instance database to RAC
-----------------------------------------------------------------
1. Make a full database backup before you change anything.
2. Copy the existing $ORACLE_HOME/dbs/init
$ORACLE_HOME/dbs/init
$ORACLE_HOME/dbs/init
*.cluster_database = TRUE
*.cluster_database_instances = 2
*.undo_management=AUTO (Add if you don't have it )
where LISTENER_RAC1 is an entry in the tnsnames.ora file like:
LISTENER_RAC1 =
(ADDRESS = (PROTOCOL = TCP)(HOST =
Keep only one line in $ORACLE_HOME/dbs/init
ifile=$ORACLE_HOME/dbs/init
You could also create a common spfile from this pfile and add a line
like spfile=$ORACLE_HOME/dbs/spfile
file. For more details about how to do this, please refer to Note 136327.1.
3. Open your database and run $ORACLE_HOME/rdbms/admin/catclust.sql to create
cluster database specific views within the existing instance.
4. Recreate control file if you defined maxinstances to be 1 when you created
the single instance database.
To check your current setting of maxinstances, run the following command
while the database is mounted or open and connected as a user with DBA
privileges:
% sqlplus /nolog
SQL> connect / as sysdba
SQL> startup mount
SQL> alter database backup controlfile to trace;
The trace file is located in udump directory. Check the maxinstance value
in the CREATE CONTROLFILE statement. Please refer to Note.118931.1
Recreating the Controlfile in RAC and OPS
5. Add instance specific parameters in the init
instance on the second node and set appropriate values for it:
*** Names may need to be modified
where LISTENER_RAC2 is an entry in the tnsnames.ora file like:
LISTENER_RAC2 =
(ADDRESS = (PROTOCOL = TCP)(HOST =
6. From the first instance, mount the database and run the following command:
*** Path names, file names, and sizes will need to be modified
alter database
add logfile thread 2
group 3 ('/dev/RAC/redo2_01_100.dbf') size 100M,
group 4 ('/dev/RAC/redo2_02_100.dbf') size 100M;
alter database enable public thread 2;
7. Create a second Undo Tablespace from the existing instance:
*** Path names, file names, and sizes will need to be modified
CREATE UNDO TABLESPACE UNDOTBS2 DATAFILE
'/dev/RAC/undotbs_02_210.dbf' SIZE 200M ;
8. Set ORACLE_SID and ORACLE_HOME environment variables on the second node.
9. Start the second Instance.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7199859/viewspace-664015/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle rconfig convert single instance to rac databaseOracleDatabase
- Convert a Single-Instance to RAC with ASMASM
- Migrate database from single instance to Oracle RACDatabaseOracle
- Manual Database Creation in Oracle9i (Single Instance and RAC)-137288.1DatabaseOracle
- HowTo Restore RMAN Disk backups of RAC Database to Single Instance On Another NoRESTDatabase
- rac one node、Single Instance HA(SIHA)、Oracle Restart的概念OracleREST
- How to Convert a Single-Instance ASM to Cluster ASM [ID 452758.1]ASM
- HowTo Restore RMAN Disk backups of RAC Database to Single Instance On Another Node [ID 415579.1]RESTDatabase
- Oracle database instanceOracleDatabase
- oracle10g rac(rhel4)__single instance轉化oracle rac_成功實施Oracle
- 9i RAC轉換為SINGLE例項
- Top 5 Database and/or Instance Performance Issues in RAC EnvironmentDatabaseORM
- Database and/or Instance Performance Issues in RAC Environment_1373500.1DatabaseORM
- [Shell] monitor oracle database listener & instance statusOracleDatabase
- 7.monitor oracle database listener & instance statusOracleDatabase
- The Instance and the Database (285)Database
- CONVERT DATABASE命令(三)Database
- CONVERT DATABASE命令(二)Database
- CONVERT DATABASE命令(一)Database
- [Install] HP Unix Install Oracle11g(Single Instance)Oracle
- Oracle 19c Concepts(13):Oracle Database InstanceOracleDatabase
- Oracle 9i RAC on PowerHA5.5Oracle
- Oracle 9i RAC 互聯效能Oracle
- HP平臺,9i RAC instance 2被驅逐故障診斷
- 【BUG】RAC instance eviction in oracle11.2.0.4Oracle
- How to drop Oracle RAC database manually?OracleDatabase
- Convert a Physical Standby Database into a Snapshot Standby DatabaseDatabase
- 理解Database和InstanceDatabase
- RMAN CONVERT DATABASE 的限制Database
- [總結]9i RAC LMON: terminating instance due to error 29702Error
- [總結]9i RAC LMON: terminating instance due to error 29702Error
- Oracle 9i RAC enqueue等待測試OracleENQ
- Oracle DataBase單例項遷移到Oracle RACOracleDatabase單例
- Create RAC Standby Database for RAC Primary DatabaseDatabase
- oracle 9i physical standby database狀態查詢OracleDatabase
- 3.2.1 Mounting a Database to an InstanceDatabase
- Overview of Instance and Database Startup (289)ViewDatabase
- oracle 9i physical standby database 中v$database switchover_status的含義OracleDatabase