Friday, March 1, 2013

ORA-1613 signalled during: alter database enable public thread 2...

Enabling the thread 2 of a RAC 2 node database fails with the below error.

##########################
#   Errors 
##########################

Wed Feb 27 07:34:57 2013

ORA-1613 signalled during: alter database enable public thread 2...


ORA-1613 signalled during: alter database enable public thread 2...

##########################
#   Command Used  
##########################

Alter Database Enable Public Thread 2;

##########################
#   Informations  
##########################

There are no redo logs which belongs to Thread 2, all the redo logs are created in Thread 1.

##########################
 Solution 
##########################

Added New Redo log groups to thread 2. 


alter database add logfile thread 2 group 7
('/u01/oradata/mydb/redo_02_07.log') size 1024M;

And then enabled the thread.

Alter Database Enable Public Thread 2;


Check Whether Thread is Enabled Or Not :


SQL> select thread#, enabled from v$thread;

   THREAD# ENABLED
---------- --------
         1 PUBLIC
         2 PUBLIC


No comments: