This discussion is archived
9 Replies Latest reply: Dec 4, 2012 2:10 PM by 975078 RSS

Dataguard not applying shipping logs / Sessions Active on Standby

975078 Newbie
Currently Being Moderated
I'm sure this is a simple one, but I can't seem to figure out why after a switchover, my logs aren't being shipped.

Can someone help and tell me what is going wrong here?
Prim:

SQL> select max (sequence#) current_seq from v$log;

CURRENT_SEQ
-----------
       1328

20:18:08 SYS: ECPMT> select switchover_status from v$database;

SWITCHOVER_STATUS
--------------------
SESSIONS ACTIVE

20:14:58 SYS: ECPMT> select database_role from v$database;

DATABASE_ROLE
----------------
PRIMARY


SB:
SQL> select MAX (SEQUENCE#), APPLIED FROM V$ARCHIVED_LOG where APPLIED ='YES' GROUP BY APPLIED;

MAX(SEQUENCE#) APPLIED
-------------- ---------
          1344 YES


SQL> select process, client_process, sequence#, status from v$managed_standby;

PROCESS   CLIENT_P  SEQUENCE# STATUS
--------- -------- ---------- ------------
ARCH      ARCH              0 CONNECTED
ARCH      ARCH              0 CONNECTED
ARCH      ARCH              0 CONNECTED
ARCH      ARCH              0 CONNECTED
ARCH      ARCH              0 CONNECTED
ARCH      ARCH              0 CONNECTED
ARCH      ARCH              0 CONNECTED
ARCH      ARCH              0 CONNECTED
ARCH      ARCH              0 CONNECTED
ARCH      ARCH              0 CONNECTED
ARCH      ARCH              0 CONNECTED

PROCESS   CLIENT_P  SEQUENCE# STATUS
--------- -------- ---------- ------------
ARCH      ARCH              0 CONNECTED
ARCH      ARCH              0 CONNECTED
ARCH      ARCH              0 CONNECTED
ARCH      ARCH              0 CONNECTED
ARCH      ARCH              0 CONNECTED
ARCH      ARCH              0 CONNECTED
ARCH      ARCH              0 CONNECTED
ARCH      ARCH              0 CONNECTED
ARCH      ARCH              0 CONNECTED
ARCH      ARCH              0 CONNECTED
ARCH      ARCH              0 CONNECTED

PROCESS   CLIENT_P  SEQUENCE# STATUS
--------- -------- ---------- ------------
ARCH      ARCH              0 CONNECTED
ARCH      ARCH              0 CONNECTED
ARCH      ARCH              0 CONNECTED
ARCH      ARCH              0 CONNECTED
ARCH      ARCH              0 CONNECTED
ARCH      ARCH              0 CONNECTED
ARCH      ARCH              0 CONNECTED
ARCH      ARCH              0 CONNECTED
MRP0      N/A            1322 WAIT_FOR_LOG

Primary :
20:11:30 SYS: ECPMT> show parameter dest_

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
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
db_recovery_file_dest_size           big integer 50G
log_archive_dest_1                   string      LOCATION=USE_DB_RECOVERY_FILE_
                                                 DEST VALID_FOR=(ALL_LOGFILES,A
                                                 LL_ROLES) DB_UNIQUE_NAME=ECPMT
                                                 SB
log_archive_dest_10                  string
log_archive_dest_2                   string      SERVICE=ECPMT VALID_FOR=(ONLIN
                                                 E_LOGFILES,PRIMARY_ROLE) DB_UN
                                                 IQUE_NAME=ECPMT
log_archive_dest_3                   string      LOCATION=+FRA_DG_01/ecpmtsb/st
                                                 andbylog  VALID_FOR=(STANDBY_L
                                                 OGFILES,STANDBY_ROLE) DB_UNIQU
                                                 E_NAME=ECPMTSB
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_2             string      DEFER
log_archive_dest_state_3             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

Standby:

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
db_recovery_file_dest_size           big integer 20G
log_archive_dest_1                   string      LOCATION=USE_DB_RECOVERY_FILE_
                                                 DEST VALID_FOR=(ALL_LOGFILES,A
                                                 LL_ROLES) DB_UNIQUE_NAME=ECPMT
log_archive_dest_10                  string
log_archive_dest_2                   string      SERVICE=ecpmtsb LGWR ASYNC VAL
                                                 ID_FOR=(ONLINE_LOGFILES,PRIMAR
                                                 Y_ROLE) DB_UNIQUE_NAME=ecpmtsb

log_archive_dest_3                   string      LOCATION=+FRA_DG_01/ecpmt/stan
                                                 dbylog  VALID_FOR=(STANDBY_LOG
                                                 FILES,STANDBY_ROLE) DB_UNIQUE_
                                                 NAME=ECPMT
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_2             string      ENABLE

log_archive_dest_state_3             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

SQL> select switchover_status from v$database;

SESSIONS ACTIVE

SQL> select database_role from v$database;

PHYSICAL STANDBY
Thanks in advance!

Edited by: BostonDBA on Dec 4, 2012 3:18 PM
  • 1. Re: Dataguard not applying shipping logs / Sessions Active on Standby
    mseberg Guru
    Currently Being Moderated
    Hello;

    Is there an error in either alert log?

    Best Regards

    mseberg
  • 2. Re: Dataguard not applying shipping logs / Sessions Active on Standby
    975078 Newbie
    Currently Being Moderated
    That's the thing, no error in the alert log.

    On Standby:
    Attempt to start background Managed Standby Recovery process (ECPMT1)
    Tue Dec 04 20:14:14 2012
    MRP0 started with pid=33, OS id=14526
    MRP0: Background Managed Standby Recovery process started (ECPMT1)
    Fast Parallel Media Recovery enabled
    Tue Dec 04 20:14:19 2012
    Managed Standby Recovery starting Real Time Apply
     parallel recovery started with 8 processes
    Waiting for all non-current ORLs to be archived...
    All non-current ORLs have been archived.
    Media Recovery Waiting for thread 1 sequence 1322
    Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION
    It seems to be stuck on seq 1322.

    On Primary:
    Thread 1 advanced to log sequence 1326 (LGWR switch)
      Current log# 1 seq# 1326 mem# 0: +FRA_DG_01/ecpmtsb/onlinelog/group_1.402.801169497
    Tue Dec 04 19:56:53 2012
    Archived Log entry 12 added for thread 1 sequence 1325 ID 0xec73e4a2 dest 1:
    Thread 1 cannot allocate new log, sequence 1327
    Checkpoint not complete
      Current log# 1 seq# 1326 mem# 0: +FRA_DG_01/ecpmtsb/onlinelog/group_1.402.801169497
    Thread 1 advanced to log sequence 1327 (LGWR switch)
      Current log# 2 seq# 1327 mem# 0: +FRA_DG_01/ecpmtsb/onlinelog/group_2.401.801169497
    Tue Dec 04 19:57:00 2012
    Archived Log entry 13 added for thread 1 sequence 1326 ID 0xec73e4a2 dest 1:
    Tue Dec 04 19:57:08 2012
    Thread 1 cannot allocate new log, sequence 1328
    Checkpoint not complete
      Current log# 2 seq# 1327 mem# 0: +FRA_DG_01/ecpmtsb/onlinelog/group_2.401.801169497
    Thread 1 advanced to log sequence 1328 (LGWR switch)
      Current log# 1 seq# 1328 mem# 0: +FRA_DG_01/ecpmtsb/onlinelog/group_1.402.801169497
    Tue Dec 04 19:57:09 2012
    Archived Log entry 14 added for thread 1 sequence 1327 ID 0xec73e4a2 dest 1:
    Thanks MSeBerg!

    Edited by: BostonDBA on Dec 4, 2012 3:22 PM
  • 3. Re: Dataguard not applying shipping logs / Sessions Active on Standby
    mseberg Guru
    Currently Being Moderated
    Agreed 1322.

    From both servers you can connect a sys to the service shown in the INIT to the other server?

    ( I'm thinking yes or the alert would have an error )

    Humor me and run this on the new primary

    alter system set log_archive_dest_state_3=enable;

    Does this always switch logs that fast ??

    Best Regards

    h3. Later

    Should I be worried??


    mseberg

    Edited by: mseberg on Dec 4, 2012 2:29 PM
  • 4. Re: Dataguard not applying shipping logs / Sessions Active on Standby
    975078 Newbie
    Currently Being Moderated
    Mseberg,

    I actually switched the logfiles to check the sequence number and whether RFS was showing up in the log, but it didn't illuminate anything.

    I ran the enable on the Primary, was thinking that may have been the case as well. Here's the parameter of both DB's in case there's something I am missing:
    Primary:
    
    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      /data/oracle/app/oracle/admin/
                                                     ECPMTSB/adump
    audit_sys_operations                 boolean     FALSE
    audit_syslog_level                   string
    audit_trail                          string      NONE
    background_core_dump                 string      partial
    background_dump_dest                 string      /data/oracle/app/oracle/diag/r
                                                     dbms/ecpmtsb/ECPMTSB/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
    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     FALSE
    cluster_database_instances           integer     1
    cluster_interconnects                string
    commit_logging                       string
    commit_point_strength                integer     1
    commit_wait                          string
    commit_write                         string
    compatible                           string      11.1.0.0.0
    control_file_record_keep_time        integer     7
    control_files                        string      +DG_01/ecpmtsb/controlfile/con
                                                     trol1.ora, +FRA_DG_01/ecpmtsb/
                                                     controlfile/control2.ora
    control_management_pack_access       string      DIAGNOSTIC+TUNING
    core_dump_dest                       string      /data/oracle/app/oracle/admin/
                                                     ECPMTSB/cdump
    cpu_count                            integer     12
    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
    db_block_checking                    string      FALSE
    db_block_checksum                    string      TYPICAL
    db_block_size                        integer     8192
    db_cache_advice                      string      ON
    db_cache_size                        big integer 0
    db_create_file_dest                  string
    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
    db_domain                            string
    db_file_multiblock_read_count        integer     128
    db_file_name_convert                 string      +DG_01/ecpmt, +DG_01/ECPMTSB
    db_files                             integer     2000
    db_flashback_retention_target        integer     1440
    db_keep_cache_size                   big integer 0
    db_lost_write_protect                string      NONE
    db_name                              string      ECPMT
    db_recovery_file_dest                string      +FRA_DG_01
    db_recovery_file_dest_size           big integer 50G
    db_recycle_cache_size                big integer 0
    db_securefile                        string      PERMITTED
    db_ultra_safe                        string      OFF
    db_unique_name                       string      ECPMTSB
    db_writer_processes                  integer     2
    dbwr_io_slaves                       integer     0
    ddl_lock_timeout                     integer     0
    dg_broker_config_file1               string      +DG_01/ecpmtsb/dgbroker/dg_con
                                                     fig_file1.dat
    dg_broker_config_file2               string      +FRA_DG_01/ecpmtsb/dgbroker/dg
                                                     _config_file2.dat
    dg_broker_start                      boolean     FALSE
    diagnostic_dest                      string      /data/oracle/app/oracle
    disk_asynch_io                       boolean     TRUE
    dispatchers                          string      (PROTOCOL=TCP) (SERVICE=ECPMTS
                                                     BXDB)
    distributed_lock_timeout             integer     60
    dml_locks                            integer     748
    drs_start                            boolean     FALSE
    enable_ddl_logging                   boolean     FALSE
    event                                string
    fal_client                           string      ECPMTSB
    fal_server                           string      ECPMT
    
    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
    gc_files_to_locks                    string
    gcs_server_processes                 integer     0
    global_context_pool_size             string
    global_names                         boolean     FALSE
    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      ECPMTSB
    instance_number                      integer     0
    instance_type                        string      RDBMS
    java_jit_enabled                     boolean     TRUE
    java_max_sessionspace_size           integer     0
    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
    local_listener                       string
    lock_name_space                      string
    lock_sga                             boolean     FALSE
    log_archive_config                   string      DG_CONFIG=(ECPMT,ECPMTSB)
    log_archive_dest                     string
    log_archive_dest_1                   string      LOCATION=USE_DB_RECOVERY_FILE_
                                                     DEST VALID_FOR=(ALL_LOGFILES,A
                                                     LL_ROLES) DB_UNIQUE_NAME=ECPMT
                                                     SB
    log_archive_dest_10                  string
    log_archive_dest_2                   string      SERVICE=ECPMT VALID_FOR=(ONLIN
                                                     E_LOGFILES,PRIMARY_ROLE) DB_UN
                                                     IQUE_NAME=ECPMT
    log_archive_dest_3                   string      LOCATION=+FRA_DG_01/ecpmtsb/st
                                                     andbylog  VALID_FOR=(STANDBY_L
                                                     OGFILES,STANDBY_ROLE) DB_UNIQU
                                                     E_NAME=ECPMTSB
    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_2             string      DEFER
    log_archive_dest_state_3             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
    log_archive_format                   string      %t_%s_%r.dbf
    log_archive_local_first              boolean     TRUE
    log_archive_max_processes            integer     7
    log_archive_min_succeed_dest         integer     2
    log_archive_start                    boolean     FALSE
    log_archive_trace                    integer     0
    log_buffer                           integer     7049216
    log_checkpoint_interval              integer     0
    log_checkpoint_timeout               integer     1800
    log_checkpoints_to_alert             boolean     FALSE
    log_file_name_convert                string      +FRA_DG_01/ecpmt, +FRA_DG_01/E
                                                     CPMTSB, +DG_01/ecpmt, +DG_01/E
                                                     CPMTSB
    max_commit_propagation_delay         integer     0
    max_dispatchers                      integer
    max_dump_file_size                   string      unlimited
    max_enabled_roles                    integer     150
    max_shared_servers                   integer
    memory_max_target                    big integer 0
    memory_target                        big integer 0
    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
    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
    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.1.0.7
    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
    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_execution_message_size      integer     2152
    parallel_instance_group              string
    parallel_io_cap_enabled              boolean     FALSE
    parallel_max_servers                 integer     135
    parallel_min_percent                 integer     0
    parallel_min_servers                 integer     0
    parallel_server                      boolean     FALSE
    parallel_server_instances            integer     1
    parallel_threads_per_cpu             integer     2
    pga_aggregate_target                 big integer 216M
    plscope_settings                     string      IDENTIFIERS:NONE
    plsql_ccflags                        string
    plsql_code_type                      string      INTERPRETED
    plsql_debug                          boolean     FALSE
    plsql_native_library_dir             string
    plsql_native_library_subdir_count    integer     0
    plsql_optimize_level                 integer     2
    plsql_v2_compatibility               boolean     FALSE
    plsql_warnings                       string      DISABLE:ALL
    pre_page_sga                         boolean     FALSE
    processes                            integer     150
    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
    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     12
    resource_manager_plan                string
    result_cache_max_result              integer     5
    result_cache_max_size                big integer 3328K
    result_cache_mode                    string      MANUAL
    result_cache_remote_expiration       integer     0
    resumable_timeout                    integer     0
    rollback_segments                    string
    sec_case_sensitive_logon             boolean     FALSE
    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      ECPMTSB
    session_cached_cursors               integer     50
    session_max_open_files               integer     10
    sessions                             integer     170
    sga_max_size                         big integer 648M
    sga_target                           big integer 648M
    shadow_core_dump                     string      partial
    shared_memory_address                integer     0
    shared_pool_reserved_size            big integer 9M
    shared_pool_size                     big integer 0
    shared_server_sessions               integer
    shared_servers                       integer     1
    skip_unusable_indexes                boolean     TRUE
    smtp_out_server                      string      10.1.120.2:25
    sort_area_retained_size              integer     0
    sort_area_size                       integer     65536
    spfile                               string      /data/oracle/app/oracle/produc
                                                     t/11.1.0/db_1/dbs/spfileECPMTS
                                                     B.ora
    sql92_security                       boolean     FALSE
    sql_trace                            boolean     FALSE
    sql_version                          string      NATIVE
    sqltune_category                     string      DEFAULT
    standby_archive_dest                 string      ?/dbs/arch
    standby_file_management              string      MANUAL
    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
    tracefile_identifier                 string
    transactions                         integer     187
    transactions_per_rollback_segment    integer     5
    undo_management                      string      AUTO
    undo_retention                       integer     900
    undo_tablespace                      string      UNDOTBS1
    use_indirect_data_buffers            boolean     FALSE
    user_dump_dest                       string      /data/oracle/app/oracle/diag/r
                                                     dbms/ecpmtsb/ECPMTSB/trace
    utl_file_dir                         string
    workarea_size_policy                 string      AUTO
    xml_db_events                        string      enable
  • 5. Re: Dataguard not applying shipping logs / Sessions Active on Standby
    975078 Newbie
    Currently Being Moderated
    Standby:
    
    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      /opt/app/oracle/admin/ECPMT/ad
                                                     ump
    audit_sys_operations                 boolean     FALSE
    audit_syslog_level                   string
    audit_trail                          string      NONE
    
    background_core_dump                 string      partial
    background_dump_dest                 string      /opt/app/oracle/diag/rdbms/ecp
                                                     mt/ECPMT1/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
    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
    commit_logging                       string
    commit_point_strength                integer     1
    commit_wait                          string
    commit_write                         string
    compatible                           string      11.1.0.0.0
    control_file_record_keep_time        integer     7
    control_files                        string      +DG_01/ecpmt/controlfile/curre
    
                                                     nt.2717.769883873, +FRA_DG_01/
                                                     ecpmt/controlfile/current.4804
                                                     .769883873
    control_management_pack_access       string      DIAGNOSTIC+TUNING
    core_dump_dest                       string      /opt/app/oracle/diag/rdbms/ecp
                                                     mt/ECPMT1/cdump
    cpu_count                            integer     8
    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
    db_block_checking                    string      FALSE
    db_block_checksum                    string      TYPICAL
    db_block_size                        integer     8192
    db_cache_advice                      string      ON
    db_cache_size                        big integer 0
    db_create_file_dest                  string      +DG_01
    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
    db_domain                            string
    db_file_multiblock_read_count        integer     122
    db_file_name_convert                 string      +DG_01/ecpmtsb, +DG_01/ecpmt
    db_files                             integer     200
    db_flashback_retention_target        integer     1440
    db_keep_cache_size                   big integer 0
    db_lost_write_protect                string      NONE
    db_name                              string      ECPMT
    db_recovery_file_dest                string      +FRA_DG_01
    db_recovery_file_dest_size           big integer 20G
    db_recycle_cache_size                big integer 0
    
    db_securefile                        string      PERMITTED
    db_ultra_safe                        string      OFF
    db_unique_name                       string      ECPMT
    db_writer_processes                  integer     1
    dbwr_io_slaves                       integer     0
    ddl_lock_timeout                     integer     0
    dg_broker_config_file1               string      +DG_01/ecpmt/dgbroker/dg_confi
                                                     g_file1.dat
    dg_broker_config_file2               string      +FRA_DG_01/ecpmt/dgbroker/dg_c
                                                     onfig_file2.dat
    dg_broker_start                      boolean     FALSE
    diagnostic_dest                      string      /opt/app/oracle
    disk_asynch_io                       boolean     TRUE
    
    dispatchers                          string      (PROTOCOL=TCP) (SERVICE=ECPMTX
                                                     DB)
    distributed_lock_timeout             integer     60
    dml_locks                            integer     748
    drs_start                            boolean     FALSE
    enable_ddl_logging                   boolean     FALSE
    event                                string
    fal_client                           string      ECPMT
    fal_server                           string      ECPMTSB
    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
    gc_files_to_locks                    string
    gcs_server_processes                 integer     2
    global_context_pool_size             string
    global_names                         boolean     FALSE
    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      ECPMT1
    instance_number                      integer     1
    instance_type                        string      RDBMS
    java_jit_enabled                     boolean     TRUE
    java_max_sessionspace_size           integer     0
    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
    local_listener                       string      LISTENER_ECPMT1
    lock_name_space                      string
    lock_sga                             boolean     FALSE
    log_archive_config                   string      DG_CONFIG=(ecpmt,ecpmtsb)
    log_archive_dest                     string
    log_archive_dest_1                   string      LOCATION=USE_DB_RECOVERY_FILE_
                                                     DEST VALID_FOR=(ALL_LOGFILES,A
                                                     LL_ROLES) DB_UNIQUE_NAME=ECPMT
    log_archive_dest_10                  string
    log_archive_dest_2                   string      SERVICE=ecpmtsb LGWR ASYNC VAL
                                                     ID_FOR=(ONLINE_LOGFILES,PRIMAR
                                                     Y_ROLE) DB_UNIQUE_NAME=ecpmtsb
    
    log_archive_dest_3                   string      LOCATION=+FRA_DG_01/ecpmt/stan
                                                     dbylog  VALID_FOR=(STANDBY_LOG
                                                     FILES,STANDBY_ROLE) DB_UNIQUE_
                                                     NAME=ECPMT
    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_2             string      ENABLE
    
    log_archive_dest_state_3             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
    log_archive_format                   string      %t_%s_%r.dbf
    log_archive_local_first              boolean     TRUE
    log_archive_max_processes            integer     30
    log_archive_min_succeed_dest         integer     1
    log_archive_start                    boolean     FALSE
    
    log_archive_trace                    integer     0
    log_buffer                           integer     7744512
    log_checkpoint_interval              integer     0
    log_checkpoint_timeout               integer     1800
    log_checkpoints_to_alert             boolean     FALSE
    log_file_name_convert                string      +FRA_DG_01/ecpmtsb, +FRA_DG_01
                                                     /ecpmt, +DG_01/ecpmtsb, +DG_01
                                                     /ecpmt
    max_commit_propagation_delay         integer     0
    max_dispatchers                      integer
    max_dump_file_size                   string      unlimited
    max_enabled_roles                    integer     150
    max_shared_servers                   integer
    
    memory_max_target                    big integer 0
    memory_target                        big integer 0
    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
    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
    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.1.0.7
    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
    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_execution_message_size      integer     2152
    parallel_instance_group              string
    parallel_io_cap_enabled              boolean     FALSE
    parallel_max_servers                 integer     135
    parallel_min_percent                 integer     0
    parallel_min_servers                 integer     0
    parallel_server                      boolean     TRUE
    parallel_server_instances            integer     2
    parallel_threads_per_cpu             integer     2
    pga_aggregate_target                 big integer 164M
    plscope_settings                     string      IDENTIFIERS:NONE
    plsql_ccflags                        string
    plsql_code_type                      string      INTERPRETED
    
    plsql_debug                          boolean     FALSE
    plsql_native_library_dir             string
    plsql_native_library_subdir_count    integer     0
    plsql_optimize_level                 integer     2
    plsql_v2_compatibility               boolean     FALSE
    plsql_warnings                       string      DISABLE:ALL
    pre_page_sga                         boolean     FALSE
    processes                            integer     150
    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_ECPMT
    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     8
    resource_manager_plan                string
    result_cache_max_result              integer     5
    result_cache_max_size                big integer 2560K
    
    result_cache_mode                    string      MANUAL
    result_cache_remote_expiration       integer     0
    resumable_timeout                    integer     0
    rollback_segments                    string
    sec_case_sensitive_logon             boolean     FALSE
    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      ECPMT
    session_cached_cursors               integer     50
    session_max_open_files               integer     10
    
    sessions                             integer     170
    sga_max_size                         big integer 496M
    sga_target                           big integer 496M
    shadow_core_dump                     string      partial
    shared_memory_address                integer     0
    shared_pool_reserved_size            big integer 15099494
    shared_pool_size                     big integer 0
    shared_server_sessions               integer
    shared_servers                       integer     1
    skip_unusable_indexes                boolean     TRUE
    smtp_out_server                      string      10.1.120.2:25
    sort_area_retained_size              integer     0
    sort_area_size                       integer     65536
    
    spfile                               string      +DG_01/ecpmt/spfileecpmt.ora
    sql92_security                       boolean     FALSE
    sql_trace                            boolean     FALSE
    sql_version                          string      NATIVE
    sqltune_category                     string      DEFAULT
    standby_archive_dest                 string      +FRA_DG_01/ECPMT/STANDBYLOG
    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
    tracefile_identifier                 string
    transactions                         integer     187
    transactions_per_rollback_segment    integer     5
    undo_management                      string      AUTO
    undo_retention                       integer     900
    undo_tablespace                      string      UNDOTBS1
    use_indirect_data_buffers            boolean     FALSE
    user_dump_dest                       string      /opt/app/oracle/diag/rdbms/ecp
                                                     mt/ECPMT1/trace
    utl_file_dir                         string
    workarea_size_policy                 string      AUTO
    
    xml_db_events                        string      enable
  • 6. Re: Dataguard not applying shipping logs / Sessions Active on Standby
    mseberg Guru
    Currently Being Moderated
    Hello again;

    Checking the one we care about - not complete

    Noticed log_archive_dest_state_2 as shown :
    compatible                           string      11.1.0.0.0
    db_name                              string      ECPMT
    db_unique_name                       string      ECPMTSB
    log_archive_dest_state_1             string      enable
    log_archive_dest_state_2             string      DEFER
    log_archive_dest_state_3             string      ENABLE
    Will check more and post here as edit

    Best Regards

    mseberg
  • 7. Re: Dataguard not applying shipping logs / Sessions Active on Standby
    975078 Newbie
    Currently Being Moderated
    Hey! That was it! I knew it was something stupid and simple :) Thanks again Mseberg!
  • 8. Re: Dataguard not applying shipping logs / Sessions Active on Standby
    mseberg Guru
    Currently Being Moderated
    I'm glad you have a sense of humor about it.

    A few years back I had boss who always told me when I was struck on a problem :

    "Well its probably something stupid!"

    Which always made me bust out laughing and made the problem easier to solve.

    Best Regards

    mseberg
  • 9. Re: Dataguard not applying shipping logs / Sessions Active on Standby
    975078 Newbie
    Currently Being Moderated
    You have to have a sense of humour being a DBA :) Thanks btw for being so incredibly helpful, you've really helped me out a lot.

Legend

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