- 论坛徽章:
- 0
|
测试环境:sco 5.07 / informix 7.22.UC3
主机配置:
/etc/hosts
192.168.0.3 psrv
192.168.0.4 ssrv
/etc/services
sqlexec 6000/tcp
/home/informix/.rhosts
ssrv
/home/informix/etc/sqlhosts
psrv onipcshm psrv sqlexec
psrv_alias ontlitcp psrv sqlexec
ssrv_alias ontlitcp ssrv sqlexec
从机配置:
/etc/hosts
192.168.0.3 psrv
192.168.0.4 ssrv
/etc/services
sqlexec 6000/tcp
/home/informix/.rhosts
psrv
/home/informix/etc/sqlhosts
ssrv onipcshm ssrv sqlexec
ssrv_alias ontlitcp ssrv sqlexec
psrv_alias ontlitcp psrv sqlexec
//-----------------------------------------------
主机操作
$ oninit
$ ontape -s -L 0
Archive to tape device 'nul' is complete.
Program over.
$ onmode -d primary ssrv_alias
$ onstat -
INFORMIX-OnLine Version 7.22.UC3 -- On-Line (Prim) -- Up 00:02:52 -- 16280 Kbytes
日志文件online.log
09:34:49 Event alarms enabled. ALARMPROG = '/home/informix/log_full.sh'
09:34:52 DR: DRAUTO is 0 (Off)
09:34:53 INFORMIX-OnLine Initialized -- Shared Memory Initialized.
09:34:53 Physical Recovery Started.
09:34:54 Physical Recovery Complete: 0 Pages Restored.
09:34:54 Logical Recovery Started.
09:34:57 Logical Recovery Complete.
0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
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
主机onconfig文件
#**************************************************************************
#
# INFORMIX SOFTWARE, INC.
#
# Title: onconfig.std
# Description: INFORMIX-OnLine Configuration Parameters
#
#**************************************************************************
# Root Dbspace Configuration
ROOTNAME rootdbs # Root dbspace name
ROOTPATH /home/informix/dbs/rootdbs
# Path for device containing root dbspace
ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes)
ROOTSIZE 500000 # Size of root dbspace (Kbytes)
# Disk Mirroring Configuration Parameters
MIRROR 0 # Mirroring flag (Yes = 1, No = 0)
MIRRORPATH # Path for device containing mirrored root
MIRROROFFSET 0 # Offset into mirrored device (Kbytes)
# Physical Log Configuration
PHYSDBS rootdbs # Location (dbspace) of physical log
PHYSFILE 1000 # Physical log file size (Kbytes)
# Logical Log Configuration
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)
# Backup/Restore variables
BAR_ACT_LOG /tmp/bar_act.log
BAR_MAX_BACKUP 0
BAR_RETRY 1
BAR_NB_XPORT_COUNT 10
BAR_XFER_BUF_SIZE 31
# 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
参考
http://bbs.chinaunix.net/viewthread.php?tid=665646
http://space.itpub.net/312079/viewspace-245838
[ 本帖最后由 lutabo 于 2008-12-29 09:56 编辑 ] |
|