This discussion is archived
5 Replies Latest reply: Nov 6, 2011 5:34 AM by mseberg RSS

ORA-00254 | Troubles with dataguard

743274 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    To identify the exact log transport error try this :

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

    mseberg
  • 3. Re: ORA-00254 | Troubles with dataguard
    743274 Newbie
    Currently Being Moderated
    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
    743274 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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

Legend

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