title: Oracle dataguard is not working properly because a FAL[client]
body: <p>I had two databases, a primary and secondary and a configured dataguard between both, i restarted the suse linux but when starting up databases, the replication is not being done, i think i took the wrong way to startup the standby database....no it is just mounted, i have a gap not posibble to be detected at standby gap table, and a 'no FAL server specified' problem at standby database, what could be wrong?</p>
  
  <pre><code>    From Primary:
      System parameters with non-default values:
      processes                = 1200
      nls_date_format          = "MM/DD/YYYY HH24:MI:SS"
      memory_target            = 8000M
      memory_max_target        = 8G
      control_files            = "/oracle/app/oradata/ora11g/control01.ctl"
      control_files            = "/oracle/app/oradata/ora11g/control02.ctl"
      control_files            = "/oracle/app/oradata/ora11g/control03.ctl"
      db_block_size            = 8192
      compatible               = "11.1.0.0.0"
      log_archive_start        = TRUE
      log_archive_dest_1       = "LOCATION=/home/oracle/archive"
      log_archive_format       = "%t_%s_%r.dbf"
      db_recovery_file_dest    = "/oracle/app/flash_recovery_area"
      db_recovery_file_dest_size= 2G
      undo_tablespace          = "UNDOTBS1"
      sec_case_sensitive_logon = FALSE
      remote_login_passwordfile= "EXCLUSIVE"
      db_domain                = ""
      dispatchers              = "(PROTOCOL=TCP) (SERVICE=ora11gXDB)"
      local_listener           = ""
      remote_listener          = ""
      session_cached_cursors   = 450
      cursor_sharing           = "FORCE"
      audit_file_dest          = "/oracle/app/admin/ora11g/adump"
      audit_trail              = "NONE"
      db_name                  = "ora11g"
      open_cursors             = 300
      diagnostic_dest          = "/oracle/app"
  </code></pre>
  
  <p>From standby database alert log:</p>
  
  <pre><code>    Thu Feb 13 17:16:02 2014
      Starting ORACLE instance (normal)
      LICENSE_MAX_SESSION = 0
      LICENSE_SESSIONS_WARNING = 0
      Picked latch-free SCN scheme 3
      Autotune of undo retention is turned on.
      IMODE=BR
      ILAT =145
      LICENSE_MAX_USERS = 0
      SYS auditing is disabled
      Starting up ORACLE RDBMS Version: 11.1.0.7.0.
      Using parameter settings in server-side spfile        
      /oracle/app/product/11g/db/dbs/spfileora11g.ora
      System parameters with non-default values:
      processes                = 1200
      nls_date_format          = "MM/DD/YYYY HH24:MI:SS"
      memory_target            = 8000M 
      memory_max_target        = 8G
      control_files            = "/oracle/app/oradata/ora11g/control01.ctl"
      control_files            = "/oracle/app/oradata/ora11g/control02.ctl"
      control_files            = "/oracle/app/oradata/ora11g/control03.ctl"
      db_block_size            = 8192
      compatible               = "11.1.0.0.0"
      log_archive_start        = TRUE
      log_archive_dest_1       = "LOCATION=/home/oracle/archive"
      log_archive_format       = "%t_%s_%r.dbf"
      db_recovery_file_dest    = "/oracle/app/flash_recovery_area"
      db_recovery_file_dest_size= 2G
      undo_tablespace          = "UNDOTBS1"
      sec_case_sensitive_logon = FALSE
      remote_login_passwordfile= "EXCLUSIVE"
      db_domain                = ""
      dispatchers              = "(PROTOCOL=TCP) (SERVICE=ora11gXDB)"
      local_listener           = ""
      remote_listener          = ""
      session_cached_cursors   = 450
      cursor_sharing           = "FORCE"
      audit_file_dest          = "/oracle/app/admin/ora11g/adump"
      audit_trail              = "NONE"
      db_name                  = "ora11g"
      open_cursors             = 300
      diagnostic_dest          = "/oracle/app"
      Deprecated system parameters with specified values:
      log_archive_start
      End of deprecated system parameter listing
      Thu Feb 13 17:16:04 2014
      .
      .
      .
      starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)   (PROTOCOL=TCP))'...
      Thu Feb 13 17:16:04 2014
      MMNL started with pid=15, OS id=10039
      starting up 1 shared server(s) ...
      ORACLE_BASE from environment = /oracle/app
      Thu Feb 13 17:16:04 2014
      ALTER DATABASE   MOUNT
      Setting recovery target incarnation to 2
      ARCH: STARTING ARCH PROCESSES
      Thu Feb 13 17:16:09 2014
      ARC0 started with pid=19, OS id=10272
      Thu Feb 13 17:16:09 2014
      ARC1 started with pid=20, OS id=10274
      Thu Feb 13 17:16:09 2014
      ARC2 started with pid=21, OS id=10276
      ARC0: Archival started
      ARC1: Archival started
      ARC2: Archival started
      Thu Feb 13 17:16:09 2014
      ARC3 started with pid=22, OS id=10278
      ARC3: Archival started
      ARCH: STARTING ARCH PROCESSES COMPLETE
      ARC0: Becoming the 'no FAL' ARCH
      ARC0: Becoming the 'no SRL' ARCH
      ARC0: Thread not mounted
      ARC1: Becoming the heartbeat ARCH
      ARC2: Thread not mounted
      ARC1: Thread not mounted
      ARC3: Thread not mounted
      Successful mount of redo thread 1, with mount id 4235628820
      Physical Standby Database mounted.
      Lost write protection disabled
      Completed: ALTER DATABASE   MOUNT
      FAL[client]: Error fetching gap sequence, no FAL server specified
  </code></pre>
  
  <p>Primary</p>
  
  <pre><code>    SQL&gt; select max(sequence#) from v$log_history;
      MAX(SEQUENCE#)
      --------------
      1606
  
  
      SQL&gt; SELECT name FROM v$archived_log WHERE thread# = 1 AND dest_id = 1 AND sequence#         BETWEEN 1591 and 1606;
      /home/oracle/archive/1_1606_792822090.dbf
      16 rows selected.
  
      SQL&gt;  SELECT GROUP#, BYTES FROM V$LOG;
      GROUP#      BYTES
      ---------- ----------
       1   52428800
       2   52428800
       3   52428800
  </code></pre>
  
  <p>Secondary</p>
  
  <pre><code>    SQL&gt; select max(sequence#) from v$log_history;
      MAX(SEQUENCE#)
      --------------
      1591
  
  
  
      SQL&gt;select process, thread#, sequence#, status from v$managed_standby where   process='MRP0';
      no rows selected
  
  
      SQL&gt; SELECT GROUP#, BYTES FROM V$STANDBY_LOG;
      no rows selected
  </code></pre>