1 2 3 Previous Next 44 Replies Latest reply: Sep 22, 2012 10:55 PM by 918424 Go to original post RSS
      • 30. Re: Archive Logs NOT APPLIED but transferred
        918424
        Mseberg: See below the location of standby password file:

        /home/oracle/oracle/product/10.2.0/db_1/dbs/orapwnewstand

        The password file permission is Oracle user: read & write and Oracle Group: read only. Same permission is there for primary password file also.

        Last 100 lines of Primary alert log:

        ARCt: Archival started
        LGWR: STARTING ARCH PROCESSES COMPLETE
        ARCt started with pid=45, OS id=18736
        LNS1 started with pid=46, OS id=18738
        Fri Aug 31 03:34:02 2012
        Thread 1 advanced to log sequence 166
        Fri Aug 31 03:34:02 2012
        ARCo: Becoming the 'no FAL' ARCH
        ARCo: Becoming the 'no SRL' ARCH
        Fri Aug 31 03:34:02 2012
        ARCq: Becoming the heartbeat ARCH
        Fri Aug 31 03:34:02 2012
        Thread 1 opened at log sequence 166
        Current log# 3 seq# 166 mem# 0: /home/oracle/oracle/product/10.2.0/db_1/oradata/newprim/redo03.log
        Successful open of redo thread 1
        Fri Aug 31 03:34:02 2012
        MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
        Successfully onlined Undo Tablespace 1.
        Fri Aug 31 03:34:02 2012
        SMON: enabling cache recovery
        SMON: enabling tx recovery
        Fri Aug 31 03:34:02 2012
        Database Characterset is WE8ISO8859P1
        Fri Aug 31 03:34:02 2012
        ******************************************************************
        LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2
        ******************************************************************
        Fri Aug 31 03:34:03 2012
        Error 1034 received logging on to the standby
        Fri Aug 31 03:34:03 2012
        Errors in file /home/oracle/oracle/product/10.2.0/db_1/admin/newprim/bdump/newprim_arc1_18677.trc:
        ORA-01034: ORACLE not available
        Fri Aug 31 03:34:03 2012
        Error 1034 received logging on to the standby
        Fri Aug 31 03:34:03 2012
        Errors in file /home/oracle/oracle/product/10.2.0/db_1/admin/newprim/bdump/newprim_lns1_18738.trc:
        ORA-01034: ORACLE not available
        LGWR: Error 1034 creating archivelog file 'newstand'
        LNS: Failed to archive log 3 thread 1 sequence 166 (1034)
        Fri Aug 31 03:34:03 2012
        replication_dependency_tracking turned off (no async multimaster replication found)
        Fri Aug 31 03:34:03 2012
        FAL[server, ARC1]: Error 1034 creating remote archivelog file 'newstand'
        FAL[server, ARC1]: FAL archive failed, see trace file.
        Fri Aug 31 03:34:03 2012
        Errors in file /home/oracle/oracle/product/10.2.0/db_1/admin/newprim/bdump/newprim_arc1_18677.trc:
        ORA-16055: FAL request rejected
        ARCH: FAL archive failed. Archiver continuing
        Fri Aug 31 03:34:03 2012
        ORACLE Instance newprim - Archival Error. Archiver continuing.
        Fri Aug 31 03:34:03 2012
        Starting background process QMNC
        QMNC started with pid=47, OS id=18758
        Fri Aug 31 03:34:03 2012
        db_recovery_file_dest_size of 2048 MB is 9.77% used. This is a
        user-specified limit on the amount of space that will be used by this
        database for recovery-related files, and does not reflect the amount of
        space available in the underlying filesystem or ASM diskgroup.
        Fri Aug 31 03:34:03 2012
        Errors in file /home/oracle/oracle/product/10.2.0/db_1/admin/newprim/udump/newprim_ora_18673.trc:
        ORA-00604: error occurred at recursive SQL level 1
        ORA-12663: Services required by client not available on the server
        ORA-36961: Oracle OLAP is not available.
        ORA-06512: at "SYS.OLAPIHISTORYRETENTION", line 1
        ORA-06512: at line 15
        Fri Aug 31 03:34:04 2012
        Completed: ALTER DATABASE OPEN
        Fri Aug 31 03:35:01 2012
        FAL[server]: Fail to queue the whole FAL gap
        GAP - thread 1 sequence 1-33
        DBID 1090398314 branch 792689455
        Fri Aug 31 03:35:13 2012
        Thread 1 advanced to log sequence 167
        Current log# 1 seq# 167 mem# 0: /home/oracle/oracle/product/10.2.0/db_1/oradata/newprim/redo01.log
        Thread 1 advanced to log sequence 168
        Current log# 2 seq# 168 mem# 0: /home/oracle/oracle/product/10.2.0/db_1/oradata/newprim/redo02.log
        Thread 1 cannot allocate new log, sequence 169
        Checkpoint not complete
        Current log# 2 seq# 168 mem# 0: /home/oracle/oracle/product/10.2.0/db_1/oradata/newprim/redo02.log
        Thread 1 advanced to log sequence 169
        Current log# 3 seq# 169 mem# 0: /home/oracle/oracle/product/10.2.0/db_1/oradata/newprim/redo03.log
        Thread 1 advanced to log sequence 170
        Current log# 1 seq# 170 mem# 0: /home/oracle/oracle/product/10.2.0/db_1/oradata/newprim/redo01.log
        Fri Aug 31 03:35:24 2012
        Thread 1 advanced to log sequence 171
        Current log# 2 seq# 171 mem# 0: /home/oracle/oracle/product/10.2.0/db_1/oradata/newprim/redo02.log
        Thread 1 advanced to log sequence 172
        Current log# 3 seq# 172 mem# 0: /home/oracle/oracle/product/10.2.0/db_1/oradata/newprim/redo03.log
        Thread 1 advanced to log sequence 173
        Current log# 1 seq# 173 mem# 0: /home/oracle/oracle/product/10.2.0/db_1/oradata/newprim/redo01.log
        Thread 1 advanced to log sequence 174
        Current log# 2 seq# 174 mem# 0: /home/oracle/oracle/product/10.2.0/db_1/oradata/newprim/redo02.log
        Fri Aug 31 03:37:02 2012
        Thread 1 advanced to log sequence 175
        Current log# 3 seq# 175 mem# 0: /home/oracle/oracle/product/10.2.0/db_1/oradata/newprim/redo03.log
        Thread 1 advanced to log sequence 176
        Current log# 1 seq# 176 mem# 0: /home/oracle/oracle/product/10.2.0/db_1/oradata/newprim/redo01.log
        Thread 1 advanced to log sequence 177
        Current log# 2 seq# 177 mem# 0: /home/oracle/oracle/product/10.2.0/db_1/oradata/newprim/redo02.log
        Thread 1 advanced to log sequence 178
        Current log# 3 seq# 178 mem# 0: /home/oracle/oracle/product/10.2.0/db_1/oradata/newprim/redo03.log
        Thread 1 advanced to log sequence 179
        Current log# 1 seq# 179 mem# 0: /home/oracle/oracle/product/10.2.0/db_1/oradata/newprim/redo01.log
        Thread 1 advanced to log sequence 180
        Current log# 2 seq# 180 mem# 0: /home/oracle/oracle/product/10.2.0/db_1/oradata/newprim/redo02.log
        Thread 1 advanced to log sequence 181
        Current log# 3 seq# 181 mem# 0: /home/oracle/oracle/product/10.2.0/db_1/oradata/newprim/redo03.log
        Fri Aug 31 03:37:14 2012
        Thread 1 advanced to log sequence 182
        Current log# 1 seq# 182 mem# 0: /home/oracle/oracle/product/10.2.0/db_1/oradata/newprim/redo01.log
        Thread 1 advanced to log sequence 183
        Current log# 2 seq# 183 mem# 0: /home/oracle/oracle/product/10.2.0/db_1/oradata/newprim/redo02.log
        Thread 1 advanced to log sequence 184
        Current log# 3 seq# 184 mem# 0: /home/oracle/oracle/product/10.2.0/db_1/oradata/newprim/redo03.log
        Thread 1 cannot allocate new log, sequence 185
        Checkpoint not complete
        Current log# 3 seq# 184 mem# 0: /home/oracle/oracle/product/10.2.0/db_1/oradata/newprim/redo03.log
        Thread 1 advanced to log sequence 185
        Current log# 1 seq# 185 mem# 0: /home/oracle/oracle/product/10.2.0/db_1/oradata/newprim/redo01.log
        Thread 1 advanced to log sequence 186
        Current log# 2 seq# 186 mem# 0: /home/oracle/oracle/product/10.2.0/db_1/oradata/newprim/redo02.log
        Fri Aug 31 03:37:56 2012
        Thread 1 advanced to log sequence 187
        Current log# 3 seq# 187 mem# 0: /home/oracle/oracle/product/10.2.0/db_1/oradata/newprim/redo03.log
        Thread 1 advanced to log sequence 188
        Current log# 1 seq# 188 mem# 0: /home/oracle/oracle/product/10.2.0/db_1/oradata/newprim/redo01.log
        Thread 1 advanced to log sequence 189
        Current log# 2 seq# 189 mem# 0: /home/oracle/oracle/product/10.2.0/db_1/oradata/newprim/redo02.log
        Fri Aug 31 03:39:12 2012
        Thread 1 advanced to log sequence 190
        Current log# 3 seq# 190 mem# 0: /home/oracle/oracle/product/10.2.0/db_1/oradata/newprim/redo03.log
        Fri Aug 31 03:39:13 2012
        ARCq: Standby redo logfile selected for thread 1 sequence 189 for destination LOG_ARCHIVE_DEST_2
        LNS1 started with pid=49, OS id=19445
        Fri Aug 31 03:39:17 2012
        Thread 1 advanced to log sequence 191
        Current log# 1 seq# 191 mem# 0: /home/oracle/oracle/product/10.2.0/db_1/oradata/newprim/redo01.log
        Fri Aug 31 03:39:18 2012
        ARCs: Standby redo logfile selected for thread 1 sequence 190 for destination LOG_ARCHIVE_DEST_2
        Fri Aug 31 03:39:18 2012
        LNS: Standby redo logfile selected for thread 1 sequence 191 for destination LOG_ARCHIVE_DEST_2
        Fri Aug 31 03:39:21 2012
        Thread 1 advanced to log sequence 192
        Current log# 2 seq# 192 mem# 0: /home/oracle/oracle/product/10.2.0/db_1/oradata/newprim/redo02.log
        Fri Aug 31 03:39:22 2012
        LNS: Standby redo logfile selected for thread 1 sequence 192 for destination LOG_ARCHIVE_DEST_2
        Fri Aug 31 03:39:24 2012
        Thread 1 advanced to log sequence 193
        Current log# 3 seq# 193 mem# 0: /home/oracle/oracle/product/10.2.0/db_1/oradata/newprim/redo03.log
        Fri Aug 31 03:39:25 2012
        LNS: Standby redo logfile selected for thread 1 sequence 193 for destination LOG_ARCHIVE_DEST_2
        Fri Aug 31 03:39:56 2012
        Thread 1 advanced to log sequence 194
        Current log# 1 seq# 194 mem# 0: /home/oracle/oracle/product/10.2.0/db_1/oradata/newprim/redo01.log
        Fri Aug 31 03:39:57 2012
        LNS: Standby redo logfile selected for thread 1 sequence 194 for destination LOG_ARCHIVE_DEST_2


        Last 100 Lines of Standby alert log:

        LD_LIBRARY_PATH is not set!
        The default library directories are /lib and /usr/lib
        Unable to find dynamic library libocrb10.so in search paths
        Unable to find dynamic library libocrutl10.so in search paths
        Unable to find dynamic library libocrutl10.so in search paths
        LICENSE_MAX_SESSION = 0
        LICENSE_SESSIONS_WARNING = 0
        Picked latch-free SCN scheme 2
        Autotune of undo retention is turned on.
        IMODE=BR
        ILAT =18
        LICENSE_MAX_USERS = 0
        SYS auditing is disabled
        ksdpec: called for event 13740 prior to event group initialization
        Starting up ORACLE RDBMS Version: 10.2.0.1.0.
        System parameters with non-default values:
        processes = 150
        __shared_pool_size = 83886080
        __large_pool_size = 4194304
        __java_pool_size = 4194304
        __streams_pool_size = 0
        sga_target = 289406976
        control_files = /home/oracle/oracle/product/10.2.0/db_1/oradata/newstand/standby01.ctl, /home/oracle/oracle/product/10.2.0/db_1/oradata/newstand/standby02.ctl, /home/oracle/oracle/product/10.2.0/db_1/oradata/newstand/standby03.ctl
        db_file_name_convert = /home/oracle/oracle/product/10.2.0/db_1/oradata/newprim, /home/oracle/oracle/product/10.2.0/db_1/oradata/newstand
        log_file_name_convert = /home/oracle/oracle/product/10.2.0/db_1/oradata/newprim, /home/oracle/oracle/product/10.2.0/db_1/oradata/newstand, /home/oracle/oracle/product/10.2.0/db_1/flash_recovery_area/NEWPRIM/onlinelog, /home/oracle/oracle/product/10.2.0/db_1/flash_recovery_area/NEWSTAND/onlinelog
        db_block_size = 8192
        __db_cache_size = 192937984
        compatible = 10.2.0.1.0
        log_archive_config = DG_CONFIG=(newprim,newstand)
        log_archive_dest_1 = LOCATION=/home/oracle/oracle/product/10.2.0/db_1/oradata/newstand/arch/
        VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
        DB_UNIQUE_NAME=newstand
        log_archive_dest_2 = SERVICE=newprim LGWR ASYNC
        VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
        DB_UNIQUE_NAME=newprim
        log_archive_dest_state_1 = ENABLE
        log_archive_dest_state_2 = defer
        log_archive_format = log%t_%s_%r.arc
        fal_client = .
        fal_server = newprim
        db_file_multiblock_read_count= 16
        db_recovery_file_dest = /home/oracle/oracle/product/10.2.0/db_1/flash_recovery_area
        db_recovery_file_dest_size= 2147483648
        standby_file_management = AUTO
        undo_management = AUTO
        undo_tablespace = UNDOTBS1
        remote_login_passwordfile= EXCLUSIVE
        dispatchers = (PROTOCOL=TCP) (SERVICE=newstandXDB)
        job_queue_processes = 10
        background_dump_dest = /home/oracle/oracle/product/10.2.0/db_1/admin/newstand/bdump
        user_dump_dest = /home/oracle/oracle/product/10.2.0/db_1/admin/newstand/udump
        core_dump_dest = /home/oracle/oracle/product/10.2.0/db_1/admin/newstand/cdump
        audit_file_dest = /home/oracle/oracle/product/10.2.0/db_1/admin/newstand/adump
        db_name = newprim
        db_unique_name = newstand
        open_cursors = 300
        pga_aggregate_target = 95420416
        PMON started with pid=2, OS id=18766
        PSP0 started with pid=3, OS id=18768
        MMAN started with pid=4, OS id=18770
        DBW0 started with pid=5, OS id=18772
        LGWR started with pid=6, OS id=18774
        CKPT started with pid=7, OS id=18776
        SMON started with pid=8, OS id=18778
        RECO started with pid=9, OS id=18780
        CJQ0 started with pid=10, OS id=18782
        MMON started with pid=11, OS id=18784
        MMNL started with pid=12, OS id=18786
        Fri Aug 31 03:34:05 2012
        starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
        starting up 1 shared server(s) ...
        Fri Aug 31 03:34:05 2012
        ALTER DATABASE MOUNT
        Fri Aug 31 03:34:09 2012
        Setting recovery target incarnation to 2
        ARCH: STARTING ARCH PROCESSES
        ARC0 started with pid=16, OS id=18801
        Fri Aug 31 03:34:09 2012
        ARC0: Archival started
        ARC1: Archival started
        ARCH: STARTING ARCH PROCESSES COMPLETE
        Fri Aug 31 03:34:09 2012
        ARC0: Becoming the 'no FAL' ARCH
        ARC0: Becoming the 'no SRL' ARCH
        ARC0: Thread not mounted
        ARC1 started with pid=17, OS id=18803
        ARC1: Becoming the heartbeat ARCH
        ARC1: Thread not mounted
        Fri Aug 31 03:34:09 2012
        Successful mount of redo thread 1, with mount id 1090465773
        Fri Aug 31 03:34:09 2012
        Physical Standby Database mounted.
        Completed: ALTER DATABASE MOUNT
        Fri Aug 31 03:34:56 2012
        alter database recover managed standby database using current logfile disconnect
        Fri Aug 31 03:34:56 2012
        Attempt to start background Managed Standby Recovery process (newstand)
        MRP0 started with pid=18, OS id=18908
        Fri Aug 31 03:34:56 2012
        MRP0: Background Managed Standby Recovery process started (newstand)
        Managed Standby Recovery starting Real Time Apply
        Media Recovery Waiting for thread 1 sequence 1
        Fetching gap sequence in thread 1, gap sequence 1-33
        Fri Aug 31 03:35:02 2012
        Completed: alter database recover managed standby database using current logfile disconnect
        Fri Aug 31 03:35:31 2012
        FAL[client]: Failed to request gap sequence
        GAP - thread 1 sequence 1-33
        DBID 1090398314 branch 792689455
        FAL[client]: All defined FAL servers have been attempted.
        -------------------------------------------------------------
        Check that the CONTROL_FILE_RECORD_KEEP_TIME initialization
        parameter is defined to a value that is sufficiently large
        enough to maintain adequate log switch information to resolve
        archivelog gaps.
        -------------------------------------------------------------
        Fri Aug 31 03:39:13 2012
        Using STANDBY_ARCHIVE_DEST parameter default value as /home/oracle/oracle/product/10.2.0/db_1/oradata/newstand/arch/
        Redo Shipping Client Connected as PUBLIC
        -- Connected User is Valid
        RFS[1]: Assigned to RFS process 19427
        RFS[1]: Identified database type as 'physical standby'
        Fri Aug 31 03:39:13 2012
        RFS LogMiner: Client disabled from further notification
        RFS[1]: Successfully opened standby log 4: '/home/oracle/oracle/product/10.2.0/db_1/flash_recovery_area/NEWSTAND/onlinelog/o1_mf_4_83yh15yy_.log'
        Fri Aug 31 03:39:18 2012
        Redo Shipping Client Connected as PUBLIC
        -- Connected User is Valid
        RFS[2]: Assigned to RFS process 19453
        RFS[2]: Identified database type as 'physical standby'
        RFS[2]: Successfully opened standby log 4: '/home/oracle/oracle/product/10.2.0/db_1/flash_recovery_area/NEWSTAND/onlinelog/o1_mf_4_83yh15yy_.log'
        Fri Aug 31 03:39:18 2012
        Redo Shipping Client Connected as PUBLIC
        -- Connected User is Valid
        RFS[3]: Assigned to RFS process 19455
        RFS[3]: Identified database type as 'physical standby'
        Primary database is in MAXIMUM PERFORMANCE mode
        Primary database is in MAXIMUM PERFORMANCE mode
        RFS[3]: Successfully opened standby log 4: '/home/oracle/oracle/product/10.2.0/db_1/flash_recovery_area/NEWSTAND/onlinelog/o1_mf_4_83yh15yy_.log'
        Primary database is in MAXIMUM PERFORMANCE mode
        RFS[3]: Successfully opened standby log 5: '/home/oracle/oracle/product/10.2.0/db_1/flash_recovery_area/NEWSTAND/onlinelog/o1_mf_5_83yh2052_.log'
        Primary database is in MAXIMUM PERFORMANCE mode
        RFS[3]: Successfully opened standby log 4: '/home/oracle/oracle/product/10.2.0/db_1/flash_recovery_area/NEWSTAND/onlinelog/o1_mf_4_83yh15yy_.log'
        Fri Aug 31 03:39:57 2012
        Primary database is in MAXIMUM PERFORMANCE mode
        RFS[3]: Successfully opened standby log 4: '/home/oracle/oracle/product/10.2.0/db_1/flash_recovery_area/NEWSTAND/onlinelog/o1_mf_4_83yh15yy_.log'
        Fri Aug 31 03:49:08 2012
        db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a
        user-specified limit on the amount of space that will be used by this
        database for recovery-related files, and does not reflect the amount of
        space available in the underlying filesystem or ASM diskgroup.

        Thanks.
        • 31. Re: Archive Logs NOT APPLIED but transferred
          918424
          CKPT: I have done all the things said by you. I have created a new standby control file and bounced the standby freshly, but failed.

          I have set local_listener parameters in both sites, but no use.

          I have set the standby_archive_dest parameter in the standby site, to point the archive log location of the primary database, but still failed to apply although all the logs are received in the standby end.

          I am not certain what is the cause of this!

          Thanks.
          • 32. Re: Archive Logs NOT APPLIED but transferred
            mseberg
            Can post the following

            lsnrctl status ( from primary and standby )

            listerer.ora ( from primary and standby )

            tnsname.ora ( from primary and standby )

            If the archive is on the standby what ( message ) happens if you manually register?
            ALTER DATABASE REGISTER LOGFILE '/home/oracle/oracle/product/10.2.0/db_1/flash_recovery_area/NEWSTAND/onlinelog/o1_mf_4_83yh15yy_.log';
            Best Regards

            mseberg
            • 33. Re: Archive Logs NOT APPLIED but transferred
              Shivananda Rao
              From standby please post:

              select database_role,controlfile_type from v$database;
              • 34. Re: Archive Logs NOT APPLIED but transferred
                CKPT
                Do as suggested by Mseberg and also you mentioned
                I have set the standby_archive_dest parameter in the standby site, to point the archive log location of the primary database, but still failed to apply although all the logs are received in the standby end.
                This archive log location should point to the standby database archive destination. It should not point any remote destination. So set this parameter in standby database as same location as archive log location(log_archive_dest_1)

                Also check these bugs

                *Bug 4538727 - Applied column is not updated in V$ARCHIVED_LOG [ID 4538727.8]*
                *V$Archived_log "Applied" column not updated For Downstream Capture [ID 602960.1]*
                *V$Archived_log "Applied" column not updated For Downstream Capture [ID 602960.1]*

                Edited by: CKPT on Sep 21, 2012 8:21 PM
                • 35. Re: Archive Logs NOT APPLIED but transferred
                  918424
                  Shiva:
                  From Standby,

                  SQL> select database_role,controlfile_type from v$database;

                  DATABASE_ROLE CONTROL
                  ---------------- -------
                  PHYSICAL STANDBY STANDBY

                  SQL>

                  Mseberg:

                  For your information, I have only one listener.ora and tnsnames.ora because it is the same home where both databases reside.

                  On Primary: Listener Status below:

                  [oracle@localhost bin]$ ./lsnrctl status listener

                  LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 31-AUG-2012 05:19:13

                  Copyright (c) 1991, 2005, Oracle. All rights reserved.

                  Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))
                  STATUS of the LISTENER
                  ------------------------
                  Alias listener
                  Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
                  Start Date 30-AUG-2012 17:19:14
                  Uptime 0 days 11 hr. 59 min. 58 sec
                  Trace Level off
                  Security ON: Local OS Authentication
                  SNMP OFF
                  Listener Parameter File /home/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora
                  Listener Log File /home/oracle/oracle/product/10.2.0/db_1/network/log/listener.log
                  Listening Endpoints Summary...
                  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
                  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
                  Services Summary...
                  Service "newprim" has 2 instance(s).
                  Instance "newprim", status UNKNOWN, has 1 handler(s) for this service...
                  Instance "newprim", status READY, has 1 handler(s) for this service...
                  Service "newprimXDB" has 1 instance(s).
                  Instance "newprim", status READY, has 1 handler(s) for this service...
                  Service "newprim_XPT" has 1 instance(s).
                  Instance "newprim", status READY, has 1 handler(s) for this service...
                  The command completed successfully
                  [oracle@localhost bin]$

                  On Standby, Listener Status:

                  [oracle@localhost bin]$ ./lsnrctl status listener1

                  LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 31-AUG-2012 05:21:45

                  Copyright (c) 1991, 2005, Oracle. All rights reserved.

                  Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1522)))
                  STATUS of the LISTENER
                  ------------------------
                  Alias listener1
                  Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
                  Start Date 30-AUG-2012 18:29:27
                  Uptime 0 days 10 hr. 52 min. 18 sec
                  Trace Level off
                  Security ON: Local OS Authentication
                  SNMP OFF
                  Listener Parameter File /home/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora
                  Listener Log File /home/oracle/oracle/product/10.2.0/db_1/network/log/listener1.log
                  Listening Endpoints Summary...
                  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1522)))
                  Services Summary...
                  Service "newstand" has 2 instance(s).
                  Instance "newstand", status UNKNOWN, has 1 handler(s) for this service...
                  Instance "newstand", status READY, has 1 handler(s) for this service...
                  Service "newstand_XPT" has 1 instance(s).
                  Instance "newstand", status READY, has 1 handler(s) for this service...
                  The command completed successfully
                  [oracle@localhost bin]$

                  Primary: Listener.ora and Tnsnames.ora below:

                  SID_LIST_LISTENER =
                  (SID_LIST =
                  (SID_DESC =
                  (SID_NAME = PLSExtProc)
                  (ORACLE_HOME = /home/oracle/oracle/product/10.2.0/db_1)
                  (PROGRAM = extproc)
                  )
                  (SID_DESC =
                  (GLOBAL_DBNAME = newprim)
                  (ORACLE_HOME = /home/oracle/oracle/product/10.2.0/db_1)
                  (SID_NAME = newprim)
                  )
                  )
                  LISTENER =
                  (DESCRIPTION_LIST =
                  (DESCRIPTION =
                  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
                  )
                  (DESCRIPTION =
                  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
                  )
                  )

                  Tnsnames:

                  NEWPRIM =
                  (DESCRIPTION =
                  (ADDRESS_LIST =
                  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
                  )
                  (CONNECT_DATA =
                  (SERVICE_NAME = newprim)
                  )
                  )

                  Standby:Listener & Tnsnames.ora

                  SID_LIST_LISTENER1 =
                  (SID_LIST =
                  (SID_DESC =
                  (GLOBAL_DBNAME = newstand)
                  (ORACLE_HOME = /home/oracle/oracle/product/10.2.0/db_1)
                  (SID_NAME = newstand)
                  )
                  )
                  LISTENER1 =
                  (DESCRIPTION =
                  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1522))
                  )

                  Tnsnames.ora

                  NEWSTAND =
                  (DESCRIPTION =
                  (ADDRESS_LIST =
                  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1522))
                  )
                  (CONNECT_DATA =
                  (SERVICE_NAME = newstand)
                  )
                  )

                  ---------------------------------------------------

                  SQL> alter database recover managed standby database cancel;

                  Database altered.

                  SQL> alter database register logfile '/home/oracle/oracle/product/10.2.0/db_1/oradata/newstand/arch/log1_34_792689455.arc';

                  Database altered.

                  SQL> alter database recover managed standby database using current logfile disconnect;

                  Database altered.

                  SQL> select sequence#,applied from v$archived_log;

                  SEQUENCE# APP
                  ---------- ---
                  227 NO
                  228 NO
                  229 NO
                  230 NO
                  231 NO
                  232 NO
                  233 NO
                  234 NO
                  235 NO
                  246 NO
                  247 NO

                  SEQUENCE# APP
                  ---------- ---
                  248 NO
                  249 NO
                  250 NO
                  251 NO
                  252 NO
                  34 NO

                  17 rows selected.

                  SQL>

                  See the sequence# 34 which is what registered manually currently, which is not applied to the standby site!!!

                  Thanks.
                  • 36. Re: Archive Logs NOT APPLIED but transferred
                    918424
                    CKPT: Now I corrected the location for the parameter standby_archive_dest in the standby to the log_archive_dest_1 location of the standby. But resulted unchanged in the main issue.

                    Thanks.
                    • 37. Re: Archive Logs NOT APPLIED but transferred
                      mseberg
                      Hello;

                      I hope you are not using "localhost.localdomain" You need a real DNS/hostname here.

                      Your tnsnames for primary does not have an entry for your Standby!! This is essential.

                      Your tnsnames for Standby does not have an entry for Primary! This is essential.

                      Is any of this helpful?

                      Best Regards

                      mseberg
                      • 38. Re: Archive Logs NOT APPLIED but transferred
                        orawarebyte
                        Yours standby database will not go for further recovery if there is gap between the log sequence , if you have 10 logs 1,2,3,4,5,6,7,8,9,10 and log sequence 5 missed somehow to move at standby then a hole will create at yours standby database and will not go to apply for further sequence for 6,7,8..10,It does not apply even a single sequence after sequence 5 unless you do not copy sequence 5 to standby register it and put standby in recovery mode.Yours 34 will not apply until and unless you do not put the minimum non-applied log sequence chronologically.

                        Could you please send the result as i have already asked as before.
                        select min(sequence#)
                          from v$archived_log
                        where applied='NO'
                        /
                        select max(sequence#)
                          from v$archived_log
                        where applied='YES'
                        /
                        I am unable to understand that how a configuration issue could lead this problem when yours archived log are being copied to standby database properly.

                        Khurram
                        • 39. Re: Archive Logs NOT APPLIED but transferred
                          918424
                          Mseberg: Sorry for late reply. It was late night yesterday.

                          Well, you say I must have entry for the standby site in primary. Of course Yes. I have it. As I told you already I have both the databases in the same home. So, I am using same tnsnames for both DB's. Obviously, both databases have their own entries there in same file.

                          Moreover, I personally perceive that the connection might not be an issue since I can connect the remote database using the net service name from both ends. To add more, I have my archive logs shipped to the standby using the log_archive_dest_2 parameter in the primary, which uses the standby's net service name.

                          Khurram: It was a good explanation by you indeed. I added the query results below for your reference:

                          SQL> select min(sequence#) from v$archived_log where applied='NO';


                          MIN(SEQUENCE#)
                          --------------
                          34


                          SQL> select max(sequence#) from v$archived_log where applied='YES';

                          MAX(SEQUENCE#)
                          --------------


                          SQL>

                          Thanks,
                          • 40. Re: Archive Logs NOT APPLIED but transferred
                            orawarebyte
                            Your metadata might be misleading i.e V$ARCHIVED_LOG displays archived log information from the control file , i believe yours control file does not have adequate information (you have copied controlfile back and forth many times to fixed out this issue).

                            Now , just take an incremental level backup from the SCN of the following query result at Production.


                            select min(checkpoint_change#)
                            from v$datafile_header;



                            copy that backup piece to standby database and rollforward it with this backup, for a little background about this issue (why i am saying incremental rollforward from Production to standy is ) read this article
                            http://oraware.blogspot.com.au/2009/04/media-recovery-start-point.html
                            HTH

                            Khurram
                            • 41. Re: Archive Logs NOT APPLIED but transferred
                              918424
                              Khurram! I got it working now!

                              You asked me to take incremental backup and roll it forward..However, I took cold backup of datafiles along with redo logs, standby logs, and then created standby control file in the primary site and then shifted them to standby site and started the recovery fresh.

                              Oh God, everything is transferred and applied in standby site!

                              SQL> select sequence#,applied from v$archived_log;

                              SEQUENCE# APP
                              ---------- ---
                              322 YES
                              320 YES
                              321 YES
                              304 YES
                              298 YES
                              306 YES
                              309 YES
                              310 YES
                              311 YES
                              314 YES
                              305 YES

                              SEQUENCE# APP
                              ---------- ---
                              313 YES
                              312 YES
                              301 YES
                              300 YES
                              299 YES
                              307 YES
                              303 YES
                              297 YES
                              317 YES
                              315 YES
                              316 YES

                              SEQUENCE# APP
                              ---------- ---
                              308 YES
                              302 YES
                              319 YES
                              318 YES
                              324 YES
                              323 YES
                              325 YES
                              326 YES

                              30 rows selected.

                              SQL>

                              I appreciate everyone for all your help for troubleshooting this issue.

                              I am grateful to all of you.

                              Thanks a lot.

                              -Vimal.
                              • 42. Re: Archive Logs NOT APPLIED but transferred
                                Seberg
                                "I am grateful to all of you"

                                Then maybe mark a few of these as "Helpful" and close the question.
                                • 43. Re: Archive Logs NOT APPLIED but transferred
                                  orawarebyte
                                  I wanted you to fix out this issue without having cold or hot backup from the scratch , this resolution give you lot of comfort next time if ever it occurs again, anyhow this is not an issue.

                                  Khurram
                                  • 44. Re: Archive Logs NOT APPLIED but transferred
                                    918424
                                    Khurram: You are absolutely right. To be frank, my mind simply escaped from the complexity availing that process. Now I regret for having chosen the method of fresh start rather than troubleshooting the issue.

                                    -Vimal.
                                    1 2 3 Previous Next