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
Comments
Post a Comment