This discussion is archived
1 2 3 Previous Next 44 Replies Latest reply: Sep 22, 2012 8:55 PM by 918424 Go to original post RSS
  • 30. Re: Archive Logs NOT APPLIED but transferred
    918424 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    From standby please post:

    select database_role,controlfile_type from v$database;
  • 34. Re: Archive Logs NOT APPLIED but transferred
    CKPT Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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
    316993 Pro
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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
    316993 Pro
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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
    Acooper Explorer
    Currently Being Moderated
    "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
    316993 Pro
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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

Legend

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