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

advertisements

_____________________________________________________________________________________________________________________

Error description: RMAN duplicate command is failing with following error.

RMAN-00571: =================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS

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 3^rd or 4^th node of the auxiliary database you will get this error. Because, in most of the cases in your target database you don’t have 3^rd /4^th log threads. So you have to make your 1^st or 2^nd node of your auxiliary database for duplicate database cloning. Once you finish with the cloning, you can add 3^rd and 4^th 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.group#,a.thread#, b.member, a.bytes/1024/1024,bytes/1024, a.status,b.status  

from v$log a,v$logfile b where a.group#=b.group#;

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.

_____________________________________________________________________________________________________________________

Website Stats