IDSV10 restore failure ontape
Posted in 2007
Topics: Backup & Restore, Storage & Space Management, Stored Procedures & SPL, Server Administration, Security, Permissions & Auditing, Logging & Checkpoints, Migration, Import/Export & Data Conversion, Platform-Specific Issues, Java & JDBC Development, Internationalization & Character Sets
Server : IBM P520 64 bits, AIX 5.3.0.0
IDS V10 version 10.00.FC6
Problem :
1) We do a complete backup level0 with
ontape -s -L 0 > backup_L0
At this time, database is OK , oninit -v shows all correct
2) onmode -ky
3) cat backup_L0 | ontape -p
4) onmode -ky
5) oninit -v results on :
================ result of oninit -v
Checking group membership to determine server run mode...succeeded
Reading configuration file '/u/informix/etc/onconfig.std'...succeeded
Creating /INFORMIXTMP/.infxdirs...succeeded
Creating infos file "/u/informix/etc/.infos.agaps_ids"...succeeded
Linking conf file "/u/informix/etc/.conf.agaps_ids"...succeeded
Writing to infos file...succeeded
Checking config parameters...succeeded
Allocating and attaching to shared memory...succeeded
Creating resident pool 2480 kbytes...succeeded
Allocating 20016 kbytes for buffer pool of 4K page size...succeeded
Initializing rhead structure...succeeded
Initializing ASF...succeeded
Initializing Dictionary Cache and SPL Routine Cache...succeeded
Bringing up ADM VP...succeeded
Creating VP classes...succeeded
Onlining 0 additional cpu vps...succeeded
Onlining 2 IO vps...succeeded
Initialization of Encryption...succeeded
Forking main_loop thread...succeeded
Initializing DR structures...succeeded
Forking 1 'ipcshm' listener threads...succeeded
Forking 1 'soctcp' listener threads...succeeded
Starting tracing...succeeded
Initializing 1 flushers...succeeded
Initializing log/checkpoint information...succeeded
Opening primary chunks...succeeded
Opening mirror chunks...succeeded
Initializing dbspaces...succeeded
Validating chunks...succeeded
Initialize Async Log Flusher...succeeded
Forking btree cleaner...succeeded
Initializing DBSPACETEMP list...succeeded
Checking database partition index...FAILED
oninit : Fatal error in shared memory initialization
================================================
And we can no longer use the database !
We try the same restore many times, with different files Backup_level0 ,
on a dataspace just cleared with oninit -i
and have always the same problem.
If we reload the database with DBIMPORT , all is OK
the problem is with ontape.
DOc here attached :
onconfig
online.log
oncheck -pr before restore
onstat -D before
ps -efenv
lsconf systeme P520
========================================= ps -ef
============================================================================
UID PID PPID C STIME TTY TIME CMD
root 1 0 0 30 oct - 0:00 /etc/init
root 82096 1 0 30 oct - 0:20 /usr/sbin/syncd 60
root 94286 1 0 30 oct - 0:00 /usr/dt/bin/dtlogin -daemon
root 98388 180362 0 30 oct - 0:00 /usr/sbin/rsct/bin/rmcd -a IBM.LPCommands -r
root 102596 122960 0 30 oct - 0:01 /usr/dt/bin/dtsession
root 106670 94286 0 30 oct - 0:07 /usr/lpp/X11/bin/X -D /usr/lib/X11//rgb -T
-force :0 -auth /var/dt/A:0-Z-3eUa
root 110732 1 0 30 oct - 0:00 /usr/lib/errdemon
root 122960 94286 0 30 oct - 0:00 dtlogin <:0> -daemon
root 127056 180362 0 30 oct - 0:00 /usr/sbin/rsct/bin/IBM.AuditRMd
root 131256 180362 0 30 oct - 0:00 /usr/sbin/inetd
root 135304 1 0 30 oct - 0:00 /usr/dt/bin/ttsession -s
root 168018 1 0 30 oct - 0:00 /usr/ccs/bin/shlap64
root 180362 1 0 30 oct - 0:00 /usr/sbin/srcmstr
root 188606 180362 0 30 oct - 0:00 /usr/sbin/rpc.lockd -d 0
root 192660 180362 0 30 oct - 0:00 /usr/sbin/portmap
root 196710 180362 0 30 oct - 0:00 /usr/sbin/hostmibd
root 200810 180362 0 30 oct - 0:00 /usr/sbin/snmpd
root 204904 180362 0 30 oct - 0:00 /usr/sbin/snmpmibd
root 209002 180362 0 30 oct - 0:00 /usr/sbin/aixmibd
root 213104 1 0 30 oct - 0:00 /usr/sbin/cron
daemon 217202 180362 0 30 oct - 0:00 /usr/sbin/rpc.statd -d 0 -t 50
root 221292 180362 0 30 oct - 0:00 /usr/sbin/syslogd
root 225390 180362 0 30 oct - 0:00 sendmail: connexions acceptées
root 229524 180362 0 30 oct - 0:00 /usr/sbin/writesrv
root 233604 180362 0 30 oct - 0:00 /usr/sbin/biod 6
root 241868 180362 0 30 oct - 0:00 /usr/sbin/qdaemon
root 245920 180362 0 30 oct - 0:00 /usr/sbin/muxatmd
root 254088 1 0 30 oct - 0:28 /usr/bin/xmwlm -L
root 258226 180362 0 30 oct - 0:00 /usr/sbin/rsct/bin/IBM.ERrmd
root 262362 1 0 30 oct - 0:00 /usr/sbin/uprintfd
root 266416 1 0 30 oct lft0 0:00 /usr/sbin/getty /dev/console
root 270570 102596 0 30 oct - 0:00 dtfile
root 274594 131256 0 30 oct - 0:00 rpc.ttdbserver 100083 1
root 278688 282782 0 30 oct - 0:00 /usr/dt/bin/dtexec -open 0 -ttprocid
2.179rxl 01 135304 1342177279 1 1 0 192.168.4.44 4_102_1 /usr/dt/bin/dtterm
root 282782 102596 0 30 oct - 0:08 dtwm
root 286874 278688 0 30 oct - 0:07 /usr/dt/bin/dtterm
root 290968 180362 0 30 oct - 0:00 /usr/sbin/rsct/bin/IBM.ServiceRMd
root 295100 180362 0 30 oct - 0:01 /usr/sbin/rsct/bin/IBM.CSMAgentRMd
root 299172 270570 0 30 oct - 0:00 dtfile
informix 303330 376850 0 30 oct pts/0 0:00 -ksh
root 307204 360522 0 19:16:38 pts/2 0:00 -ksh
root 311470 450628 0 16:52:20 - 0:00 /usr/dt/bin/dtscreen
root 323820 270570 0 30 oct - 0:00 /usr/dt/bin/dtexec -open 0 -ttprocid
3.179rxl 01 135304 1342177279 1 1 0 192.168.4.44 4_102_1 /usr/dt/bin/dtterm
root 327918 446618 0 19:54:43 pts/5 0:00 -ksh
informix 331962 364748 0 30 oct pts/3 0:00 -ksh
root 336046 368824 0 30 oct pts/4 0:00 /usr/bin/ksh
root 360522 131256 0 19:16:38 - 0:00 telnetd -a
root 364748 385254 0 30 oct pts/3 0:00 /usr/bin/ksh
root 368824 393446 0 30 oct - 0:00 /usr/dt/bin/dtterm
root 376850 286874 0 30 oct pts/0 0:00 /usr/bin/ksh
root 385254 323820 0 30 oct - 0:00 /usr/dt/bin/dtterm
root 389336 413732 0 31 oct - 0:00 dtpad
root 393446 270570 0 30 oct - 0:00 /usr/dt/bin/dtexec -open 0 -ttprocid
3.179rxl 01 135304 1342177279 1 1 0 192.168.4.44 4_110_1 /usr/dt/bin/dtterm
root 413732 135304 0 31 oct - 0:00 /bin/bsh /bin/bsh /bin/bsh
root 446618 131256 0 19:54:43 - 0:00 telnetd -a
root 450628 102596 0 16:52:20 - 0:00 /usr/dt/bin/dtexec -open 0 -ttprocid
1.179rxl 01 135304 1342177279 1 1 0 192.168.4.44 4_996_1 /usr/dt/bin/dtscreen
-mode blank
root 454894 327918 0 16:53:13 pts/5 0:00 ps -ef
=================================== env
================================================================================
==
_=/usr/bin/env
LANG=fr_FR
LOGIN=root
PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/bin/X11:/sbin:/usr/java14/jre/bin:/usr/java14/bin
LC__FASTMSG=true
EDITOR=vi
HISTFILE=/tmp/hist5
LOGNAME=root
MAIL=/usr/spool/mail/root
LOCPATH=/usr/lib/nls/loc
PS1=agaps02-root:$PWD #
USER=root
AUTHSTATE=compat
SHELL=/usr/bin/ksh
ODMDIR=/etc/objrepos
HOME=/
TERM=vt220
MAILMSG=[YOU HAVE NEW MAIL]
PWD=/tmp
TZ=NFT-1DFT
A__z=! LOGNAME
NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat
==============================================lsconf of server
==========================================================
System Model: IBM,9131-52A
Machine Seri
1. Are you restoring level 0 backup on same server or another one? If another
one, are VG/LUN are exactly same as primary one (primary one = where ontape
backup done)?
2. Did you run oncheck to varify INDEX & DATA pages (I thinks it is cDI)?
3. I will check ipcs -m, just in case
4. I would also try restore with: ontape -r
Cheers
YVES VALLET <yvallet@ilta.fr> wrote:
Server : IBM P520 64 bits, AIX 5.3.0.0
IDS V10 version 10.00.FC6
Problem :
1) We do a complete backup level0 with
ontape -s -L 0 > backup_L0
At this time, database is OK , oninit -v shows all correct
2) onmode -ky
3) cat backup_L0 | ontape -p
4) onmode -ky
5) oninit -v results on :
================ result of oninit -v
Checking group membership to determine server run mode...succeeded
Reading configuration file '/u/informix/etc/onconfig.std'...succeeded
Creating /INFORMIXTMP/.infxdirs...succeeded
Creating infos file "/u/informix/etc/.infos.agaps_ids"...succeeded
Linking conf file "/u/informix/etc/.conf.agaps_ids"...succeeded
Writing to infos file...succeeded
Checking config parameters...succeeded
Allocating and attaching to shared memory...succeeded
Creating resident pool 2480 kbytes...succeeded
Allocating 20016 kbytes for buffer pool of 4K page size...succeeded
Initializing rhead structure...succeeded
Initializing ASF...succeeded
Initializing Dictionary Cache and SPL Routine Cache...succeeded
Bringing up ADM VP...succeeded
Creating VP classes...succeeded
Onlining 0 additional cpu vps...succeeded
Onlining 2 IO vps...succeeded
Initialization of Encryption...succeeded
Forking main_loop thread...succeeded
Initializing DR structures...succeeded
Forking 1 'ipcshm' listener threads...succeeded
Forking 1 'soctcp' listener threads...succeeded
Starting tracing...succeeded
Initializing 1 flushers...succeeded
Initializing log/checkpoint information...succeeded
Opening primary chunks...succeeded
Opening mirror chunks...succeeded
Initializing dbspaces...succeeded
Validating chunks...succeeded
Initialize Async Log Flusher...succeeded
Forking btree cleaner...succeeded
Initializing DBSPACETEMP list...succeeded
Checking database partition index...FAILED
oninit : Fatal error in shared memory initialization
================================================
And we can no longer use the database !
We try the same restore many times, with different files Backup_level0 ,
on a dataspace just cleared with oninit -i
and have always the same problem.
If we reload the database with DBIMPORT , all is OK
the problem is with ontape.
DOc here attached :
onconfig
online.log
oncheck -pr before restore
onstat -D before
ps -efenv
lsconf systeme P520
========================================= ps -ef
============================================================================
UID PID PPID C STIME TTY TIME CMD
root 1 0 0 30 oct - 0:00 /etc/init
root 82096 1 0 30 oct - 0:20 /usr/sbin/syncd 60
root 94286 1 0 30 oct - 0:00 /usr/dt/bin/dtlogin -daemon
root 98388 180362 0 30 oct - 0:00 /usr/sbin/rsct/bin/rmcd -a IBM.LPCommands -r
root 102596 122960 0 30 oct - 0:01 /usr/dt/bin/dtsession
root 106670 94286 0 30 oct - 0:07 /usr/lpp/X11/bin/X -D /usr/lib/X11//rgb -T
-force :0 -auth /var/dt/A:0-Z-3eUa
root 110732 1 0 30 oct - 0:00 /usr/lib/errdemon
root 122960 94286 0 30 oct - 0:00 dtlogin <:0> -daemon
root 127056 180362 0 30 oct - 0:00 /usr/sbin/rsct/bin/IBM.AuditRMd
root 131256 180362 0 30 oct - 0:00 /usr/sbin/inetd
root 135304 1 0 30 oct - 0:00 /usr/dt/bin/ttsession -s
root 168018 1 0 30 oct - 0:00 /usr/ccs/bin/shlap64
root 180362 1 0 30 oct - 0:00 /usr/sbin/srcmstr
root 188606 180362 0 30 oct - 0:00 /usr/sbin/rpc.lockd -d 0
root 192660 180362 0 30 oct - 0:00 /usr/sbin/portmap
root 196710 180362 0 30 oct - 0:00 /usr/sbin/hostmibd
root 200810 180362 0 30 oct - 0:00 /usr/sbin/snmpd
root 204904 180362 0 30 oct - 0:00 /usr/sbin/snmpmibd
root 209002 180362 0 30 oct - 0:00 /usr/sbin/aixmibd
root 213104 1 0 30 oct - 0:00 /usr/sbin/cron
daemon 217202 180362 0 30 oct - 0:00 /usr/sbin/rpc.statd -d 0 -t 50
root 221292 180362 0 30 oct - 0:00 /usr/sbin/syslogd
root 225390 180362 0 30 oct - 0:00 sendmail: connexions acceptées
root 229524 180362 0 30 oct - 0:00 /usr/sbin/writesrv
root 233604 180362 0 30 oct - 0:00 /usr/sbin/biod 6
root 241868 180362 0 30 oct - 0:00 /usr/sbin/qdaemon
root 245920 180362 0 30 oct - 0:00 /usr/sbin/muxatmd
root 254088 1 0 30 oct - 0:28 /usr/bin/xmwlm -L
root 258226 180362 0 30 oct - 0:00 /usr/sbin/rsct/bin/IBM.ERrmd
root 262362 1 0 30 oct - 0:00 /usr/sbin/uprintfd
root 266416 1 0 30 oct lft0 0:00 /usr/sbin/getty /dev/console
root 270570 102596 0 30 oct - 0:00 dtfile
root 274594 131256 0 30 oct - 0:00 rpc.ttdbserver 100083 1
root 278688 282782 0 30 oct - 0:00 /usr/dt/bin/dtexec -open 0 -ttprocid
2.179rxl 01 135304 1342177279 1 1 0 192.168.4.44 4_102_1 /usr/dt/bin/dtterm
root 282782 102596 0 30 oct - 0:08 dtwm
root 286874 278688 0 30 oct - 0:07 /usr/dt/bin/dtterm
root 290968 180362 0 30 oct - 0:00 /usr/sbin/rsct/bin/IBM.ServiceRMd
root 295100 180362 0 30 oct - 0:01 /usr/sbin/rsct/bin/IBM.CSMAgentRMd
root 299172 270570 0 30 oct - 0:00 dtfile
informix 303330 376850 0 30 oct pts/0 0:00 -ksh
root 307204 360522 0 19:16:38 pts/2 0:00 -ksh
root 311470 450628 0 16:52:20 - 0:00 /usr/dt/bin/dtscreen
root 323820 270570 0 30 oct - 0:00 /usr/dt/bin/dtexec -open 0 -ttprocid
3.179rxl 01 135304 1342177279 1 1 0 192.168.4.44 4_102_1 /usr/dt/bin/dtterm
root 327918 446618 0 19:54:43 pts/5 0:00 -ksh
informix 331962 364748 0 30 oct pts/3 0:00 -ksh
root 336046 368824 0 30 oct pts/4 0:00 /usr/bin/ksh
root 360522 131256 0 19:16:38 - 0:00 telnetd -a
root 364748 385254 0 30 oct pts/3 0:00 /usr/bin/ksh
root 368824 393446 0 30 oct - 0:00 /usr/dt/bin/dtterm
root 376850 286874 0 30 oct pts/0 0:00 /usr/bin/ksh
root 385254 323820 0 30 oct - 0:00 /usr/dt/bin/dtterm
root 389336 413732 0 31 oct - 0:00 dtpad
root 393446 270570 0 30 oct - 0:00 /usr/dt/bin/dtexec -open 0 -ttprocid
3.179rxl 01 135304 1342177279 1 1 0 192.168.4.44 4_110_1 /usr/dt/bin/dtterm
root 413732 135304 0 31 oct - 0:00 /bin/bsh /bin/bsh /bin/bsh
root 446618 131256 0 19:54:43 - 0:00 telnetd -a
root 450628 102596 0 16:52:20 - 0:00 /usr/dt/bin/dtexec -open 0 -ttprocid
1.179rxl 01 135304 1342177279 1 1 0 192.168.4.44 4_996_1 /usr/dt/bin/dtscreen
-mode blank
root 454894 327918 0 16:53:13 pts/5 0:00 ps -ef
=================================== env
================================================================================
==
_=/usr/bin/env
LANG=fr_FR
LOGIN=root
PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/bin/X11:/sbin:/usr/java14/jre/bin:/usr/java14/bin
LC__FASTMSG=true
EDITOR=vi
HISTFILE=/tmp/hist5
LOGNAME=root
MAIL=/usr/spool/mail/root
LOCPATH=/usr/lib/nls/loc
PS1=agaps02-root:$PWD #
USER=root
AUTHSTATE
Hi,
You perform an ontape -p command to restore a secondary instance for a
HDR.
This leaves the instance in a physical restore mode which expects either
to restore any logical information first or
to be connected to a primary instance using onmode -d (this is printed
in online.log).
I believe you have to activate the instance as secondary first after the
restore and wait for the servers to synchronize before you shut it down.
The physical restore itself did not fail according to your logfiles.
Marcus
-----Original Message-----
From: YVES VALLET [mailto:yvallet@ilta.fr]
Sent: Thursday, November 01, 2007 6:14 PM
To: ids@iiug.org
Subject: IDSV10 restore failure ontape [10291]
Server : IBM P520 64 bits, AIX 5.3.0.0
IDS V10 version 10.00.FC6
Problem :
1) We do a complete backup level0 with
ontape -s -L 0 > backup_L0
At this time, database is OK , oninit -v shows all correct
2) onmode -ky
3) cat backup_L0 | ontape -p
4) onmode -ky
5) oninit -v results on :
================ result of oninit -v
Checking group membership to determine server run mode...succeeded
Reading configuration file '/u/informix/etc/onconfig.std'...succeeded
Creating /INFORMIXTMP/.infxdirs...succeeded
Creating infos file "/u/informix/etc/.infos.agaps_ids"...succeeded
Linking conf file "/u/informix/etc/.conf.agaps_ids"...succeeded
Writing to infos file...succeeded
Checking config parameters...succeeded
Allocating and attaching to shared memory...succeeded Creating resident
pool 2480 kbytes...succeeded Allocating 20016 kbytes for buffer pool of
4K page size...succeeded Initializing rhead structure...succeeded
Initializing ASF...succeeded Initializing Dictionary Cache and SPL
Routine Cache...succeeded Bringing up ADM VP...succeeded Creating VP
classes...succeeded Onlining 0 additional cpu vps...succeeded Onlining 2
IO vps...succeeded Initialization of Encryption...succeeded Forking
main_loop thread...succeeded Initializing DR structures...succeeded
Forking 1 'ipcshm' listener threads...succeeded Forking 1 'soctcp'
listener threads...succeeded Starting tracing...succeeded Initializing 1
flushers...succeeded Initializing log/checkpoint information...succeeded
Opening primary chunks...succeeded Opening mirror chunks...succeeded
Initializing dbspaces...succeeded Validating chunks...succeeded
Initialize Async Log Flusher...succeeded Forking btree
cleaner...succeeded Initializing DBSPACETEMP list...succeeded Checking
database partition index...FAILED
oninit : Fatal error in shared memory initialization
================================================
And we can no longer use the database !
We try the same restore many times, with different files Backup_level0 ,
on a dataspace just cleared with oninit -i and have always the same
problem.
If we reload the database with DBIMPORT , all is OK the problem is with
ontape.
DOc here attached :
onconfig
online.log
oncheck -pr before restore
onstat -D before
ps -efenv
lsconf systeme P520
========================================= ps -ef
========================================================================
====
UID PID PPID C STIME TTY TIME CMD
root 1 0 0 30 oct - 0:00 /etc/init
root 82096 1 0 30 oct - 0:20 /usr/sbin/syncd 60
root 94286 1 0 30 oct - 0:00 /usr/dt/bin/dtlogin -daemon
root 98388 180362 0 30 oct - 0:00 /usr/sbin/rsct/bin/rmcd -a
IBM.LPCommands -r
root 102596 122960 0 30 oct - 0:01 /usr/dt/bin/dtsession
root 106670 94286 0 30 oct - 0:07 /usr/lpp/X11/bin/X -D
/usr/lib/X11//rgb -T -force :0 -auth /var/dt/A:0-Z-3eUa
root 110732 1 0 30 oct - 0:00 /usr/lib/errdemon
root 122960 94286 0 30 oct - 0:00 dtlogin <:0> -daemon
root 127056 180362 0 30 oct - 0:00 /usr/sbin/rsct/bin/IBM.AuditRMd
root 131256 180362 0 30 oct - 0:00 /usr/sbin/inetd
root 135304 1 0 30 oct - 0:00 /usr/dt/bin/ttsession -s
root 168018 1 0 30 oct - 0:00 /usr/ccs/bin/shlap64
root 180362 1 0 30 oct - 0:00 /usr/sbin/srcmstr
root 188606 180362 0 30 oct - 0:00 /usr/sbin/rpc.lockd -d 0
root 192660 180362 0 30 oct - 0:00 /usr/sbin/portmap
root 196710 180362 0 30 oct - 0:00 /usr/sbin/hostmibd
root 200810 180362 0 30 oct - 0:00 /usr/sbin/snmpd
root 204904 180362 0 30 oct - 0:00 /usr/sbin/snmpmibd
root 209002 180362 0 30 oct - 0:00 /usr/sbin/aixmibd
root 213104 1 0 30 oct - 0:00 /usr/sbin/cron daemon 217202 180362 0 30
oct - 0:00 /usr/sbin/rpc.statd -d 0 -t 50
root 221292 180362 0 30 oct - 0:00 /usr/sbin/syslogd
root 225390 180362 0 30 oct - 0:00 sendmail: connexions acceptes
root 229524 180362 0 30 oct - 0:00 /usr/sbin/writesrv
root 233604 180362 0 30 oct - 0:00 /usr/sbin/biod 6
root 241868 180362 0 30 oct - 0:00 /usr/sbin/qdaemon
root 245920 180362 0 30 oct - 0:00 /usr/sbin/muxatmd
root 254088 1 0 30 oct - 0:28 /usr/bin/xmwlm -L
root 258226 180362 0 30 oct - 0:00 /usr/sbin/rsct/bin/IBM.ERrmd
root 262362 1 0 30 oct - 0:00 /usr/sbin/uprintfd
root 266416 1 0 30 oct lft0 0:00 /usr/sbin/getty /dev/console
root 270570 102596 0 30 oct - 0:00 dtfile
root 274594 131256 0 30 oct - 0:00 rpc.ttdbserver 100083 1
root 278688 282782 0 30 oct - 0:00 /usr/dt/bin/dtexec -open 0 -ttprocid
2.179rxl 01 135304 1342177279 1 1 0 192.168.4.44 4_102_1
/usr/dt/bin/dtterm
root 282782 102596 0 30 oct - 0:08 dtwm
root 286874 278688 0 30 oct - 0:07 /usr/dt/bin/dtterm
root 290968 180362 0 30 oct - 0:00 /usr/sbin/rsct/bin/IBM.ServiceRMd
root 295100 180362 0 30 oct - 0:01 /usr/sbin/rsct/bin/IBM.CSMAgentRMd
root 299172 270570 0 30 oct - 0:00 dtfile informix 303330 376850 0 30
oct pts/0 0:00 -ksh
root 307204 360522 0 19:16:38 pts/2 0:00 -ksh
root 311470 450628 0 16:52:20 - 0:00 /usr/dt/bin/dtscreen
root 323820 270570 0 30 oct - 0:00 /usr/dt/bin/dtexec -open 0 -ttprocid
3.179rxl 01 135304 1342177279 1 1 0 192.168.4.44 4_102_1
/usr/dt/bin/dtterm
root 327918 446618 0 19:54:43 pts/5 0:00 -ksh informix 331962 364748 0
30 oct pts/3 0:00 -ksh
root 336046 368824 0 30 oct pts/4 0:00 /usr/bin/ksh
root 360522 131256 0 19:16:38 - 0:00 telnetd -a
root 364748 385254 0 30 oct pts/3 0:00 /usr/bin/ksh
root 368824 393446 0 30 oct - 0:00 /usr/dt/bin/dtterm
root 376850 286874 0 30 oct pts/0 0:00 /usr/bin/ksh
root 385254 323820 0 30 oct - 0:00 /usr/dt/bin/dtterm
root 389336 413732 0 31 oct - 0:00 dtpad
root 393446 270570 0 30 oct - 0:00 /usr/dt/bin/dtexec -open 0 -ttprocid
3.179rxl 01 135304 1342177279 1 1 0 192.168.4.44 4_110_1
/usr/dt/bin/dtterm
root 413732 135304 0 31 oct - 0:00 /bin/bsh /bin/bsh /bin/bsh
root 446618 131256 0 19:54:43 - 0:00 telnetd -a
root 450628 102596 0 16:52:20 - 0:00 /usr/dt/bin/dtexec -open 0
-ttprocid 1.179rxl 01 135304 1342177279 1 1 0 192.168.4.44 4_996_1
/usr/dt/bin/dtscreen -mode blank
root 454894 327918 0 16:53:13 pts/5 0:00 ps -ef
=================================== env
========================================================================
==========
_=/usr/bin/env@
On 01/11/2007, YVES VALLET <yvallet@ilta.fr> wrote:
> Server : IBM P520 64 bits, AIX 5.3.0.0
>
> IDS V10 version 10.00.FC6
>
> Problem :
>
> 1) We do a complete backup level0 with
> ontape -s -L 0 > backup_L0>
> At this time, database is OK , oninit -v shows all correct
>
> 2) onmode -ky
> 3) cat backup_L0 | ontape -p
> 4) onmode -ky
>
> 5) oninit -v results on :
>
> ================ result of oninit -v
> Checking group membership to determine server run mode...succeeded
> Reading configuration file '/u/informix/etc/onconfig.std'...succeeded
> Creating /INFORMIXTMP/.infxdirs...succeeded
> Creating infos file "/u/informix/etc/.infos.agaps_ids"...succeeded
> Linking conf file "/u/informix/etc/.conf.agaps_ids"...succeeded
> Writing to infos file...succeeded
> Checking config parameters...succeeded
> Allocating and attaching to shared memory...succeeded
> Creating resident pool 2480 kbytes...succeeded
> Allocating 20016 kbytes for buffer pool of 4K page size...succeeded
> Initializing rhead structure...succeeded
> Initializing ASF...succeeded
> Initializing Dictionary Cache and SPL Routine Cache...succeeded
> Bringing up ADM VP...succeeded
> Creating VP classes...succeeded
> Onlining 0 additional cpu vps...succeeded
> Onlining 2 IO vps...succeeded
> Initialization of Encryption...succeeded
> Forking main_loop thread...succeeded
> Initializing DR structures...succeeded
> Forking 1 'ipcshm' listener threads...succeeded
> Forking 1 'soctcp' listener threads...succeeded
> Starting tracing...succeeded
> Initializing 1 flushers...succeeded
> Initializing log/checkpoint information...succeeded
> Opening primary chunks...succeeded
> Opening mirror chunks...succeeded
> Initializing dbspaces...succeeded
> Validating chunks...succeeded
> Initialize Async Log Flusher...succeeded
> Forking btree cleaner...succeeded
> Initializing DBSPACETEMP list...succeeded
> Checking database partition index...FAILED
>
> oninit : Fatal error in shared memory initialization
> ================================================
>
> And we can no longer use the database !
>
> We try the same restore many times, with different files Backup_level0 ,
> on a dataspace just cleared with oninit -i
> and have always the same problem.
>
> If we reload the database with DBIMPORT , all is OK
> the problem is with ontape.
< MUCH SNIPPED >
I have seen this issue (admittedly ontape -r on IDS9) when onmode -m
is not run following the restore. At the end of the restore the server
is left in a quiescent/single user mode and needs to be brought fully
on line before a shutdown else it gets awfully muddled and throws this
error.
Keith
Related threads
- IDS 10 table-level restore
- Informix Development Webinar December 11, 2007
- ontape -p/r with changed ROOTPATH
- Migrate from HP PA-RISC to HP ITANIUM by ontape