2 Replies Latest reply: Jan 23, 2013 5:21 AM by CKPT RSS

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

    Imran
      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