Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

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

No comments:

Post a Comment