Shareplex的一个参数 SP_OCT_SKIP_BAD_BLOCK

公司的产品数据库环境,用shareplex做复制。 最近检查数据时,发现有些数据丢失了。都是在同一个时间段。找到具体丢失的数据和时间点之后,找产品DBA问问情况。(其实我们自己也有定时的检测程序,只是时间段比较宽。)回复说是因为某种原因,shareplex忽略了一小段redo log。现在他们已经把参数 SP_OCT_SKIP_BAD_BLOCK 改回默认值(0)。

看了一下参考文档,居然没有这个参数的说明。到quest的网站上找一下,发现这个:

 

https://support.quest.com/search/SolutionDetail.aspx?id=SOL20598

Solution SOL20598

 

Title

Capture cannot start Warning: A portion of the redo log could not be parsed/Notice: Begin record skip at seqno= offset= rc=

Problem Description

event_log errors:

08/24/08 22:11 Notice: (Read) Queue write recovery started, sqrw_srcseq= msg.mpseq=<xxxxxxx> [sp_ordr(que)/<pid#>]
08/24/08 22:12 Notice: Queue write recovery complete,  <xxxx> duplicate messages skipped , <xxxxxxx> bytes total [sp_ordr(que)/<pid#>]
08/24/08 22:12 Warning: A portion of the redo log could not be parsed [sp_ocap/<pid#>]
08/24/08 22:12 Notice: Begin record skip at seqno=<xxxxxxx> offset=-<xxxxxxx> rc=1<xx> [sp_ocap/<pid#>]

capture log errors:

08-08-24 22:11:59.127653 11462 4 Archive filename=<archive log destination path>/LOGxxxx_x.ARC doesn't exist for file dest_id <x>
08-08-24 22:11:59.127714 11462 4 Archive filename=<archive log destination path>/LOGxxxx_x.ARC doesn't exist and retried with
08-08-24 22:11:59.127714 11462 4 dest_id of 1 thru <x>
08-08-24 22:11:59.127783 11462 4 stat(<archive log destination path>/LOGxxxx_x.ARC, sbuf) failed
08-08-24 22:11:59.133165 11462 4 Try to find file contains string "xxxxx" under <
08-08-24 22:11:59.134353 11462 4 about to stat <archive log destination path>/LOGxxxx_x.ARC
08-08-24 22:11:59.141007 11462 4 Found file with seqno=xxxxx "<archive log destination path>/LOGxxxx_x.ARC"
08-08-24 22:11:59.141135 11462 4 Found archive log with seqno=xxxxx, thread=x   under <archive log destination path>
08-08-24 22:12:21.658840 11462 4 Invalid block number -xxxxxxx requested, should be [x,xxxxxxx]
08-08-24 22:12:21.665297 11462 4 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
08-08-24 22:12:21.665358 11462 4 Log parser error x

Cause


This is generally caused  when capture cannot read the archive log for the following reason:

1.A corrupt redo/archive log file .

2.Unable to  read  the  archive logs .

Resolution


Resolution 1:

If it is determined that the redo/archive log is corrupted then  use the following workaround :

sp_ctrl (<source host>:<port#>)> stop capture
sp_ctrl (<source host>:<port#>)> set param SP_OCT_SKIP_BAD_BLOCK 1
sp_ctrl (<source host>:<port#>)> start capture
 

Resolution 2:

If capture is unable to  read the archive log then please ensure that the archive log is readable. Check that the archive logs  are in archive log destination, uncompressed and readable to the splex user.

Additional Information

These messages in the problem description get repeated in the logs several times, identifying one log file and particular offset.  

Environment

  • Product:

    Shareplex for Oracle~5.0

  • Attachments:

  • Client OS:

    All - N/A

  • Server OS:

    All - N/A

  • Database:

    Oracle

  • Application

    All - N/A

 

 

顺便把现在用的参数记下来,以后好留存。(SharePlex Version = 7.0.2)

 

sp_ctrl (xxxx:11111)> list param all


Activation Database parameters:

Parameter  Name                 Actual Value           Units   Set At        
------------------------------  --------------------  -------  ---------------
SP_ACT_DEBUG                    0x00000000            bitflag  Live          

User Initiated Process parameters:

Parameter  Name                 Actual Value           Units   Set At        
------------------------------  --------------------  -------  ---------------
SP_ANY_DEBUG                    0x00000000            bitflag  Live          

CFG parameters:

Parameter  Name                 Actual Value           Units   Set At        
------------------------------  --------------------  -------  ---------------
SP_CFG_DEBUG                    0x00000000            bitflag  Live          

Command and Control parameters:

Parameter  Name                 Actual Value           Units   Set At        
------------------------------  --------------------  -------  ---------------
SP_CNC_COMM_TIMEOUT             0                     minutes  Live          
SP_CNC_DEBUG                    0x00000000            bitflag  Live          
SP_CNC_LOG                      0                     number   Live          

Control Process parameters:

Parameter  Name                 Actual Value           Units   Set At        
------------------------------  --------------------  -------  ---------------
SP_COP_DEBUG                    0x00000000            bitflag  Live          
SP_COP_EXPORT_LIMIT             0                              Restart Cop   
SP_COP_IDLETIME                 60                    seconds  Live          
SP_COP_SCAN_TIMEOUT             300                   seconds  Live          
SP_COP_SO_RCVBUF                0                     bytes    Restart Cop   
SP_COP_TPORT                    19009                          Restart Cop   
   Default   Value:     2100
SP_COP_UPORT                    19009                          Restart Cop   
   Default   Value:     2100

Compare/Repair parameters:

Parameter  Name                 Actual Value           Units   Set At        
------------------------------  --------------------  -------  ---------------
SP_DEQ_AUTO_REPAIR1             1                     boolean  Live          
SP_DEQ_BATCHSIZE                10000                 rows     Live          
SP_DEQ_CHARACTERSET                                            Live          
SP_DEQ_CLIENT_MEM_TEST          0                     boolean  Live          
SP_DEQ_COMPARE_DEBUG            0x00000000            bitflag  Live          
SP_DEQ_COMPARE_TESTING_FLAG     0                     boolean  Live          
SP_DEQ_CONFIG_LINE_SIZE         2048                  number   Live          
SP_DEQ_DEBUG                    0x00000000            bitflag  Live          
SP_DEQ_IGNORE_ORACLE_ERROR_NUM  0                     number   Live          
SP_DEQ_IP_MAPPING                                              Live          
SP_DEQ_IP_MAPPING_OPTION        1                     number   Live          
SP_DEQ_LOCK_WAIT                300                   seconds  Live          
SP_DEQ_LOG_ROWID                1                     boolean  Live          
SP_DEQ_NCHAR_CHARACTERSET                                      Live          
SP_DEQ_NLS_LANG                                                Live          
SP_DEQ_NLS_LANG_SELECTOR        0                     number   Live          
SP_DEQ_ORACLE_LOGOFF            1                     boolean  Live          
SP_DEQ_PADDER                   0                     number   Live          
SP_DEQ_PART_TABLE_UPDATE        0                     number   Live          
SP_DEQ_READ_BUFFER_SIZE         1                     mbytes   Live          
SP_DEQ_RESULTS_RETENTION        90                    days     Live          
SP_DEQ_REUSE_CONFIG             1                     boolean  Live          
SP_DEQ_ROW_LOCK_THRESHOLD       1000                  number   Live          
SP_DEQ_SERVER_MEM_TEST          0                     boolean  Live          
SP_DEQ_SKIP_LOB                 0                     boolean  Live          
SP_DEQ_SLEEP                    0                     seconds  Live          
SP_DEQ_SOURCE_EMBEDDED_SOURCE_                                 Live          
SP_DEQ_SOURCE_EMBEDDED_TARGET_                                 Live          
SP_DEQ_SWAP_BYTE                0                     number   Live          
SP_DEQ_THREAD_STACK_SIZE        4096                  kbytes   Live          
SP_DEQ_THREADS                  2                     threads  Live          
SP_DEQ_TIMEOUT                  1800                  seconds  Live          

Horizontal Partitioning parameters:

Parameter  Name                 Actual Value           Units   Set At        
------------------------------  --------------------  -------  ---------------
SP_HPP_DEBUG                    0x00000000            bitflag  Live          

Import parameters:

Parameter  Name                 Actual Value           Units   Set At        
------------------------------  --------------------  -------  ---------------
SP_IMP_DEBUG                    0x00000000            bitflag  Live          
SP_IMP_TIMEOUT                  0                     seconds  Live          
SP_IMP_WCMT_MSGCNT              10000                 message  Live          
SP_IMP_WCMT_TIMEOUT             30                    seconds  Live          

License parameters:

Parameter  Name                 Actual Value           Units   Set At        
------------------------------  --------------------  -------  ---------------
SP_LIC_DEBUG                    0x00000000            bitflag  Live          

Debug Logging parameters:

Parameter  Name                 Actual Value           Units   Set At        
------------------------------  --------------------  -------  ---------------
SP_LOG_DEBUG                    0x00000000            bitflag  Live          

Configuration Management parameters:

Parameter  Name                 Actual Value           Units   Set At        
------------------------------  --------------------  -------  ---------------
SP_OCF_DEBUG                    0x00000000            bitflag  Live          
SP_OCF_LOCK_WAIT_TIME           5                     minutes  Live          
SP_OCF_THREAD_COUNT             3                     threads  Live          

Capture parameters:

Parameter  Name                 Actual Value           Units   Set At        
------------------------------  --------------------  -------  ---------------
SP_OCT_ANALYZE                  0x00000000            bitflag  Live          
SP_OCT_APPL_PARSE_FLAG          1                              Restart Process
SP_OCT_ARCH_LOC                 /home                          Live          
SP_OCT_ASM_CONNECT_DESC                                        Restart Process
SP_OCT_ASM_DEBUG                0x00000000            bitflag  Live          
SP_OCT_ASM_ECACHE_SIZE          20                    count    Restart Process
SP_OCT_ASM_FLIST_SIZE           10                    count    Restart Process
SP_OCT_ASM_SID                  +ASM1                          Restart Process
   Default   Value:    
SP_OCT_ASM_SLIST_SIZE           10                    count    Restart Process
SP_OCT_ASM_SUPPORT              1                     flag     Restart Process
   Default   Value:     0
SP_OCT_AUDIT_DEBUG              0x00000000            bitflag  Live          
SP_OCT_BIO_DEBUG                0x00000000            bitflag  Live          
SP_OCT_CACHE_DEBUG              0x00000000            bitflag  Live          
SP_OCT_CHECKPOINT_FREQ          40000                 message  Live          
SP_OCT_CHECKPOINT_LOG           2                     logs     Live          
SP_OCT_CHECKPOINT_TIME          120                   seconds  Live          
SP_OCT_CK_LOC_FIRST             0                     flag     Restart Process
SP_OCT_DATA_OBJ_CACHE_SIZE      50                    values   Live          
SP_OCT_DATE_MSG                 0                              Live          
SP_OCT_DDL_DEBUG                0x00000000            bitflag  Live          
SP_OCT_DDL_LOGGING              2                              Live          
SP_OCT_DEBUG                    0x00000000            bitflag  Live          
SP_OCT_DEF_DAY                  1                              Live          
SP_OCT_DEF_HOUR                 0                              Live          
SP_OCT_DEF_MIN                  0                              Live          
SP_OCT_DEF_MONTH                1                              Live          
SP_OCT_DEF_SEC                  0                              Live          
SP_OCT_DEF_YEAR                 1999                           Live          
SP_OCT_DENIED_USERID            91                    number   Live          
   Default   Value:     0x00000000
SP_OCT_ERROR_THRESHOLD          3                              Live          
SP_OCT_FIO_DEBUG                0x00000000            bitflag  Live          
SP_OCT_GEN_DEBUG                0x00000000            bitflag  Live          
SP_OCT_GEN_DEBUG_OBJID          -1                    number   Live          
SP_OCT_GEN_STOP                 0x00000000            bitflag  Live          
SP_OCT_IDLE_LOGIN               60                    seconds  Restart Process
SP_OCT_IOT_RB_BATCH_SIZE        5000                           Live          
SP_OCT_LOB_BUFFER_SIZE          5242880                        Restart Process
SP_OCT_LOG_FILESIZE             50000000              bytes    Restart Process
SP_OCT_LOG_MEMBER               %                              Restart Process
SP_OCT_LOG_NUMFILES             3                     number   Restart Process
SP_OCT_LOG_READ_SIZE            64                             Restart Process
SP_OCT_LOGWRAP_RESTART          300                   seconds  Live          
SP_OCT_MAX_SESSIONS             4000                           Restart Process
SP_OCT_OCAP_CONFIG              0                              Live          
SP_OCT_OCAP_DEBUG               0x00000000            bitflag  Live          
SP_OCT_OCM_DEBUG                0x00000000            bitflag  Live          
SP_OCT_OLOG_DEBUG               0x00000000            bitflag  Live          
SP_OCT_OLOG_DELAY               10000                 microse  Live          
SP_OCT_OLOG_DIRECT              0                     # Enabl  Restart Process
SP_OCT_OLOG_LOGPAR_QSIZE        5000                           Restart Process
SP_OCT_OLOG_NO_DATA_DELAY       100000                microse  Unknown       
SP_OCT_OLOG_QUEUE_SIZE          1000                  # Queue  Restart Process
SP_OCT_OLOG_REOPEN              1                     # Flag   Restart Process
SP_OCT_OLOG_THREAD_SINGLE       1                              Restart Process
SP_OCT_OLP_DEBUG                0x00000000            bitflag  Live          
SP_OCT_OPC_DEBUG                0x00000000            bitflag  Live          
SP_OCT_OPP_DEBUG                0x00000000            bitflag  Live          
SP_OCT_OPS_LOGREADER_DEBUG      0x00000000            bitflag  Live          
SP_OCT_OPS_LOGREADER_DELAY      500000                microse  Unknown       
SP_OCT_OPS_LOGREADER_RETRY      3                     retries  Unknown       
SP_OCT_OPS_NO_DATA_DELAY        5                     decisec  Unknown       
SP_OCT_OPS_OPSLOG_DEBUG         0x00000000            bitflag  Live          
SP_OCT_OPS_QUEUE_SIZE           10000                          Restart Process
SP_OCT_OPS_SEQ_DEBUG            0x00000000            bitflag  Live          
SP_OCT_REBUILD_LOBCACHE         0                              Restart Process
SP_OCT_REDO_RAW_OFFSET          -1                    bytes    Restart Process
SP_OCT_REDOLOG_ENSURE           2                     seconds  Live          
SP_OCT_REDUCED_KEY              1                              Live          
SP_OCT_REPLICATE_ALL_DDL        0                              Live          
SP_OCT_REPLICATE_DDL            0                              Live          
   Default   Value:     3
SP_OCT_REPLICATE_DLOAD          1                              Live          
SP_OCT_REPLICATE_POSTER         0                              Restart Process
SP_OCT_REQUIRED_DATA_IS_LOGGED  1                              Restart Process
SP_OCT_RESTART_THRESHOLD        0                     retries  Live          
SP_OCT_SKIP_BAD_BLOCK           0                              Restart Process
SP_OCT_TARGET_COMPATIBILITY     6.0                            Live          
   Default   Value:     7.0
SP_OCT_TIME_LIMIT               300                   seconds  Live          
SP_OCT_TIME_SEQUENCER           0                              Live          
SP_OCT_TRP_DEBUG                0x00000000            bitflag  Live          
SP_OCT_UTILIZATION_TIMERS       0                              Live          

Object Id parameters:

Parameter  Name                 Actual Value           Units   Set At        
------------------------------  --------------------  -------  ---------------
SP_OID_DEBUG                    0x00000000            bitflag  Live          

Post parameters:

Parameter  Name                 Actual Value           Units   Set At        
------------------------------  --------------------  -------  ---------------
SP_OPO_BATCH_REEXECUTE          1                              Live          
SP_OPO_BLOCK_QUERY              1                              Live          
SP_OPO_CHARACTERSET                                            Restart Process
SP_OPO_CHECK_INACTIVE_SESSION   0                              Live          
SP_OPO_CONT_ON_ERR              0                              Live          
SP_OPO_CONTINUE_ON_MISMATCH     0                              Live          
SP_OPO_DEBUG                    0x00000000            bitflag  Live          
SP_OPO_DEBUG_CR                 0x00000000            bitflag  Live          
SP_OPO_DEBUG_FLAG               0x00000000            bitflag  Live          
SP_OPO_DEBUG_KCA                0x00000000            bitflag  Live          
SP_OPO_DELAY_TIME               5                     seconds  Live          
SP_OPO_DELAY_TIME_MAX           10                    seconds  Live          
SP_OPO_DISABLE_OBJECT_NUM                                      Live          
SP_OPO_ERR_ROWID                1                              Live          
SP_OPO_GENERIC_CR               1                              Restart Process
   Default   Value:     0
SP_OPO_HINTS_LIMIT              100                   hints    Restart Process
SP_OPO_IDLE_LOGIN               60                    seconds  Live          
SP_OPO_IDLE_LOGOUT              300                   seconds  Live          
SP_OPO_KCA_REHASHRATIO          60                             Restart Process
SP_OPO_LCACHE_DEBUG             0x00000000            bitflag  Live          
SP_OPO_LOG_FILESIZE             50000000              bytes    Restart Process
SP_OPO_LOG_NUMFILES             3                     number   Restart Process
SP_OPO_MAX_CDA                  50                             Restart Process
SP_OPO_MAX_OEXN_TIME            1800                  seconds  Restart Process
   Default   Value:     180
SP_OPO_MAX_ROLLBACK_MESSAGES    10000                          Restart Process
SP_OPO_MAX_SESSIONS             4000                           Live          
SP_OPO_NCHAR_CHARACTERSET                                      Restart Process
SP_OPO_NERR_MAX                 100                            Live          
SP_OPO_NLS_LANG                                                Restart Process
SP_OPO_OBJID_DEBUG              0                     number   Live          
SP_OPO_OBREAK_DELAY_TIME        5                     seconds  Live          
SP_OPO_OBREAK_NOT_USED          0                              Restart Process
SP_OPO_OPST_DEBUG               0x00000000            bitflag  Live          
SP_OPO_OUT_OF_SYNC_SUSPEND      0                              Live          
SP_OPO_PARSE_TIMEOUT            100                   msec     Live          
SP_OPO_POSTER_DELAY             0                     minutes  Live          
SP_OPO_PR_STAT_ON               0                              Live          
SP_OPO_PRB_MISMATCH_SUSPEND     0                              Live          
SP_OPO_QUE_REREAD_INTERVAL      1                     seconds  Live          
SP_OPO_READRELEASE_INTERVAL     10000                          Live          
   Default   Value:     100
SP_OPO_RETRIES_MAX              10                    retries  Live          
SP_OPO_RETRY_DELAY_TIME         0                     seconds  Live          
SP_OPO_SAVEPOINT_SIZE           1000                           Restart Process
SP_OPO_SQL_CACHE_DISABLE        1                              Restart Process
   Default   Value:     0
SP_OPO_SQL_DEBUG                0x00000000            bitflag  Live          
SP_OPO_SQL_LCACHE_DEBUG         0x00000000            bitflag  Live          
SP_OPO_SQL_TRACE_ON             0                              Restart Process
SP_OPO_STOP_ON_DDL_ERR          1                              Live          
SP_OPO_THREADS_MAX              64                             Restart Process
SP_OPO_USE_VARNUM               0                              Restart Process
SP_OPO_UTILIZATION_TIMER_THREA  64                             Live          
SP_OPO_UTILIZATION_TIMERS       0                              Live          
SP_OPO_WAIT_MSG_DELAY           300                   seconds  Restart Process
SP_OPO_XFORM_EXCLUDE_ROWID      0                              Restart Process

Read parameters:

Parameter  Name                 Actual Value           Units   Set At        
------------------------------  --------------------  -------  ---------------
SP_ORD_BATCH_ENABLE             1                              Live          
SP_ORD_BATCH_MATCH_MIN          2                     operati  Restart Process
SP_ORD_BATCH_MAX                50                    batches  Restart Process
SP_ORD_CDA_LIMIT                5                     cdas     Restart Process
SP_ORD_DATE_MSG                 0                              Live          
SP_ORD_DEBUG                    0x00000000            bitflag  Live          
SP_ORD_DEBUG_FLAG               0x00000000            bitflag  Live          
SP_ORD_DEBUG_OBJECT             0                     objecti  Live          
SP_ORD_DELAY_RECORDS            200                   records  Live          
SP_ORD_FIRST_FIND               1                              Restart Process
SP_ORD_HP_HASH                  16                    slots    Restart Process
SP_ORD_HP_IN_SYNC               0                              Restart Process
SP_ORD_LDA_ARRAY_SIZE           5                     logins   Restart Process
SP_ORD_LOG_FILESIZE             50000000              bytes    Restart Process
SP_ORD_LOG_NUMFILES             3                     number   Restart Process
SP_ORD_LOGIN_O                  xxx=========xxxxx           Set Up        
  
   Default   Value:    
SP_ORD_MSGS_CK_FREQ             10000                 number   Restart Process
SP_ORD_NLS_LANG                                                Restart Process
SP_ORD_OWNER_O                  xxx========xxxx                     Set Up        
  
   Default   Value:    
SP_ORD_RCM_SKIP_RATIO           2                     ratio    Restart Process
SP_ORD_RESTART_THRESHOLD        0                     retries  Live          
SP_ORD_RMSG_LIMIT               20000                 readrel  Live          
SP_ORD_SEND_DDL_TO_FIRST        0                              Live          
SP_ORD_SKIP_OBJECT              0                     objecti  Live          
SP_ORD_UTILIZATION_TIMERS       0                              Live          

Support Library parameters:

Parameter  Name                 Actual Value           Units   Set At        
------------------------------  --------------------  -------  ---------------
SP_OSP_DEBUG                    0x00000000            bitflag  Live          

Sync parameters:

Parameter  Name                 Actual Value           Units   Set At        
------------------------------  --------------------  -------  ---------------
SP_OSY_COMPRESSION              6                              Live          
SP_OSY_DEBUG                    0x00000000            bitflag  Live          
SP_OSY_EXP_BUFFER_SIZE          1024                  kbytes   Live          
SP_OSY_IMP_BUFFER_SIZE          1024                  kbytes   Live          
SP_OSY_LOCK_TIMEOUT             2                     Seconds  Live          
SP_OSY_PORT                     2501                           Live          
SP_OSY_POST_TIMEOUT             1800                  Seconds  Live          
SP_OSY_TCP_TIMEOUT              60                    Seconds  Live          
SP_OSY_THREADS                  5                     Thread   Live          

Parameter Database parameters:

Parameter  Name                 Actual Value           Units   Set At        
------------------------------  --------------------  -------  ---------------
SP_PDB_DEBUG                    0x00000000            bitflag  Live          

SharePlex Queues parameters:

Parameter  Name                 Actual Value           Units   Set At        
------------------------------  --------------------  -------  ---------------
SP_QUE_DEBUG                    0x00000000            bitflag  Live          
SP_QUE_DFILSIZ                  8388608               bytes    Restart Cop   
SP_QUE_MAX_QUEUES               25                    queues   Restart Cop   
SP_QUE_POST_SHMSIZE             33554432              bytes    Restart Cop   
SP_QUE_Q_SHMSIZE                8388608               bytes    Restart Cop   
SP_QUE_SAVE_DATA                0                              Restart Cop   
SP_QUE_SAVE_DISCARDED_MSG       0                              Restart Cop   
SP_QUE_SHMDBUF                  32768                 bytes    Restart Cop   
SP_QUE_SHMSIZE                  33554432              bytes    Restart Cop   
SP_QUE_SUBQUEUE_TOO_OLD         300                   seconds  Live          
SP_QUE_SYNC                     2                              Restart Cop   
SP_QUE_USE_OVF                  0                              Restart Cop   

Reconcile parameters:

Parameter  Name                 Actual Value           Units   Set At        
------------------------------  --------------------  -------  ---------------
SP_RCL_DEBUG                    0x00000000            bitflag  Live          
SP_RCL_IDLE_LOGIN               60                    seconds  Live          
SP_RCL_LOG_FILESIZE             50000000              bytes    Restart Process
SP_RCL_LOG_NUMFILES             3                     number   Restart Process

Routing Interface Module parameters:

Parameter  Name                 Actual Value           Units   Set At        
------------------------------  --------------------  -------  ---------------
SP_RIM_DEBUG                    0x00000000            bitflag  Live          

Reliable Message Protocol parameters:

Parameter  Name                 Actual Value           Units   Set At        
------------------------------  --------------------  -------  ---------------
SP_RMP_DEBUG                    0x00000000            bitflag  Live          

Response Module parameters:

Parameter  Name                 Actual Value           Units   Set At        
------------------------------  --------------------  -------  ---------------
SP_RSP_DEBUG                    0x00000000            bitflag  Live          

SharePlex Statistics parameters:

Parameter  Name                 Actual Value           Units   Set At        
------------------------------  --------------------  -------  ---------------
SP_SHS_DEBUG                    0x00000000            bitflag  Live          
SP_SHS_MAXLOCK                  12                    writers  Restart Cop   
SP_SHS_MAXWRITERS               2000                  writers  Restart Cop   
SP_SHS_SHMSIZE                  8388608               bytes    Restart Cop   

Event Logging parameters:

Parameter  Name                 Actual Value           Units   Set At        
------------------------------  --------------------  -------  ---------------
SP_SLG_DEBUG                    0x00000000            bitflag  Live          
SP_SLG_LOG_MAXSIZE              500                   mbytes   Restart Cop   
SP_SLG_SNMP_ACTIVE              0                              Restart Cop   
SP_SLG_SNMP_COMMUNITY                                          Restart Cop   
SP_SLG_SNMP_ERROR               0                              Restart Cop   
SP_SLG_SNMP_EXIT                0                              Restart Cop   
SP_SLG_SNMP_HOST                                               Restart Cop   
SP_SLG_SNMP_INT_ERROR           0                              Restart Cop   
SP_SLG_SNMP_LAUNCH              0                              Restart Cop   
SP_SLG_SNMP_MJR_ERRNUM          0                              Restart Cop   
SP_SLG_SNMP_MNR_ERRNUM          0                              Restart Cop   
SP_SLG_SNMP_OUT_OF_SYNC         0                              Restart Cop   
SP_SLG_SNMP_SHUTDOWN            0                              Restart Cop   
SP_SLG_SNMP_STARTUP             0                              Restart Cop   
SP_SLG_SNMP_SYS_ERROR           0                              Restart Cop   

Services Database parameters:

Parameter  Name                 Actual Value           Units   Set At        
------------------------------  --------------------  -------  ---------------
SP_SRV_DEBUG                    0x00000000            bitflag  Live          

Status Database parameters:

Parameter  Name                 Actual Value           Units   Set At        
------------------------------  --------------------  -------  ---------------
SP_STT_DEBUG                    0x00000000            bitflag  Live          

System parameters:

Parameter  Name                 Actual Value           Units   Set At        
------------------------------  --------------------  -------  ---------------
SP_SYS_DEBUG                    0x00000000            bitflag  Live          
SP_SYS_HOST_NAME                                               Restart Cop   
SP_SYS_IN_SYNC                  0                              Restart Process
SP_SYS_JOB_HISTORY_RETENTION    90                    days     Live          
SP_SYS_LIC_11111                xxx===============xxx           Install       
   Default   Value:    
SP_SYS_LOG_INTERVAL             30                    seconds  Live          
SP_SYS_QUE_FULL                 20000000              bytes    Live          
SP_SYS_QUE_OK                   10000000              bytes    Live          
SP_SYS_SUSPEND_ON_ERROR         1                              Live          
SP_SYS_VAR_FULL                 30                    mbytes   Live          
SP_SYS_VAR_OK                   50                    mbytes   Live          

Utility parameters:

Parameter  Name                 Actual Value           Units   Set At        
------------------------------  --------------------  -------  ---------------
SP_UTL_DEBUG                    0x00000000            bitflag  Live          

Export parameters:

Parameter  Name                 Actual Value           Units   Set At        
------------------------------  --------------------  -------  ---------------
SP_XPT_ALTERNATE_HOST                                          Restart Process
SP_XPT_DEBUG                    0x00000000            bitflag  Live          
SP_XPT_KEEPALIVE                1                              Restart Process
   Default   Value:     0
SP_XPT_PORT_OVERRIDE            0                              Restart Process
SP_XPT_SO_SNDBUF                0                     bytes    Restart Process
SP_XPT_TIMEOUT                  0                     seconds  Live          
SP_XPT_USE_LOCALHOST            0                              Restart Process

sp_ctrl (xxxx:11111)>
sp_ctrl (xxxx:11111)> version

   SharePlex Version = 7.0.2

sp_ctrl (xxxx:11111)>

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值