9 Replies Latest reply: Dec 4, 2012 4:10 PM by 975078 RSS

    Dataguard not applying shipping logs / Sessions Active on Standby

    975078
      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
          Hello;

          Is there an error in either alert log?

          Best Regards

          mseberg
          • 2. Re: Dataguard not applying shipping logs / Sessions Active on Standby
            975078
            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
              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
                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
                  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
                    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
                      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
                        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
                          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.