09:34:57 Dataskip is now OFF for all dbspaces
09:34:57 On-Line Mode
09:34:57 Checkpoint Completed: duration was 0 seconds.
09:36:36 Checkpoint Completed: duration was 0 seconds.
09:37:09 DR: new type = primary, secondary server name = ssrv_alias
09:37:09 DR: Trying to connect to secondary server ...
09:37:11 DR: Primary server connected
09:37:11 DR: Receive error
09:37:11 DR: Failure recovery error (2)
09:37:12 DR: Turned off on primary server
09:37:12 Checkpoint Completed: duration was 0 seconds.
09:37:12 DR: Cannot connect to secondary server
09:37:12 Process exited with return code 1: /bin/sh /bin/sh -c /home/informix/log_full.sh 3 15 "Data Replication failure." "DR: Cannot connect to secondary server"
09:37:12 Process exited with return code 1: /bin/sh /bin/sh -c /home/informix/log_full.sh 3 15 "Data Replication failure." "DR: Turned off on primary server"
09:37:23 DR: Primary server connected
09:37:23 DR: Receive error
从机操作
$ oninit
$ ontape -p
Please mount tape 1 on /dev/null and press Return to continue ...
Restore a level 0 archive (y/n) n
Program over.
$ onmode -d secondary psrv_alias
DR: Unable to change server type
日志文件online.log
09:34:52 Event alarms enabled. ALARMPROG = '/home/informix/log_full.sh'
09:34:56 DR: DRAUTO is 0 (Off)
09:34:57 INFORMIX-OnLine Initialized -- Shared Memory Initialized.
09:34:57 Physical Recovery Started.
09:34:57 Physical Recovery Complete: 0 Pages Restored.
09:34:57 Logical Recovery Started.
09:35:00 Logical Recovery Complete.
0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
09:35:00 Dataskip is now OFF for all dbspaces
09:35:00 On-Line Mode
09:35:00 Checkpoint Completed: duration was 0 seconds.
09:37:12 DR: Server type incompatible
09:37:23 DR: Server type incompatible
09:37:35 DR: Server type incompatible
09:37:47 DR: Server type incompatible
09:37:59 DR: Server type incompatible
09:38:11 DR: Server type incompatible
09:38:23 DR: Server type incompatible
09:38:29 DR: Error - Server must be in recovery mode
09:38:35 DR: Server type incompatible
09:38:47 DR: Server type incompatible
09:38:59 DR: Server type incompatible
09:39:12 DR: Server type incompatible
09:39:24 DR: Server type incompatible
LOGFILES 6 # Number of logical log files
LOGSIZE 10000 # Logical log size (Kbytes)
# Diagnostics
MSGPATH /home/informix/online.log # System message log file path
CONSOLE /dev/console # System console message path
ALARMPROGRAM /home/informix/log_full.sh # Alarm program path
# System Archive Tape Device
TAPEDEV /dev/null # Tape device path
TAPEBLK 16 # Tape block size (Kbytes)
TAPESIZE 10240 # Maximum amount of data to put on tape (Kbytes)
# Log Archive Tape Device
LTAPEDEV /dev/null # Log tape device path
LTAPEBLK 16 # Log tape block size (Kbytes)
LTAPESIZE 10240 # Max amount of data to put on log tape (Kbytes)
# Optical
STAGEBLOB # INFORMIX-OnLine/Optical staging area
# System Configuration
SERVERNUM 0 # Unique id corresponding to a OnLine instance
DBSERVERNAME psrv # Name of default database server
DBSERVERALIASES psrv_alias # List of alternate dbservernames
NETTYPE ipcshm,1,10,CPU
NETTYPE tlitcp,1,40,NET
DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed env.
RESIDENT 0 # Forced residency flag (Yes = 1, No = 0)
MULTIPROCESSOR 0 # 0 for single-processor, 1 for multi-processor
NUMCPUVPS 1 # Number of user (cpu) vps
SINGLE_CPU_VP 1 # If non-zero, limit number of cpu vps to one
NOAGE 0 # Process aging
AFF_SPROC 0 # Affinity start processor
AFF_NPROCS 0 # Affinity number of processors
# Shared Memory Parameters
LOCKS 10000 # Maximum number of locks
BUFFERS 3000 # Maximum number of shared buffers
NUMAIOVPS # Number of IO vps
PHYSBUFF 32 # Physical log buffer size (Kbytes)
LOGBUFF 32 # Logical log buffer size (Kbytes)
LOGSMAX 6 # Maximum number of logical log files
CLEANERS 1 # Number of buffer cleaner processes
SHMBASE 0x80000000 # Shared memory base address
SHMVIRTSIZE 8000 # initial virtual shared memory segment size
SHMADD 8192 # Size of new shared memory segments (Kbytes)
SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited
CKPTINTVL 300 # Check point interval (in sec)
LRUS 8 # Number of LRU queues
LRU_MAX_DIRTY 60 # LRU percent dirty begin cleaning limit
LRU_MIN_DIRTY 50 # LRU percent dirty end cleaning limit
LTXHWM 50 # Long transaction high water mark percentage
LTXEHWM 60 # Long transaction high water mark (exclusive)
TXTIMEOUT 0x12c # Transaction timeout (in sec)
STACKSIZE 32 # Stack size (Kbytes)
# System Page Size
# BUFFSIZE - OnLine no longer supports this configuration parameter.
# To determine the page size used by OnLine on your platform
# see the last line of output from the command, 'onstat -b'.
# Recovery Variables
# OFF_RECVRY_THREADS:
# Number of parallel worker threads during fast recovery or an offline restore.
# ON_RECVRY_THREADS:
# Number of parallel worker threads during an online restore.
OFF_RECVRY_THREADS 10 # Default number of offline worker threads
ON_RECVRY_THREADS 1 # Default number of online worker threads
# Data Replication Variables
# DRAUTO: 0 manual, 1 retain type, 2 reverse type
DRAUTO 0 # DR automatic switchover
DRINTERVAL 30 # DR max time between DR buffer flushes (in sec)
DRTIMEOUT 30 # DR network timeout (in sec)
DRLOSTFOUND /home/informix/etc/dr.lostfound # DR lost+found file path
# CDR Variables
CDR_LOGBUFFERS 2048 # size of log reading buffer pool (Kbytes)
CDR_EVALTHREADS 1,2 # evaluator threads (per-cpu-vp,additional)
CDR_DSLOCKWAIT 5 # DS lockwait timeout (seconds)
CDR_QUEUEMEM 4096 # Maximum amount of memory for any CDR queue (Kbytes)
# Read Ahead Variables
RA_PAGES # Number of pages to attempt to read ahead
RA_THRESHOLD # Number of pages left before next group
# DBSPACETEMP:
# OnLine equivalent of DBTEMP for SE. This is the list of dbspaces
# that the OnLine SQL Engine will use to create temp tables etc.
# If specified it must be a colon separated list of dbspaces that exist
# when the OnLine system is brought online. If not specified, or if
# all dbspaces specified are invalid, various ad hoc queries will create
# temporary files in /tmp instead.
DBSPACETEMP # Default temp dbspaces
# DUMP*:
# The following parameters control the type of diagnostics information which
# is preserved when an unanticipated error condition (assertion failure) occurs
# during OnLine operations.
# For DUMPSHMEM, DUMPGCORE and DUMPCORE 1 means Yes, 0 means No.
DUMPDIR /tmp # Preserve diagnostics in this directory
DUMPSHMEM 1 # Dump a copy of shared memory
DUMPGCORE 0 # Dump a core image using 'gcore'
DUMPCORE 0 # Dump a core image (Warning:this aborts OnLine)
DUMPCNT 1 # Number of shared memory or gcore dumps for
# a single user's session
FILLFACTOR 90 # Fill factor for building indexes
# method for OnLine to use when determining current time
USEOSTIME 0 # 0: use internal time(fast), 1: get time from OS(slow)
# Parallel Database Queries (pdq)
MAX_PDQPRIORITY 100 # Maximum allowed pdqpriority
DS_MAX_QUERIES # Maximum number of decision support queries
DS_TOTAL_MEMORY # Decision support memory (Kbytes)
DS_MAX_SCANS 1048576 # Maximum number of decision support scans
DATASKIP off # List of dbspaces to skip
# OPTCOMPIND
# 0 => Nested loop joins will be preferred (where
# possible) over sortmerge joins and hash joins.
# 1 => If the transaction isolation mode is not
# "repeatable read", optimizer behaves as in (2)
# below. Otherwise it behaves as in (0) above.
# 2 => Use costs regardless of the transaction isolation
# mode. Nested loop joins are not necessarily
# preferred. Optimizer bases its decision purely
# on costs.
OPTCOMPIND 2 # To hint the optimizer
ONDBSPACEDOWN 2 # Dbspace down option: 0 = CONTINUE, 1 = ABORT, 2 = WAIT
LBU_PRESERVE 0 # Preserve last log for log backup
OPCACHEMAX 0 # Maximum optical cache size (Kbytes)
# HETERO_COMMIT (Gateway participation in distributed transactions)
# 1 => Heterogeneous Commit is enabled
# 0 (or any other value) => Heterogeneous Commit is disabled
HETERO_COMMIT 0
从机onconfig文件
# DUMP*:
# The following parameters control the type of diagnostics information which
# is preserved when an unanticipated error condition (assertion failure) occurs
# during OnLine operations.
# For DUMPSHMEM, DUMPGCORE and DUMPCORE 1 means Yes, 0 means No.
DUMPDIR /tmp # Preserve diagnostics in this directory
DUMPSHMEM 1 # Dump a copy of shared memory
DUMPGCORE 0 # Dump a core image using 'gcore'
DUMPCORE 0 # Dump a core image (Warning:this aborts OnLine)
DUMPCNT 1 # Number of shared memory or gcore dumps for
# a single user's session
FILLFACTOR 90 # Fill factor for building indexes
# method for OnLine to use when determining current time
USEOSTIME 0 # 0: use internal time(fast), 1: get time from OS(slow)
# Parallel Database Queries (pdq)
MAX_PDQPRIORITY 100 # Maximum allowed pdqpriority
DS_MAX_QUERIES # Maximum number of decision support queries
DS_TOTAL_MEMORY # Decision support memory (Kbytes)
DS_MAX_SCANS 1048576 # Maximum number of decision support scans
DATASKIP off # List of dbspaces to skip
# OPTCOMPIND
# 0 => Nested loop joins will be preferred (where
# possible) over sortmerge joins and hash joins.
# 1 => If the transaction isolation mode is not
# "repeatable read", optimizer behaves as in (2)
# below. Otherwise it behaves as in (0) above.
# 2 => Use costs regardless of the transaction isolation
# mode. Nested loop joins are not necessarily
# preferred. Optimizer bases its decision purely
# on costs.
OPTCOMPIND 2 # To hint the optimizer
ONDBSPACEDOWN 2 # Dbspace down option: 0 = CONTINUE, 1 = ABORT, 2 = WAIT
LBU_PRESERVE 0 # Preserve last log for log backup
OPCACHEMAX 0 # Maximum optical cache size (Kbytes)
# HETERO_COMMIT (Gateway participation in distributed transactions)
# 1 => Heterogeneous Commit is enabled
# 0 (or any other value) => Heterogeneous Commit is disabled
HETERO_COMMIT 0
主机操作步骤
$ ontape -s -L 0
Please mount tape 1 on /home/informix/dev/tapedev and press Return to continue ...
100 percent done.
Please label this tape as number 1 in the arc tape sequence.
This tape contains the following logical logs:
1
Program over.
$ onmode -d primary ssrv_alias
$ onstat -
INFORMIX-OnLine Version 7.22.UC3 -- On-Line (Prim) -- Up 00:07:34 -- 16280 Kbytes
拷贝tapedev到从机
从机操作步骤
$ ontape -p
Continue restore? (y/n)y
Do you want to back up the logs? (y/n)n
Restore a level 1 archive (y/n) n
Program over.
$ onmode -d secondary psrv_alias
$ onstat -
INFORMIX-OnLine Version 7.22.UC3 -- Fast Recovery (Sec) -- Up 00:01:10 -- 16280 Kbytes
Blocked:CKPT
主机online.log
14:23:22 DR: Primary server connected
14:23:25 Logical Log 1 Complete.
14:23:25 DR: Sending log 1, size 5000 pages, 23.56 percent used
14:23:26 Process exited with return code 1: /bin/sh /bin/sh -c /home/informix/log_full.sh 2 23 "Logical Log 1 Complete." "Logical Log 1 Complete."
14:28:25 Checkpoint Completed: duration was 0 seconds.
从机online.log
14:23:26 DR: Server type incompatible
14:23:37 DR: new type = secondary, primary server name = psrv_alias
14:23:37 DR: Trying to connect to primary server ...
14:23:39 DR: Secondary server connected
14:23:40 DR: Failure recovery from disk in progress ...
14:23:44 Logical Recovery Started.
14:23:44 Start Logical Recovery - Start Log 1, End Log ?
14:23:44 Starting Log Position - 1 0x4931ac作者: liaosnet 时间: 2008-12-29 15:11 标题: 回复 #4 lutabo 的帖子 使用onstat -Dr 监控下chunk的写入情况.....作者: lutabo 时间: 2008-12-29 15:18
//---------------------------------------------------------------------------------------------------------------------------
INFORMIX-OnLine Version 7.22.UC3 -- Fast Recovery (Sec) -- Up 00:09:23 -- 16280 Kbytes
Dbspaces
address number flags fchunk nchunks flags owner name
80c3e0ec 1 800 1 1 NL informix rootdbs
1 active, 2047 maximum