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.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.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7199859/viewspace-664015/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7199859/viewspace-664015/