How to add instance to oracle RAC database

I am having two nodes oracle RAC  , now I am adding 3rd instance to this database.

SQL> startup pfile='/archive/pfile-rman.ora' 
ORACLE instance started.
Total System Global Area 1.0737E+10 bytes Fixed Size                  2114104 bytes Variable Size            1560284616 bytes Database Buffers         9160359936 bytes Redo Buffers               14659584 bytes ORA-01618: redo thread 3 is not enabled - cannot mount

SQL>

SQL> alter database add logfile thread 3 group 31 ('/archive/datafile/REDO301.LOG') size 1024M;
Database altered.
SQL> alter database add logfile thread 3 group 32 ('/archive/datafile/REDO302.LOG') size 1024M;
Database altered.
SQL>alter database add logfile thread 3 group 33 ('/archive/datafile/REDO303.LOG') size 1024M;
Database altered.

Enable the Thread now

SQL> alter database enable public thread 3;
Database altered.
SQL>
SQL> ALTER DATABASE mount;
Database altered.

SQL>

SQL> alter database open
; alter database open * ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
SQL> create undo tablespace UNDOTBS3 datafile '/archive/datafile/UNDOTBS3.dbf' size 2G autoextend on;
Tablespace created.
SQL>

Start the Instance again

SQL> startup pfile='/archive/pfile-rman.ora' 
ORACLE instance started.
Total System Global Area 1.0737E+10 bytes Fixed Size                  2114104 bytes Variable Size            1560284616 bytes Database Buffers         9160359936 bytes Redo Buffers               14659584 bytes 
Database mounted. 
Database opened. 
SQL> select instance_name from gv$instance;
INSTANCE_NAME 
 orcl3 
orcl2 
orcl1

———————————–

Advertisements

About Sher khan

Senior Oracle DBA, Oracle 10g , Oracle 11g OCE ,Oracle 12C and Oracle 11g OPN certified Specialist, OCP Certified in Oracle 9i,10g , 11g and 12C. I am working in Oracle technology since 2004. Currently working in U.A.E Email: sher487@hotmail.com
This entry was posted in Oracle RAC. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s