Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2011
    Posts
    14

    Unanswered: Archiving not working on standby system

    We have HADR configured and on primary Archiving is working properly below is config,

    Catalog cache size (4KB) (CATALOGCACHE_SZ) = 2560
    Log buffer size (4KB) (LOGBUFSZ) = 1024
    Log file size (4KB) (LOGFILSIZ) = 16380
    Number of primary log files (LOGPRIMARY) = 20
    Number of secondary log files (LOGSECOND) = 40
    Changed path to log files (NEWLOGPATH) =
    Overflow log path (OVERFLOWLOGPATH) =
    Mirror log path (MIRRORLOGPATH) =
    First active log file = S0073594.LOG
    Block log on disk full (BLK_LOG_DSK_FUL) = YES
    Block non logged operations (BLOCKNONLOGGED) = NO
    Percent max primary log space by transaction (MAX_LOG) = 0
    Num. of active log files for 1 active UOW(NUM_LOG_SPAN) = 0
    Log retain for recovery enabled (LOGRETAIN) = OFF
    First log archive method (LOGARCHMETH1) = TSMB2_LOGS
    Options for logarchmeth1 (LOGARCHOPT1) =
    Second log archive method (LOGARCHMETH2) = DISK:/migtemp/log_ship/
    Options for logarchmeth2 (LOGARCHOPT2) =
    Log pages during index build (LOGINDEXBUILD) = ON


    but where as on standby archiving is not workig, my log dir gets full and we have to archive manually,

    Catalog cache size (4KB) (CATALOGCACHE_SZ) = 2560
    Log buffer size (4KB) (LOGBUFSZ) = 1024
    Log file size (4KB) (LOGFILSIZ) = 16380
    Number of primary log files (LOGPRIMARY) = 20
    Number of secondary log files (LOGSECOND) = 40
    Changed path to log files (NEWLOGPATH) =
    Overflow log path (OVERFLOWLOGPATH) =
    Mirror log path (MIRRORLOGPATH) =
    First active log file = S0073597.LOG
    Block log on disk full (BLK_LOG_DSK_FUL) = YES
    Block non logged operations (BLOCKNONLOGGED) = NO
    Percent max primary log space by transaction (MAX_LOG) = 0
    Num. of active log files for 1 active UOW(NUM_LOG_SPAN) = 0
    Log retain for recovery enabled (LOGRETAIN) = OFF
    First log archive method (LOGARCHMETH1) = DISK:/db2/XXX/log_arc/
    Options for logarchmeth1 (LOGARCHOPT1) =
    Second log archive method (LOGARCHMETH2) = OFF
    Options for logarchmeth2 (LOGARCHOPT2) =
    Log pages during index build (LOGINDEXBUILD) = ON

    urgent help much appreciated

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1

  3. #3
    Join Date
    Nov 2011
    Location
    Shen Zhen,China
    Posts
    37
    good points

    The standby database will not delete a log file from its local logpath until it has been notified by the primary database that the primary database has archived it. This behavior provides added protection against the loss of log files. If the primary database fails and its log disk becomes corrupted before a particular log file is archived on the primary database, the standby database will not delete that log file from its own disk because it has not received notification that the primary database successfully archived the log file. If the standby database then takes over as the new primary database, it will archive that log file before recycling it. If both the logarchmeth1 and logarchmeth2 configuration parameters are in use, the standby database will not recycle a log file until the primary database has archived it using both methods.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •