Fix Duplicate Database failing RMAN-06136: ORA-01618: redo thread is not enabled - cannot mount


The Eucharistic Miracles of the World
Error description: RMAN duplicate command is failing with following error.

RMAN-00571: =================================================
RMAN-00571: ===============================================
RMAN-03002: failure of Duplicate Db command at 12/21/2011 04:43:44
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-06136: ORACLE error from auxiliary database: ORA-01618: redo thread 3 is not enabled - cannot mount

Solution Description:

Solution 1:
In my scenario, I had 2 nodes in my target database and 4 nodes in auxiliary database. If you are trying to do the cloing from the 3rd or 4th node of the auxiliary database you will get this error. Because, in most of the cases in your target database you don’t have 3rd /4th log threads. So you have to make your 1st or 2nd node of your auxiliary database for duplicate database cloning. Once you finish with the cloning, you can add 3rd and 4th thread to the database.

Solution 2:
Suppose your database refresh is completed and you are not able to bring the database using srvctl command as you are getting error ORA-01618: redo thread 3 is not enabled - cannot mount. You have to add curresponding log thread from the node or database which is working properly. Suppose if you can bring up the database in node 1, you have to add threads from node 1 using following method.

How to add log thread to Oracle 10g 11g RAC ASM database?

Run below mentioned query and find out which is CURRENT log group
col member format a70
set linesize 300
select,a.thread#, b.member, a.bytes/1024/1024,bytes/1024, a.status,b.status  
from v$log a,v$logfile b where;

Suppose your thread 1 is in current status you can drop or add files to other thread in following manner and it can be done from any running instance.

alter database disable thread 2;
alter database drop logfile group 4;
alter database drop logfile group 5;
alter database drop logfile group 6;

alter database add logfile thread 2 group 4  size  1G;
alter database add logfile thread 2 group 5  size  1G;
alter database add logfile thread 2 group 6  size  1G;

alter database enable public thread 2;

Similar way you can add new threads and enable it.



Post a comment


Oracle (575) General (60) Unix (47) Blog (23) Script (12) OCI (3) SQL* Loader (3) Software (1) Copyright 2011-21 All Rights Reserved | Site Map | Contact | Disclaimer