5 Replies Latest reply: Nov 6, 2011 7:34 AM by mseberg RSS

    ORA-00254 | Troubles with dataguard

    Web
      Hi,
      I have troubles with configuring dataguard.
      oracle@oracle3:~> dgmgrl sys/powerpc
      DGMGRL for Linux: Version 11.2.0.1.0 - 64bit Production
      
      Copyright (c) 2000, 2009, Oracle. All rights reserved.
      
      Welcome to DGMGRL, type "help" for information.
      Connected.
      DGMGRL> show configuration
      
      Configuration - elspr_elssb
      
        Protection Mode: MaxPerformance
        Databases:
          elspr - Primary database
            Error: ORA-16778: redo transport error for one or more databases
      
          elssb - Physical standby database
      
      Fast-Start Failover: DISABLED
      
      Configuration Status:
      ERROR
      
      DGMGRL> show database elspr
      
      Database - elspr
      
        Role:            PRIMARY
        Intended State:  TRANSPORT-ON
        Instance(s):
          ELS1
            Error: ORA-16737: the redo transport service for standby database "elssb" has an error
      
          ELS2
      
      Database Status:
      ERROR
      
      
      DGMGRL> show database elspr logxptstatus
      LOG TRANSPORT STATUS
      PRIMARY_INSTANCE_NAME STANDBY_DATABASE_NAME               STATUS
                      ELS1                elssb ORA-00254: error in archive control string ''
      
      DGMGRL>
      oracle@oracle3:~> sqlplus / as sysdba
      
      SQL*Plus: Release 11.2.0.1.0 Production on Sat Nov 5 22:46:48 2011
      
      Copyright (c) 1982, 2009, Oracle.  All rights reserved.
      
      
      Connected to:
      Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
      With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
      OLAP, Data Mining, Oracle Database Vault and Real Application Testing options
      
      SQL> select dest_id,error from v$archive_dest where error is not null;
      
         DEST_ID ERROR
      ---------- -----------------------------------------------------------------
               2 ORA-00254: error in archive control string ''
      
      SQL> show parameter log_archive_dest_2
      
      NAME                                 TYPE        VALUE
      ------------------------------------ ----------- ------------------------------
      log_archive_dest_2                   string      SERVICE=ELSSB ASYNC VALID_FOR=
                                                       (ONLINE_LOGFILES,PRIMARY_ROLE)
                                                        DB_UNIQUE_NAME=ELSSB
      
      SQL>
      From drc logfile:
      =
      2011-11-05 22:42:39.636 00001000  1141401601 DMON: Entered rfm_get_chief_lock() for MON_VERIFY, reason 0
      2011-11-05 22:42:39.636 00001000  1141401601 DMON: chief lock convert for client healthcheck
      2011-11-05 22:42:39.637                      INSV: Received message for inter-instance publication
      2011-11-05 22:42:39.637                            req ID 1.1.1141401601, opcode MON_VERIFY, phase BEGIN, flags 5
      2011-11-05 22:42:39.712                      RSM detected log transport problem: log transport for database 'elssb' has the following error.
      2011-11-05 22:42:39.712                        ORA-00254: error in archive control string ''
      2011-11-05 22:42:39.713                      RSM0: HEALTH CHECK ERROR: ORA-16737: the redo transport service for standby database "elssb" has an error
      2011-11-05 22:42:39.898 00000000  1141401601 Operation MON_VERIFY canceled during phase 2, error = ORA-16778
      2011-11-05 22:42:39.904                      INSV: Reply received for message with
      2011-11-05 22:42:39.904                            req ID 1.1.1141401601, opcode MON_VERIFY, phase BEGIN
      2011-11-05 22:42:39.904 00000000  1141401601 Operation MON_VERIFY canceled during phase 2, error = ORA-16778
      2011-11-05 22:42:39.905                      INSV: Received message for inter-instance publication
      2011-11-05 22:42:39.905                            req ID 1.1.1141401601, opcode MON_VERIFY, phase RESYNCH, flags 10005
      2011-11-05 22:42:39.905                      INSV: Reply received for message with
      2011-11-05 22:42:39.905                            req ID 1.1.1141401601, opcode MON_VERIFY, phase RESYNCH
      2011-11-05 22:42:39.906 00000000  1141401601 DMON: Entered rfm_release_chief_lock() for MON_VERIFY
      2011-11-05 22:42:46.713 01010000  1141401602 DMON: MON_PROPERTY operation completed
      2011-11-05 22:42:46.718                      RSM0: Received Get Property Request: rid=0x01010000, pid=47
      2011-11-05 22:42:46.719                      Database Resource: Get Property StatusReport
      2011-11-05 22:42:46.747                      RSM detected log transport problem: log transport for database 'elssb' has the following error.
      2011-11-05 22:42:46.748                        ORA-00254: error in archive control string ''
      2011-11-05 22:42:46.748                      RSM0: HEALTH CHECK ERROR: ORA-16737: the redo transport service for standby database "elssb" has an error
      2011-11-05 22:42:46.940                      Database Resource GetProperty succeeded
      2011-11-05 22:42:46.941 01010000  1141401603 DMON: MON_PROPERTY operation completed
      2011-11-05 22:42:54.974 01010000  1141401604 ORA-16606: unable to find property "logxpt"
      
      2011-11-05 22:42:54.974 01010000  1141401604 DMON: MON_PROPERTY operation completed
      2011-11-05 22:43:07.512                      RSM0: Received Get Property Request: rid=0x01010000, pid=54
      2011-11-05 22:43:07.512                      Database Resource: Get Property LogXptStatus
      2011-11-05 22:43:07.513                      Database Resource GetProperty succeeded
      2011-11-05 22:43:07.513 01010000  1141401605 DMON: MON_PROPERTY operation completed
      2011-11-05 22:43:31.515                      RSM detected log transport problem: log transport for database 'elssb' has the following error.
      2011-11-05 22:43:31.516                        ORA-00254: error in archive control string ''
      2011-11-05 22:43:31.516                      RSM0: HEALTH CHECK ERROR: ORA-16737: the redo transport service for standby database "elssb" has an error
      2011-11-05 22:43:31.702 00000000  1141401606 Operation HEALTH_CHECK canceled during phase 2, error = ORA-16778
      2011-11-05 22:43:31.707 00000000  1141401606 Operation HEALTH_CHECK canceled during phase 2, error = ORA-16778
      Where i failed while i was configuraing standby database? How to solve this trouble?

      Thanks in advance.
        • 1. Re: ORA-00254 | Troubles with dataguard
          sb92075
          bcm@bcm-laptop:~$ oerr ora 16737
          16737, 00000, "the redo transport service for standby database \"%s\" has an error"
          // *Cause:  A communication problem with the standby database caused the redo
          //          transport to fail. 
          // *Action: Query the LogXptStatus property to see the error message. 
          //          Check the Data Guard broker log and Oracle alert log for
          //          more details. 
          bcm@bcm-laptop:~$ oerr ora 254
          00254, 00000, "error in archive control string '%s'"
          // *Cause: The specified archive log location is invalid in the archive
          //         command or the LOG_ARCHIVE_DEST initialization parameter.
          // *Action: Check the archive string used to make sure it refers to a valid
          //      online device.
          bcm@bcm-laptop:~$ oerr ora 16606
          16606, 00000, "unable to find property \"%s\""
          // *Cause:  The specified property did not exist.
          // *Action: Specify a valid property name and reissue the request.
          • 2. Re: ORA-00254 | Troubles with dataguard
            mseberg
            To identify the exact log transport error try this :

            DGMGRL> SHOW DATABASE 'elssb' 'LogXptStatus';
            Best Regards

            mseberg
            • 3. Re: ORA-00254 | Troubles with dataguard
              Web
              Standby database ELSSB
              DGMGRL> show database elssb LogXptStatus
              Error: ORA-16757: unable to get this property's value
              DGMGRL> show database verbose elssb
              
              Database - elssb
              
                Role:            PHYSICAL STANDBY
                Intended State:  APPLY-ON
                Transport Lag:   (unknown)
                Apply Lag:       (unknown)
                Real Time Query: OFF
                Instance(s):
                  ELSSB1 (apply instance)
                  ELSSB2
              
                Properties:
                  DGConnectIdentifier             = 'elssb'
                  ObserverConnectIdentifier       = ''
                  LogXptMode                      = 'ASYNC'
                  DelayMins                       = '0'
                  Binding                         = 'OPTIONAL'
                  MaxFailure                      = '0'
                  MaxConnections                  = '1'
                  ReopenSecs                      = '300'
                  NetTimeout                      = '30'
                  RedoCompression                 = 'DISABLE'
                  LogShipping                     = 'ON'
                  PreferredApplyInstance          = ''
                  ApplyInstanceTimeout            = '0'
                  ApplyParallel                   = 'AUTO'
                  StandbyFileManagement           = 'auto'
                  ArchiveLagTarget                = '0'
                  LogArchiveMaxProcesses          = '5'
                  LogArchiveMinSucceedDest        = '1'
                  DbFileNameConvert               = ''
                  LogFileNameConvert              = ''
                  FastStartFailoverTarget         = ''
                  StatusReport                    = '(monitor)'
                  InconsistentProperties          = '(monitor)'
                  InconsistentLogXptProps         = '(monitor)'
                  SendQEntries                    = '(monitor)'
                  LogXptStatus                    = '(monitor)'
                  RecvQEntries                    = '(monitor)'
                  HostName(*)
                  SidName(*)
                  StaticConnectIdentifier(*)
                  StandbyArchiveLocation(*)
                  AlternateLocation(*)
                  LogArchiveTrace(*)
                  LogArchiveFormat(*)
                  TopWaitEvents(*)
                  (*) - Please check specific instance for the property value
              
              Database Status:
              SUCCESS
              Primary database ELSPR
              DGMGRL> show database elspr logxptstatus
              LOG TRANSPORT STATUS
              PRIMARY_INSTANCE_NAME STANDBY_DATABASE_NAME               STATUS
                              ELS1                elssb ORA-00254: error in archive control string ''
                              ELS2                elssb ORA-00254: error in archive control string ''
              DGMGRL> show database verbose elspr
              
              Database - elspr
              
                Role:            PRIMARY
                Intended State:  TRANSPORT-ON
                Instance(s):
                  ELS1
                    Error: ORA-16737: the redo transport service for standby database "elssb" has an error
              
                  ELS2
                    Error: ORA-16737: the redo transport service for standby database "elssb" has an error
              
                Properties:
                  DGConnectIdentifier             = 'elspr'
                  ObserverConnectIdentifier       = ''
                  LogXptMode                      = 'arch'
                  DelayMins                       = '0'
                  Binding                         = 'optional'
                  MaxFailure                      = '0'
                  MaxConnections                  = '1'
                  ReopenSecs                      = '300'
                  NetTimeout                      = '30'
                  RedoCompression                 = 'DISABLE'
                  LogShipping                     = 'ON'
                  PreferredApplyInstance          = ''
                  ApplyInstanceTimeout            = '0'
                  ApplyParallel                   = 'AUTO'
                  StandbyFileManagement           = 'auto'
                  ArchiveLagTarget                = '0'
                  LogArchiveMaxProcesses          = '5'
                  LogArchiveMinSucceedDest        = '1'
                  DbFileNameConvert               = ''
                  LogFileNameConvert              = ''
                  FastStartFailoverTarget         = ''
                  StatusReport                    = '(monitor)'
                  InconsistentProperties          = '(monitor)'
                  InconsistentLogXptProps         = '(monitor)'
                  SendQEntries                    = '(monitor)'
                  LogXptStatus                    = '(monitor)'
                  RecvQEntries                    = '(monitor)'
                  HostName(*)
                  SidName(*)
                  StaticConnectIdentifier(*)
                  StandbyArchiveLocation(*)
                  AlternateLocation(*)
                  LogArchiveTrace(*)
                  LogArchiveFormat(*)
                  TopWaitEvents(*)
                  (*) - Please check specific instance for the property value
              
              Database Status:
              ERROR
              
              DGMGRL>
              Parameter on primary
              SQL> show parameter
              
              NAME                                 TYPE        VALUE
              ------------------------------------ ----------- ------------------------------
              O7_DICTIONARY_ACCESSIBILITY          boolean     FALSE
              active_instance_count                integer
              aq_tm_processes                      integer     0
              archive_lag_target                   integer     0
              asm_diskgroups                       string
              asm_diskstring                       string
              asm_power_limit                      integer     1
              asm_preferred_read_failure_groups    string
              audit_file_dest                      string      /oracle/app/oracle/admin/ELSPR
                                                               /adump
              audit_sys_operations                 boolean     FALSE
              
              NAME                                 TYPE        VALUE
              ------------------------------------ ----------- ------------------------------
              audit_syslog_level                   string
              audit_trail                          string      DB
              background_core_dump                 string      partial
              background_dump_dest                 string      /oracle/app/oracle/diag/rdbms/
                                                               elspr/ELS1/trace
              backup_tape_io_slaves                boolean     FALSE
              bitmap_merge_area_size               integer     1048576
              blank_trimming                       boolean     FALSE
              buffer_pool_keep                     string
              buffer_pool_recycle                  string
              cell_offload_compaction              string      ADAPTIVE
              
              NAME                                 TYPE        VALUE
              ------------------------------------ ----------- ------------------------------
              cell_offload_decryption              boolean     TRUE
              cell_offload_parameters              string
              cell_offload_plan_display            string      AUTO
              cell_offload_processing              boolean     TRUE
              cell_partition_large_extents         string      DEFAULT
              circuits                             integer
              client_result_cache_lag              big integer 3000
              client_result_cache_size             big integer 0
              cluster_database                     boolean     TRUE
              cluster_database_instances           integer     2
              cluster_interconnects                string
              
              NAME                                 TYPE        VALUE
              ------------------------------------ ----------- ------------------------------
              commit_logging                       string
              commit_point_strength                integer     1
              commit_wait                          string
              commit_write                         string
              compatible                           string      11.2.0.0.0
              control_file_record_keep_time        integer     7
              control_files                        string      +ELSDATA/elspr/controlfile/cur
                                                               rent.299.766427135
              control_management_pack_access       string      DIAGNOSTIC+TUNING
              core_dump_dest                       string      /oracle/app/oracle/diag/rdbms/
                                                               elspr/ELS1/cdump
              
              NAME                                 TYPE        VALUE
              ------------------------------------ ----------- ------------------------------
              cpu_count                            integer     64
              create_bitmap_area_size              integer     8388608
              create_stored_outlines               string
              cursor_sharing                       string      EXACT
              cursor_space_for_time                boolean     FALSE
              db_16k_cache_size                    big integer 0
              db_2k_cache_size                     big integer 0
              db_32k_cache_size                    big integer 0
              db_4k_cache_size                     big integer 0
              db_8k_cache_size                     big integer 0
              db_block_buffers                     integer     0
              
              NAME                                 TYPE        VALUE
              ------------------------------------ ----------- ------------------------------
              db_block_checking                    string      TRUE
              db_block_checksum                    string      TRUE
              db_block_size                        integer     8192
              db_cache_advice                      string      ON
              db_cache_size                        big integer 0
              db_create_file_dest                  string      +ELSDATA
              db_create_online_log_dest_1          string
              db_create_online_log_dest_2          string
              db_create_online_log_dest_3          string
              db_create_online_log_dest_4          string
              db_create_online_log_dest_5          string
              
              NAME                                 TYPE        VALUE
              ------------------------------------ ----------- ------------------------------
              db_domain                            string
              db_file_multiblock_read_count        integer     21
              db_file_name_convert                 string
              db_files                             integer     200
              db_flash_cache_file                  string
              db_flash_cache_size                  big integer 0
              db_flashback_retention_target        integer     1440
              db_keep_cache_size                   big integer 0
              db_lost_write_protect                string      NONE
              db_name                              string      ELS
              db_recovery_file_dest                string
              
              NAME                                 TYPE        VALUE
              ------------------------------------ ----------- ------------------------------
              db_recovery_file_dest_size           big integer 0
              db_recycle_cache_size                big integer 0
              db_securefile                        string      PERMITTED
              db_ultra_safe                        string      OFF
              db_unique_name                       string      ELSPR
              db_writer_processes                  integer     8
              dbwr_io_slaves                       integer     0
              ddl_lock_timeout                     integer     0
              deferred_segment_creation            boolean     TRUE
              dg_broker_config_file1               string      +ELSDATA/elspr/dg3
              dg_broker_config_file2               string      +ELSDATA/elspr/dg4
              
              NAME                                 TYPE        VALUE
              ------------------------------------ ----------- ------------------------------
              dg_broker_start                      boolean     TRUE
              diagnostic_dest                      string      /oracle/app/oracle
              disk_asynch_io                       boolean     TRUE
              dispatchers                          string      (PROTOCOL=TCP) (SERVICE=ELSXDB
                                                               )
              distributed_lock_timeout             integer     60
              dml_locks                            integer     26752
              dst_upgrade_insert_conv              boolean     TRUE
              enable_ddl_logging                   boolean     FALSE
              event                                string
              fal_client                           string      ELS1
              
              NAME                                 TYPE        VALUE
              ------------------------------------ ----------- ------------------------------
              fal_server                           string      ELSSB1, ELSSB2
              fast_start_io_target                 integer     0
              fast_start_mttr_target               integer     0
              fast_start_parallel_rollback         string      LOW
              file_mapping                         boolean     FALSE
              fileio_network_adapters              string
              filesystemio_options                 string      none
              fixed_date                           string
              gcs_server_processes                 integer     4
              global_context_pool_size             string
              global_names                         boolean     FALSE
              
              NAME                                 TYPE        VALUE
              ------------------------------------ ----------- ------------------------------
              global_txn_processes                 integer     1
              hash_area_size                       integer     131072
              hi_shared_memory_address             integer     0
              hs_autoregister                      boolean     TRUE
              ifile                                file
              instance_groups                      string
              instance_name                        string      ELS1
              instance_number                      integer     1
              instance_type                        string      RDBMS
              java_jit_enabled                     boolean     TRUE
              java_max_sessionspace_size           integer     0
              
              NAME                                 TYPE        VALUE
              ------------------------------------ ----------- ------------------------------
              java_pool_size                       big integer 0
              java_soft_sessionspace_limit         integer     0
              job_queue_processes                  integer     1000
              large_pool_size                      big integer 0
              ldap_directory_access                string      NONE
              ldap_directory_sysauth               string      no
              license_max_sessions                 integer     0
              license_max_users                    integer     0
              license_sessions_warning             integer     0
              listener_networks                    string
              local_listener                       string      (DESCRIPTION=(ADDRESS_LIST=(AD
              
              NAME                                 TYPE        VALUE
              ------------------------------------ ----------- ------------------------------
                                                               DRESS=(PROTOCOL=TCP)(HOST=orac
                                                               le3-vip)(PORT=1521))))
              lock_name_space                      string
              lock_sga                             boolean     FALSE
              log_archive_config                   string      dg_config=(ELSPR,elssb)
              log_archive_dest                     string
              log_archive_dest_1                   string      LOCATION=+ELSDATA/ELSPR/archiv
                                                               elog VALID_FOR=(ALL_LOGFILES,A
                                                               LL_ROLES) DB_UNIQUE_NAME=ELSPR
              log_archive_dest_10                  string
              log_archive_dest_11                  string
              
              NAME                                 TYPE        VALUE
              ------------------------------------ ----------- ------------------------------
              log_archive_dest_12                  string
              log_archive_dest_13                  string
              log_archive_dest_14                  string
              log_archive_dest_15                  string
              log_archive_dest_16                  string
              log_archive_dest_17                  string
              log_archive_dest_18                  string
              log_archive_dest_19                  string
              log_archive_dest_2                   string      service="elssb", LGWR ASYNC NO
                                                               AFFIRM delay=0 optional compre
                                                               ssion=disable max_failure=0 ma
              
              NAME                                 TYPE        VALUE
              ------------------------------------ ----------- ------------------------------
                                                               x_connections=1 reopen=300 db_
                                                               unique_name="elssb" net_timeou
                                                               t=30, valid_for=(all_logfiles,
                                                               primary_role)
              log_archive_dest_20                  string
              log_archive_dest_21                  string
              log_archive_dest_22                  string
              log_archive_dest_23                  string
              log_archive_dest_24                  string
              log_archive_dest_25                  string
              log_archive_dest_26                  string
              
              NAME                                 TYPE        VALUE
              ------------------------------------ ----------- ------------------------------
              log_archive_dest_27                  string
              log_archive_dest_28                  string
              log_archive_dest_29                  string
              log_archive_dest_3                   string
              log_archive_dest_30                  string
              log_archive_dest_31                  string
              log_archive_dest_4                   string
              log_archive_dest_5                   string
              log_archive_dest_6                   string
              log_archive_dest_7                   string
              log_archive_dest_8                   string
              
              NAME                                 TYPE        VALUE
              ------------------------------------ ----------- ------------------------------
              log_archive_dest_9                   string
              log_archive_dest_state_1             string      ENABLE
              log_archive_dest_state_10            string      enable
              log_archive_dest_state_11            string      enable
              log_archive_dest_state_12            string      enable
              log_archive_dest_state_13            string      enable
              log_archive_dest_state_14            string      enable
              log_archive_dest_state_15            string      enable
              log_archive_dest_state_16            string      enable
              log_archive_dest_state_17            string      enable
              log_archive_dest_state_18            string      enable
              
              NAME                                 TYPE        VALUE
              ------------------------------------ ----------- ------------------------------
              log_archive_dest_state_19            string      enable
              log_archive_dest_state_2             string      ENABLE
              log_archive_dest_state_20            string      enable
              log_archive_dest_state_21            string      enable
              log_archive_dest_state_22            string      enable
              log_archive_dest_state_23            string      enable
              log_archive_dest_state_24            string      enable
              log_archive_dest_state_25            string      enable
              log_archive_dest_state_26            string      enable
              log_archive_dest_state_27            string      enable
              log_archive_dest_state_28            string      enable
              
              NAME                                 TYPE        VALUE
              ------------------------------------ ----------- ------------------------------
              log_archive_dest_state_29            string      enable
              log_archive_dest_state_3             string      ENABLE
              log_archive_dest_state_30            string      enable
              log_archive_dest_state_31            string      enable
              log_archive_dest_state_4             string      enable
              log_archive_dest_state_5             string      enable
              log_archive_dest_state_6             string      enable
              log_archive_dest_state_7             string      enable
              log_archive_dest_state_8             string      enable
              log_archive_dest_state_9             string      enable
              log_archive_duplex_dest              string
              
              NAME                                 TYPE        VALUE
              ------------------------------------ ----------- ------------------------------
              log_archive_format                   string      %t_%s_%r.dbf
              log_archive_local_first              boolean     TRUE
              log_archive_max_processes            integer     5
              log_archive_min_succeed_dest         integer     1
              log_archive_start                    boolean     FALSE
              log_archive_trace                    integer     0
              log_buffer                           integer     33751040
              log_checkpoint_interval              integer     0
              log_checkpoint_timeout               integer     1800
              log_checkpoints_to_alert             boolean     FALSE
              log_file_name_convert                string
              
              NAME                                 TYPE        VALUE
              ------------------------------------ ----------- ------------------------------
              max_dispatchers                      integer
              max_dump_file_size                   string      unlimited
              max_enabled_roles                    integer     150
              max_shared_servers                   integer
              memory_max_target                    big integer 6400M
              memory_target                        big integer 6400M
              nls_calendar                         string
              nls_comp                             string      BINARY
              nls_currency                         string
              nls_date_format                      string
              nls_date_language                    string
              
              NAME                                 TYPE        VALUE
              ------------------------------------ ----------- ------------------------------
              nls_dual_currency                    string
              nls_iso_currency                     string
              nls_language                         string      AMERICAN
              nls_length_semantics                 string      BYTE
              nls_nchar_conv_excp                  string      FALSE
              nls_numeric_characters               string
              nls_sort                             string
              nls_territory                        string      AMERICA
              nls_time_format                      string
              nls_time_tz_format                   string
              nls_timestamp_format                 string
              
              NAME                                 TYPE        VALUE
              ------------------------------------ ----------- ------------------------------
              nls_timestamp_tz_format              string
              object_cache_max_size_percent        integer     10
              object_cache_optimal_size            integer     102400
              olap_page_pool_size                  big integer 0
              open_cursors                         integer     300
              open_links                           integer     4
              open_links_per_instance              integer     4
              optimizer_capture_sql_plan_baselines boolean     FALSE
              optimizer_dynamic_sampling           integer     2
              optimizer_features_enable            string      11.2.0.1
              optimizer_index_caching              integer     0
              
              NAME                                 TYPE        VALUE
              ------------------------------------ ----------- ------------------------------
              optimizer_index_cost_adj             integer     100
              optimizer_mode                       string      ALL_ROWS
              optimizer_secure_view_merging        boolean     TRUE
              optimizer_use_invisible_indexes      boolean     FALSE
              optimizer_use_pending_statistics     boolean     FALSE
              optimizer_use_sql_plan_baselines     boolean     TRUE
              os_authent_prefix                    string      ops$
              os_roles                             boolean     FALSE
              parallel_adaptive_multi_user         boolean     TRUE
              parallel_automatic_tuning            boolean     FALSE
              parallel_degree_limit                string      CPU
              
              NAME                                 TYPE        VALUE
              ------------------------------------ ----------- ------------------------------
              parallel_degree_policy               string      MANUAL
              parallel_execution_message_size      integer     16384
              parallel_force_local                 boolean     FALSE
              parallel_instance_group              string
              parallel_io_cap_enabled              boolean     FALSE
              parallel_max_servers                 integer     640
              parallel_min_percent                 integer     0
              parallel_min_servers                 integer     0
              parallel_min_time_threshold          string      AUTO
              parallel_server                      boolean     TRUE
              parallel_server_instances            integer     2
              
              NAME                                 TYPE        VALUE
              ------------------------------------ ----------- ------------------------------
              parallel_servers_target              integer     256
              parallel_threads_per_cpu             integer     2
              permit_92_wrap_format                boolean     TRUE
              pga_aggregate_target                 big integer 0
              plscope_settings                     string      IDENTIFIERS:NONE
              plsql_ccflags                        string
              plsql_code_type                      string      INTERPRETED
              plsql_debug                          boolean     FALSE
              plsql_optimize_level                 integer     2
              plsql_v2_compatibility               boolean     FALSE
              plsql_warnings                       string      DISABLE:ALL
              
              NAME                                 TYPE        VALUE
              ------------------------------------ ----------- ------------------------------
              pre_page_sga                         boolean     FALSE
              processes                            integer     4000
              query_rewrite_enabled                string      TRUE
              query_rewrite_integrity              string      enforced
              rdbms_server_dn                      string
              read_only_open_delayed               boolean     FALSE
              recovery_parallelism                 integer     0
              recyclebin                           string      on
              redo_transport_user                  string
              remote_dependencies_mode             string      TIMESTAMP
              remote_listener                      string      LISTENERS_ELS
              
              NAME                                 TYPE        VALUE
              ------------------------------------ ----------- ------------------------------
              remote_login_passwordfile            string      EXCLUSIVE
              remote_os_authent                    boolean     FALSE
              remote_os_roles                      boolean     FALSE
              replication_dependency_tracking      boolean     TRUE
              resource_limit                       boolean     FALSE
              resource_manager_cpu_allocation      integer     64
              resource_manager_plan                string      SCHEDULER[0x3009]:DEFAULT_MAIN
                                                               TENANCE_PLAN
              result_cache_max_result              integer     5
              result_cache_max_size                big integer 16M
              result_cache_mode                    string      MANUAL
              
              NAME                                 TYPE        VALUE
              ------------------------------------ ----------- ------------------------------
              result_cache_remote_expiration       integer     0
              resumable_timeout                    integer     0
              rollback_segments                    string
              sec_case_sensitive_logon             boolean     TRUE
              sec_max_failed_login_attempts        integer     10
              sec_protocol_error_further_action    string      CONTINUE
              sec_protocol_error_trace_action      string      TRACE
              sec_return_server_release_banner     boolean     FALSE
              serial_reuse                         string      disable
              service_names                        string      ELSPR
              session_cached_cursors               integer     50
              
              NAME                                 TYPE        VALUE
              ------------------------------------ ----------- ------------------------------
              session_max_open_files               integer     10
              sessions                             integer     6080
              sga_max_size                         big integer 6400M
              sga_target                           big integer 0
              shadow_core_dump                     string      partial
              shared_memory_address                integer     0
              shared_pool_reserved_size            big integer 128M
              shared_pool_size                     big integer 0
              shared_server_sessions               integer
              shared_servers                       integer     1
              skip_unusable_indexes                boolean     TRUE
              
              NAME                                 TYPE        VALUE
              ------------------------------------ ----------- ------------------------------
              smtp_out_server                      string
              sort_area_retained_size              integer     0
              sort_area_size                       integer     65536
              spfile                               string      +ELSDATA/elspr/spfileelspr.ora
              sql92_security                       boolean     FALSE
              sql_trace                            boolean     FALSE
              sqltune_category                     string      DEFAULT
              standby_archive_dest                 string      ?/dbs/arch
              standby_file_management              string      auto
              star_transformation_enabled          string      FALSE
              statistics_level                     string      TYPICAL
              
              NAME                                 TYPE        VALUE
              ------------------------------------ ----------- ------------------------------
              streams_pool_size                    big integer 0
              tape_asynch_io                       boolean     TRUE
              thread                               integer     1
              timed_os_statistics                  integer     0
              timed_statistics                     boolean     TRUE
              trace_enabled                        boolean     TRUE
              tracefile_identifier                 string
              transactions                         integer     6688
              transactions_per_rollback_segment    integer     5
              undo_management                      string      AUTO
              undo_retention                       integer     900
              
              NAME                                 TYPE        VALUE
              ------------------------------------ ----------- ------------------------------
              undo_tablespace                      string      UNDOTBS1
              use_indirect_data_buffers            boolean     FALSE
              user_dump_dest                       string      /oracle/app/oracle/diag/rdbms/
                                                               elspr/ELS1/trace
              utl_file_dir                         string
              workarea_size_policy                 string      AUTO
              Edited by: Web on Nov 6, 2011 3:44 PM
              • 4. Re: ORA-00254 | Troubles with dataguard
                Web
                Parameter on Standby:
                SQL> show parameter
                
                NAME                                 TYPE        VALUE
                ------------------------------------ ----------- ------------------------------
                O7_DICTIONARY_ACCESSIBILITY          boolean     FALSE
                active_instance_count                integer
                aq_tm_processes                      integer     0
                archive_lag_target                   integer     0
                asm_diskgroups                       string
                asm_diskstring                       string
                asm_power_limit                      integer     1
                asm_preferred_read_failure_groups    string
                audit_file_dest                      string      /oracle/app/oracle/admin/ELSSB
                                                                 /adump
                audit_sys_operations                 boolean     FALSE
                
                NAME                                 TYPE        VALUE
                ------------------------------------ ----------- ------------------------------
                audit_syslog_level                   string
                audit_trail                          string      DB
                background_core_dump                 string      partial
                background_dump_dest                 string      /oracle/app/oracle/diag/rdbms/
                                                                 elssb/ELSSB1/trace
                backup_tape_io_slaves                boolean     FALSE
                bitmap_merge_area_size               integer     1048576
                blank_trimming                       boolean     FALSE
                buffer_pool_keep                     string
                buffer_pool_recycle                  string
                cell_offload_compaction              string      ADAPTIVE
                
                NAME                                 TYPE        VALUE
                ------------------------------------ ----------- ------------------------------
                cell_offload_decryption              boolean     TRUE
                cell_offload_parameters              string
                cell_offload_plan_display            string      AUTO
                cell_offload_processing              boolean     TRUE
                cell_partition_large_extents         string      DEFAULT
                circuits                             integer
                client_result_cache_lag              big integer 3000
                client_result_cache_size             big integer 0
                cluster_database                     boolean     TRUE
                cluster_database_instances           integer     2
                cluster_interconnects                string
                
                NAME                                 TYPE        VALUE
                ------------------------------------ ----------- ------------------------------
                commit_logging                       string
                commit_point_strength                integer     1
                commit_wait                          string
                commit_write                         string
                compatible                           string      11.2.0.0.0
                control_file_record_keep_time        integer     7
                control_files                        string      +ELSDATA/elssb/controlfile/cur
                                                                 rent.271.766444669
                control_management_pack_access       string      DIAGNOSTIC+TUNING
                core_dump_dest                       string      /oracle/app/oracle/diag/rdbms/
                                                                 elssb/ELSSB1/cdump
                
                NAME                                 TYPE        VALUE
                ------------------------------------ ----------- ------------------------------
                cpu_count                            integer     64
                create_bitmap_area_size              integer     8388608
                create_stored_outlines               string
                cursor_sharing                       string      EXACT
                cursor_space_for_time                boolean     FALSE
                db_16k_cache_size                    big integer 0
                db_2k_cache_size                     big integer 0
                db_32k_cache_size                    big integer 0
                db_4k_cache_size                     big integer 0
                db_8k_cache_size                     big integer 0
                db_block_buffers                     integer     0
                
                NAME                                 TYPE        VALUE
                ------------------------------------ ----------- ------------------------------
                db_block_checking                    string      TRUE
                db_block_checksum                    string      TRUE
                db_block_size                        integer     8192
                db_cache_advice                      string      ON
                db_cache_size                        big integer 0
                db_create_file_dest                  string      +ELSDATA
                db_create_online_log_dest_1          string
                db_create_online_log_dest_2          string
                db_create_online_log_dest_3          string
                db_create_online_log_dest_4          string
                db_create_online_log_dest_5          string
                
                NAME                                 TYPE        VALUE
                ------------------------------------ ----------- ------------------------------
                db_domain                            string
                db_file_multiblock_read_count        integer     21
                db_file_name_convert                 string
                db_files                             integer     200
                db_flash_cache_file                  string
                db_flash_cache_size                  big integer 0
                db_flashback_retention_target        integer     1440
                db_keep_cache_size                   big integer 0
                db_lost_write_protect                string      NONE
                db_name                              string      ELS
                db_recovery_file_dest                string
                
                NAME                                 TYPE        VALUE
                ------------------------------------ ----------- ------------------------------
                db_recovery_file_dest_size           big integer 0
                db_recycle_cache_size                big integer 0
                db_securefile                        string      PERMITTED
                db_ultra_safe                        string      OFF
                db_unique_name                       string      ELSSB
                db_writer_processes                  integer     8
                dbwr_io_slaves                       integer     0
                ddl_lock_timeout                     integer     0
                deferred_segment_creation            boolean     TRUE
                dg_broker_config_file1               string      +ELSDATA/elssb/dg3
                dg_broker_config_file2               string      +ELSDATA/elssb/dg4
                
                NAME                                 TYPE        VALUE
                ------------------------------------ ----------- ------------------------------
                dg_broker_start                      boolean     TRUE
                diagnostic_dest                      string      /oracle/app/oracle
                disk_asynch_io                       boolean     TRUE
                dispatchers                          string      (PROTOCOL=TCP) (SERVICE=ELSXDB
                                                                 )
                distributed_lock_timeout             integer     60
                dml_locks                            integer     26752
                dst_upgrade_insert_conv              boolean     TRUE
                enable_ddl_logging                   boolean     FALSE
                event                                string
                fal_client                           string      ELSSB1
                
                NAME                                 TYPE        VALUE
                ------------------------------------ ----------- ------------------------------
                fal_server                           string      elspr
                fast_start_io_target                 integer     0
                fast_start_mttr_target               integer     0
                fast_start_parallel_rollback         string      LOW
                file_mapping                         boolean     FALSE
                fileio_network_adapters              string
                filesystemio_options                 string      none
                fixed_date                           string
                gcs_server_processes                 integer     4
                global_context_pool_size             string
                global_names                         boolean     FALSE
                
                NAME                                 TYPE        VALUE
                ------------------------------------ ----------- ------------------------------
                global_txn_processes                 integer     1
                hash_area_size                       integer     131072
                hi_shared_memory_address             integer     0
                hs_autoregister                      boolean     TRUE
                ifile                                file
                instance_groups                      string
                instance_name                        string      ELSSB1
                instance_number                      integer     1
                instance_type                        string      RDBMS
                java_jit_enabled                     boolean     TRUE
                java_max_sessionspace_size           integer     0
                
                NAME                                 TYPE        VALUE
                ------------------------------------ ----------- ------------------------------
                java_pool_size                       big integer 0
                java_soft_sessionspace_limit         integer     0
                job_queue_processes                  integer     1000
                large_pool_size                      big integer 0
                ldap_directory_access                string      NONE
                ldap_directory_sysauth               string      no
                license_max_sessions                 integer     0
                license_max_users                    integer     0
                license_sessions_warning             integer     0
                listener_networks                    string
                local_listener                       string      (DESCRIPTION=(ADDRESS_LIST=(AD
                
                NAME                                 TYPE        VALUE
                ------------------------------------ ----------- ------------------------------
                                                                 DRESS=(PROTOCOL=TCP)(HOST=orac
                                                                 le1-vip)(PORT=1521))))
                lock_name_space                      string
                lock_sga                             boolean     FALSE
                log_archive_config                   string      dg_config=(ELSSB,elspr)
                log_archive_dest                     string
                log_archive_dest_1                   string      location=+ELSDATA/ELSSB/archiv
                                                                 elog
                log_archive_dest_10                  string
                log_archive_dest_11                  string
                log_archive_dest_12                  string
                
                NAME                                 TYPE        VALUE
                ------------------------------------ ----------- ------------------------------
                log_archive_dest_13                  string
                log_archive_dest_14                  string
                log_archive_dest_15                  string
                log_archive_dest_16                  string
                log_archive_dest_17                  string
                log_archive_dest_18                  string
                log_archive_dest_19                  string
                log_archive_dest_2                   string      service=ELSPR ARCH DB_UNIQUE_N
                                                                 AME=ELSPR VALID_FOR=(ONLINE_LO
                                                                 GFILES,PRIMARY_ROLE)
                log_archive_dest_20                  string
                
                NAME                                 TYPE        VALUE
                ------------------------------------ ----------- ------------------------------
                log_archive_dest_21                  string
                log_archive_dest_22                  string
                log_archive_dest_23                  string
                log_archive_dest_24                  string
                log_archive_dest_25                  string
                log_archive_dest_26                  string
                log_archive_dest_27                  string
                log_archive_dest_28                  string
                log_archive_dest_29                  string
                log_archive_dest_3                   string
                log_archive_dest_30                  string
                
                NAME                                 TYPE        VALUE
                ------------------------------------ ----------- ------------------------------
                log_archive_dest_31                  string
                log_archive_dest_4                   string
                log_archive_dest_5                   string
                log_archive_dest_6                   string
                log_archive_dest_7                   string
                log_archive_dest_8                   string
                log_archive_dest_9                   string
                log_archive_dest_state_1             string      enable
                log_archive_dest_state_10            string      enable
                log_archive_dest_state_11            string      enable
                log_archive_dest_state_12            string      enable
                
                NAME                                 TYPE        VALUE
                ------------------------------------ ----------- ------------------------------
                log_archive_dest_state_13            string      enable
                log_archive_dest_state_14            string      enable
                log_archive_dest_state_15            string      enable
                log_archive_dest_state_16            string      enable
                log_archive_dest_state_17            string      enable
                log_archive_dest_state_18            string      enable
                log_archive_dest_state_19            string      enable
                log_archive_dest_state_2             string      enable
                log_archive_dest_state_20            string      enable
                log_archive_dest_state_21            string      enable
                log_archive_dest_state_22            string      enable
                
                NAME                                 TYPE        VALUE
                ------------------------------------ ----------- ------------------------------
                log_archive_dest_state_23            string      enable
                log_archive_dest_state_24            string      enable
                log_archive_dest_state_25            string      enable
                log_archive_dest_state_26            string      enable
                log_archive_dest_state_27            string      enable
                log_archive_dest_state_28            string      enable
                log_archive_dest_state_29            string      enable
                log_archive_dest_state_3             string      enable
                log_archive_dest_state_30            string      enable
                log_archive_dest_state_31            string      enable
                log_archive_dest_state_4             string      enable
                
                NAME                                 TYPE        VALUE
                ------------------------------------ ----------- ------------------------------
                log_archive_dest_state_5             string      enable
                log_archive_dest_state_6             string      enable
                log_archive_dest_state_7             string      enable
                log_archive_dest_state_8             string      enable
                log_archive_dest_state_9             string      enable
                log_archive_duplex_dest              string
                log_archive_format                   string      %t_%s_%r.dbf
                log_archive_local_first              boolean     TRUE
                log_archive_max_processes            integer     5
                log_archive_min_succeed_dest         integer     1
                log_archive_start                    boolean     FALSE
                
                NAME                                 TYPE        VALUE
                ------------------------------------ ----------- ------------------------------
                log_archive_trace                    integer     0
                log_buffer                           integer     33751040
                log_checkpoint_interval              integer     0
                log_checkpoint_timeout               integer     1800
                log_checkpoints_to_alert             boolean     FALSE
                log_file_name_convert                string
                max_dispatchers                      integer
                max_dump_file_size                   string      unlimited
                max_enabled_roles                    integer     150
                max_shared_servers                   integer
                memory_max_target                    big integer 6400M
                
                NAME                                 TYPE        VALUE
                ------------------------------------ ----------- ------------------------------
                memory_target                        big integer 6400M
                nls_calendar                         string
                nls_comp                             string      BINARY
                nls_currency                         string
                nls_date_format                      string
                nls_date_language                    string
                nls_dual_currency                    string
                nls_iso_currency                     string
                nls_language                         string      AMERICAN
                nls_length_semantics                 string      BYTE
                nls_nchar_conv_excp                  string      FALSE
                
                NAME                                 TYPE        VALUE
                ------------------------------------ ----------- ------------------------------
                nls_numeric_characters               string
                nls_sort                             string
                nls_territory                        string      AMERICA
                nls_time_format                      string
                nls_time_tz_format                   string
                nls_timestamp_format                 string
                nls_timestamp_tz_format              string
                object_cache_max_size_percent        integer     10
                object_cache_optimal_size            integer     102400
                olap_page_pool_size                  big integer 0
                open_cursors                         integer     300
                
                NAME                                 TYPE        VALUE
                ------------------------------------ ----------- ------------------------------
                open_links                           integer     4
                open_links_per_instance              integer     4
                optimizer_capture_sql_plan_baselines boolean     FALSE
                optimizer_dynamic_sampling           integer     2
                optimizer_features_enable            string      11.2.0.1
                optimizer_index_caching              integer     0
                optimizer_index_cost_adj             integer     100
                optimizer_mode                       string      ALL_ROWS
                optimizer_secure_view_merging        boolean     TRUE
                optimizer_use_invisible_indexes      boolean     FALSE
                optimizer_use_pending_statistics     boolean     FALSE
                
                NAME                                 TYPE        VALUE
                ------------------------------------ ----------- ------------------------------
                optimizer_use_sql_plan_baselines     boolean     TRUE
                os_authent_prefix                    string      ops$
                os_roles                             boolean     FALSE
                parallel_adaptive_multi_user         boolean     TRUE
                parallel_automatic_tuning            boolean     FALSE
                parallel_degree_limit                string      CPU
                parallel_degree_policy               string      MANUAL
                parallel_execution_message_size      integer     16384
                parallel_force_local                 boolean     FALSE
                parallel_instance_group              string
                parallel_io_cap_enabled              boolean     FALSE
                
                NAME                                 TYPE        VALUE
                ------------------------------------ ----------- ------------------------------
                parallel_max_servers                 integer     640
                parallel_min_percent                 integer     0
                parallel_min_servers                 integer     0
                parallel_min_time_threshold          string      AUTO
                parallel_server                      boolean     TRUE
                parallel_server_instances            integer     2
                parallel_servers_target              integer     256
                parallel_threads_per_cpu             integer     2
                permit_92_wrap_format                boolean     TRUE
                pga_aggregate_target                 big integer 0
                plscope_settings                     string      IDENTIFIERS:NONE
                
                NAME                                 TYPE        VALUE
                ------------------------------------ ----------- ------------------------------
                plsql_ccflags                        string
                plsql_code_type                      string      INTERPRETED
                plsql_debug                          boolean     FALSE
                plsql_optimize_level                 integer     2
                plsql_v2_compatibility               boolean     FALSE
                plsql_warnings                       string      DISABLE:ALL
                pre_page_sga                         boolean     FALSE
                processes                            integer     4000
                query_rewrite_enabled                string      TRUE
                query_rewrite_integrity              string      enforced
                rdbms_server_dn                      string
                
                NAME                                 TYPE        VALUE
                ------------------------------------ ----------- ------------------------------
                read_only_open_delayed               boolean     FALSE
                recovery_parallelism                 integer     0
                recyclebin                           string      on
                redo_transport_user                  string
                remote_dependencies_mode             string      TIMESTAMP
                remote_listener                      string      LISTENERS_ELSSB
                remote_login_passwordfile            string      EXCLUSIVE
                remote_os_authent                    boolean     FALSE
                remote_os_roles                      boolean     FALSE
                replication_dependency_tracking      boolean     TRUE
                resource_limit                       boolean     FALSE
                
                NAME                                 TYPE        VALUE
                ------------------------------------ ----------- ------------------------------
                resource_manager_cpu_allocation      integer     64
                resource_manager_plan                string
                result_cache_max_result              integer     5
                result_cache_max_size                big integer 16M
                result_cache_mode                    string      MANUAL
                result_cache_remote_expiration       integer     0
                resumable_timeout                    integer     0
                rollback_segments                    string
                sec_case_sensitive_logon             boolean     TRUE
                sec_max_failed_login_attempts        integer     10
                sec_protocol_error_further_action    string      CONTINUE
                
                NAME                                 TYPE        VALUE
                ------------------------------------ ----------- ------------------------------
                sec_protocol_error_trace_action      string      TRACE
                sec_return_server_release_banner     boolean     FALSE
                serial_reuse                         string      disable
                service_names                        string      ELSSB
                session_cached_cursors               integer     50
                session_max_open_files               integer     10
                sessions                             integer     6080
                sga_max_size                         big integer 6400M
                sga_target                           big integer 0
                shadow_core_dump                     string      partial
                shared_memory_address                integer     0
                
                NAME                                 TYPE        VALUE
                ------------------------------------ ----------- ------------------------------
                shared_pool_reserved_size            big integer 128M
                shared_pool_size                     big integer 0
                shared_server_sessions               integer
                shared_servers                       integer     1
                skip_unusable_indexes                boolean     TRUE
                smtp_out_server                      string
                sort_area_retained_size              integer     0
                sort_area_size                       integer     65536
                spfile                               string      +ELSDATA/elssb/spfileelssb.ora
                sql92_security                       boolean     FALSE
                sql_trace                            boolean     FALSE
                
                NAME                                 TYPE        VALUE
                ------------------------------------ ----------- ------------------------------
                sqltune_category                     string      DEFAULT
                standby_archive_dest                 string      ?/dbs/arch
                standby_file_management              string      auto
                star_transformation_enabled          string      FALSE
                statistics_level                     string      TYPICAL
                streams_pool_size                    big integer 0
                tape_asynch_io                       boolean     TRUE
                thread                               integer     1
                timed_os_statistics                  integer     0
                timed_statistics                     boolean     TRUE
                trace_enabled                        boolean     TRUE
                
                NAME                                 TYPE        VALUE
                ------------------------------------ ----------- ------------------------------
                tracefile_identifier                 string
                transactions                         integer     6688
                transactions_per_rollback_segment    integer     5
                undo_management                      string      AUTO
                undo_retention                       integer     900
                undo_tablespace                      string
                use_indirect_data_buffers            boolean     FALSE
                user_dump_dest                       string      /oracle/app/oracle/diag/rdbms/
                                                                 elssb/ELSSB1/trace
                utl_file_dir                         string
                workarea_size_policy                 string      AUTO
                
                NAME                                 TYPE        VALUE
                ------------------------------------ ----------- ------------------------------
                xml_db_events                        string      enable
                dataguard log on standby :
                2011-11-06 15:47:09.607 02010a g000   617668004 DMON: MON_PROPERTY operation completed
                2011-11-06 15:47:24.475                      RSM0: Received Get Property Request: rid=0x02010000, pid=54
                2011-11-06 15:47:24.476                      Database Resource: Get Property LogXptStatus
                2011-11-06 15:47:24.476                      RSM error: trying to query a primary-type property 'LogXptStatus' on a standby database resource.
                2011-11-06 15:47:24.476                      Database Resource GetProperty Error (16501,16757)
                Edited by: Web on Nov 6, 2011 3:44 PM
                • 5. Re: ORA-00254 | Troubles with dataguard
                  mseberg
                  Almost certain the problem is with these parameters:

                  log_archive_dest_1

                  log_archive_dest_2


                  Reviewing :

                  Here's what I would consider :

                  Primary

                  log_archive_dest_1 (looks good as is no change)

                  LOCATION=+ELSDATA/ELSPR/archivelog VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=ELSPR

                  log_archive_dest_2

                  service=ELSSB ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=ELSSB


                  Notes: Current setting has several issues, the double quotes around elssb, too many parameters to trouble shoot.

                  Standby

                  log_archive_dest_1


                  location=+ELSDATA/ELSSB/archivelog VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=ELSSB

                  log_archive_dest_2

                  service=ELSPR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=ELSPR



                  Great details!





                  Best Regards

                  mseberg

                  Edited by: mseberg on Nov 6, 2011 7:09 AM



                  More information



                  FAL_SERVER is set incorrectly on Primary



                  Currently

                  ELSSB1, ELSSB2


                  FAL_SERVER specifies the FAL (fetch archive log) server for a Standby database. The value is an Oracle Net service name.



                  FAL_CLIENT appears to have mismatched names on both Primary and Standby



                  The value is an Oracle Net service name, which is assumed to be configured properly on the FAL server system to point to the FAL client (standby database).



                  STANDBY_FILE_MANAGEMENT - correctly set on both systems.


                  DB_UNIQUE_NAME is set to a different value than db_name on the Primary, they should match on the Primary

                  LOG_ARCHIVE_DEST_STATE_1 - correctly set on both systems.

                  LOG_ARCHIVE_DEST_STATE_2 is set to ENABLE on the Standby. this will cause issues, it should be DEFER.
                  Correct on the Primary.


                  LOG_ARCHIVE_MAX_PROCESSES - is set to 5 on both systems, Kind of low. Can be set higher up to 30.

                  Edited by: mseberg on Nov 6, 2011 7:31 AM


                  Make sure you have _DGMGRL set in your listener if you have not done so already.

                  Example :


                  http://www.visi.com/~mseberg/Data_Guard_Listener_Example.html

                  Edited by: mseberg on Nov 6, 2011 7:33 AM