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

Comments

Popular posts from this blog

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

PostgreSQL Database startup / shutdown /restart

ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated ORA-01262: Stat failed on a file destination directory Linux-x86_64 Error: 2: No such file or directory

PostgreSQL pgBadger

How to configure Replication Manager (repmgr) ?