This discussion is archived
2 Replies Latest reply: Jan 23, 2013 3:21 AM by CKPT RSS

Creating Logical Standby, DBMS_LOGSTDBY.BUILD; Hangs on Primary..

Imran Newbie
Currently Being Moderated
My two node RAC database Primary hangs upon executing SQL> exec DBMS_LOGSTDBY.BUILD; when creating a Logical Standby. I have stopped all the recovery processes on the Physical Standby. I have also taken down the instances on the RAC apart from the one I'm working on. Additionally not much info in the alert log...


Logminer Bld: Build started
Wed Jan 23 06:01:57 2013
ALTER SYSTEM SWITCH ALL LOGFILE start (UDSRED1)
Wed Jan 23 06:01:57 2013
ALTER SYSTEM SWITCH ALL LOGFILE complete (UDSRED1)
Wed Jan 23 06:01:57 2013
Thread 1 advanced to log sequence 2323 (LGWR switch)
Current log# 2 seq# 2323 mem# 0: /data03/oracle/oradata/UDSRED/redo02.rdo
Wed Jan 23 06:01:57 2013
Wed Jan 23 06:01:57 2013
Logminer Bld: Lockdown Complete. DB_TXN_SCN is 2548 1551493736
Wed Jan 23 06:01:57 2013
LNS: Standby redo logfile selected for thread 1 sequence 2323 for destination LOG_ARCHIVE_DEST_2
Wed Jan 23 06:01:57 2013
LNS: Standby redo logfile selected for thread 1 sequence 2323 for destination LOG_ARCHIVE_DEST_3
Wed Jan 23 06:01:59 2013
ALTER SYSTEM ARCHIVE LOG
Wed Jan 23 06:01:59 2013
Thread 1 advanced to log sequence 2324 (LGWR switch)
Current log# 3 seq# 2324 mem# 0: /data03/oracle/oradata/UDSRED/redo03.rdo
Wed Jan 23 06:01:59 2013
LNS: Standby redo logfile selected for thread 1 sequence 2324 for destination LOG_ARCHIVE_DEST_3
Wed Jan 23 06:01:59 2013
LNS: Standby redo logfile selected for thread 1 sequence 2324 for destination LOG_ARCHIVE_DEST_2
Wed Jan 23 06:02:00 2013
Wed Jan 23 06:02:00 2013
Logminer Bld: Done

Edited by: Imran on Jan 23, 2013 2:10 PM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points