1 Reply Latest reply: Jun 21, 2009 5:08 PM by val75 RSS

    can't switch standby logfiles to status=active

    val75
      Hi DBA's

      I'm trying to create logical standby on 10.2 on fedora 6 on manual http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/create_ps.htm#g88234
      I can't create proper working standby redo logs.

      ALTER DATABASE ADD STANDBY LOGFILE GROUP 4
      ('/u01/app/oracle/oradata/ORCL/onlinelog/log4a.log',
      '/u01/app/oracle/flash_recovery_area/ORCL/onlinelog/log4b.log') SIZE 50M;

      then create the rest of standby redos and switch logfile:
      ALTER SYSTEM SWITCH LOGFILE;

      when:
      SQL> SELECT GROUP#,THREAD#,SEQUENCE#,ARCHIVED,STATUS FROM V$STANDBY_LOG;
      GROUP# THREAD# SEQUENCE# ARC STATUS
      4 0 0 YES UNASSIGNED
      5 0 0 YES UNASSIGNED
      6 0 0 YES UNASSIGNED
      What to do?

      Edited by: val75 on Jun 21, 2009 11:08 PM