No valid default archive log destination directory found for thread 2

Recently we refresh our dev database from prod using rman cloning, totaling of 4 database representing 4 regions.

Oracle GG is use to replicate the data, multi bidirectional replication.

after the rman cloning, i started the GG using begin now but i’m getting below error with our main extract, pump and replicat is working fine.

2016-04-10 11:27:03  WARNING OGG-01423  Oracle GoldenGate Capture for Oracle, cknm2bet.prm:  No valid default archive log destination directory found for thread 2.
2016-04-10 11:27:03  INFO    OGG-00546  Oracle GoldenGate Capture for Oracle, cknm2bet.prm:  Default thread stack size: 10485760.
2016-04-10 11:27:03  ERROR   OGG-00446  Oracle GoldenGate Capture for Oracle, cknm2bet.prm:  The number of Oracle redo threads (2) is not the same as the number of checkpoint threads (1). EXTRACT groups on RAC systems should be created with the THREADS parameter (e.g., ADD EXT , TRANLOG, THREADS 2, BEGIN...).
2016-04-10 11:27:03  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, cknm2bet.prm:  PROCESS ABENDING.


the problem was, the prod database is clustered enviroment, and our dev is a standalone database.

SQL> select THREAD#, STATUS , ENABLED , SEQUENCE#, to_char(LAST_REDO_TIME,'dd-mon-yy hh24:mi:ss') from v$thread;

   THREAD# STATUS ENABLED   SEQUENCE# TO_CHAR(LAST_REDO_TIME,'DD-
---------- ------ -------- ---------- ---------------------------
         1 OPEN   PUBLIC         5049 10-apr-16 22:51:33
         2 CLOSED PRIVATE 7
SQL>
SQL> select THREAD#,GROUP#,SEQUENCE#,MEMBERS,status from v$log order by SEQUENCE# ;

   THREAD#     GROUP#  SEQUENCE#    MEMBERS STATUS
---------- ---------- ---------- ---------- ----------------
         1          1       5047          2 INACTIVE
         1          2       5048          2 INACTIVE
         1          3       5049          2 CURRENT
         2          4       0             2 UNUSED
         2          5       0             2 UNUSED
         2          6       0             2 UNUSED
SQL>

base on above query, below are the step to start the extract.
1. disable thread 2

SQL> alter database disable thread 2;
Database altered.

SQL>

2. drop the unused log group

SQL> alter database drop logfile group 4;
Database altered.

SQL> alter database drop logfile group 5;
Database altered.

SQL> alter database drop logfile group 6;
Database altered.
SQL>

3. alter the extract and start it.

GGSCI (kyxxxsgts01) 11> alter extract CKNM2BET, thread 1, extseqno 547, extrba 0;
EXTRACT altered.


GGSCI (kyxxxsgts01) 12> 

GGSCI (kyxxxsgts01) 9> start CKNM2BET

Sending START request to MANAGER ...
EXTRACT CKNM2BET starting


GGSCI (kyxxxsgts01) 10>

the same step i did with other region extract.

thanks for visiting..

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s