Question:
Hi,
We are doing a DB copy from PRO system to QAS system following SAP note 173970 and we are currently in point 6. Importing the level 0 ackup into the target system.
The backups are doing with On-Archive and following SAP note 46468 to restore it according point FULL SYSTEM-COLD RESTORE IF YOU USE On-ARCHIVE pg4.
The DB and logical logs are in the same volume so we answering 'N' to the last questions:
Does this saveset continue on another volume? (Y/N) N
Do you have a level 1 archive to retrieve? (Y/N) N
So, the restore finished OK!
The onlineINFORMIXlog shows that the restore finished OK!:
Tue Nov 12 10:17:24 2002
10:17:24 Event alarms enabled. ALARMPROG
= '/informix/QAS/etc/logevent.qas'
10:17:30 DR: DRAUTO is 0 (Off)
10:17:30 AIX MP latch code enabled
10:17:30 Requested shared memory segment size rounded from 692KB to 704 KB
10:17:30 Informix Dynamic Server Version 7.30.UC7XK Software Serial Number AAB#J996970
10:17:31 WARNING! LTXHWM (70) and/or LTXEHWM (80) config parameters
10:17:31 Process exited with return code 127: /bin/sh /bin/sh -c /infor
mix/QAS/etc/logevent.qas 3 7 "Dynamic Server Initialization failure." "W
ARNING! LTXHWM (70) and/
10:17:32 Informix Dynamic Server Initialized -- Shared Memory Initializ
ed.
10:17:32 Dataskip is now OFF for all dbspaces
10:17:32Recovery Mode
10:17:34 Physical Restore of rootdbs, psapuser1, logdbs, psapbtab, psap
stab, psapprot, psapcosb, psapddic, physdbs, psapclu, psappool, psapsour
ce, psapdocu, psapload, psapes46b, psapel46b started.
10:18:35 Checkpoint Completed: duration was 1 seconds.
10:18:59 Checkpoint Completed: duration was 0 seconds.
10:19:00 Checkpoint Completed: duration was 1 seconds.
18:17:48 Checkpoint Completed: duration was 0 seconds.
19:19:41 Checkpoint Completed: duration was 0 seconds.
19:21:18 Checkpoint Completed: duration was 1 seconds.
20:41:56 Checkpoint Completed: duration was 1 seconds.
20:46:59 Checkpoint Completed: duration was 0 seconds.
20:46:59 Checkpoint Completed: duration was 0 seconds.
21:24:55 Checkpoint Completed: duration was 1 seconds.
21:44:28 Checkpoint Completed: duration was 0 seconds.
21:45:00 Checkpoint Completed: duration was 0 seconds.
21:45:05 Checkpoint Completed: duration was 0 seconds.
21:45:06 Checkpoint Completed: duration was 0 seconds.
22:21:48 Checkpoint Completed: duration was 0 seconds.
22:32:50 Checkpoint Completed: duration was 0 seconds.
22:32:53 Physical Restore of rootdbs, psapuser1, logdbs, psapbtab, psap
stab, psapprot, psapcosb, psapddic, physdbs, psapclu, psappool, psapsour
ce, psapdocu, psapload, psapes46b, psapel46b Completed.
22:32:53 Checkpoint Completed: duration was 0 seconds.
The problem is that INFORMIX on NOT ONLINE!!
INFORMIX is on FAST-RECOVERY mode since the restore finished!!
command 'onstat -' shows the next:
ZAPATA01:informix 2> ps -ef|grep informix
informix 9182 15222 0 Nov 12 0 0:00 -csh
informix 14982 16072 0 Nov 12 - 0:16 /informix/QAS/bin/oninit -r
informix 15740 16072 0 Nov 12 - 0:03 /informix/QAS/bin/oninit -r
informix 16072 1 0 Nov 12 - 110:09 /informix/QAS/bin/oninit -r
informix 17064 16072 0 Nov 12 - 28:52 /informix/QAS/bin/oninit -r
informix 17294 16072 0 Nov 12 - 9:45 /informix/QAS/bin/oninit -r
informix 17548 16072 0 Nov 12 - 0:02 /informix/QAS/bin/oninit -r
informix 17806 160720 Nov 12 - 0:02 /informix/QAS/bin/oninit -r
informix 18060 16072 0 Nov 12 - 0:00 /informix/QAS/bin/oninit -r
informix 18318 16072 0 Nov 12 - 0:03 /informix/QAS/bin/oninit -r
informix 18576 16072 0 Nov 12 - 0:17 /informix/QAS/bin/oninit -r
informix 18840 16072 0 Nov 12 - 0:03 /informix/QAS/bin/oninit -r
informix 19096 17294 0 Nov 12 - 0:03 /informix/QAS/bin/oninit -r
informix 19574 15528 1 10:29:32 pts/0 0:00 -csh
informix 20458 19574 10 10:29:41 pts/0 0:00 ps -ef
informix 22002 19574 2 10:29:41 pts/0 0:00 grep informix
ZAPATA01:informix 3> onstat -
Informix Dynamic Server Version 7.30.UC7XK -- Fast Recovery (CKPT REQ) -
- Up 1 days 00:12:24 -- 1482656 kbytes
Blocked:CKPT
ZAPATA01:informix 4>
SO, what can or what do I have to put INFORMIX in On-Line mode??,
to continue with the procceses of renaming DB according again to SAP Not
e 173970.
Thanks in advance and wait your notes or help soon!!!
ERIC
Answer:
pls. check if the logdbs is okay ... there seems to be a problem with logdbs/logical logs ... (verify the dbspace and if it is initial, also check the disk integrity) ....
we were able to use SAP Note 173970 several time with no problems ... (re: problems that were encountered were just informix related problems ... backup and recovery issues)
regards
Answer:
Hi bubu,
thanks for your comments.
I check the logdbs and it's OK, but the problem maybe is in other way.
This could helps you!
The PRO backup was made 'on-line', so I think this is the rason that INF
ORMIX is in FAST-RECOVERY mode before the restore. Am I right??
So, can I use 'oninit' directly to put INFORMIX 'on-line'?
I mean, I think that the DB is waiting for a CHECK POINT as it shows with 'onstat -' command.
So, I stopped the DB with "onmode -ky" and it stopped without errors as
online.log shows.
Then I try to put INFORMIX 'on-line' with "oninit" and it failed trying
to create the shared memory!!
I send you the last lines in online.log:
Wed Nov 13 15:11:38 2002
15:11:38 Informix Dynamic Server Stopped.
Wed Nov 13 15:14:19 2002
15:14:19 Event alarms enabled. ALARMPROG = '/informix/QAS/etc/logevent.qas'
15:14:24 DR: DRAUTO is 0 (Off)
15:14:24 AIX MP latch code enabled
15:14:24 Requested shared memory segment size rounded from 692KB to 704 KB
15:14:25 Informix Dynamic Server Version 7.30.UC7XK Software Serial Number AAB#J996970
15:14:25 WARNING! LTXHWM (70) and/or LTXEHWM (80) config parameters exceed recommended values of 50 and 60. This may
15:14:25 Process exited with return code 127: /bin/sh /bin/sh -c /infor
mix/QAS/etc/logevent.qas 3 7 "Dynamic Server Initialization failure." "W
ARNING! LTXHWM (70) and/
15:14:25 Assert Failed: chunk failed sanity check
15:14:25 Informix Dynamic Server Version 7.30.UC7XK
15:14:25 Who: Session(1, informix@ZAPATA01, 0, 0)
Thread(7, main_loop(), 0, 1)
File: rspartn.c Line: 6890
15:14:25 Results: Chunk 4 is being taken OFFLINE.
15:14:25 Action: Restore chunk from archive.
15:14:26 See Also: /tmp/af.7c0b0
15:14:26 Process exited with return code 127: /bin/sh /bin/sh -c /infor
mix/QAS/etc/logevent.qas 3 4 "Chunk is off-line, mirror is active: 53693
3320." "chunk failed san
15:14:27 I/O error, Primary Chunk '/informix/PRO/sapdata/physdev04/data16' -- Offline (sanity)
15:14:27 Assert Failed: chunk failed sanity check
15:14:27 Informix Dynamic Server Version 7.30.UC7XK
15:14:27 Who: Session(1, informix@ZAPATA01, 0, 0)
Thread(7, main_loop(), 0, 1) File: rspartn.c Line: 6890
15:14:27 Results: Chunk 5 is being taken OFFLINE.
15:14:27 Action: Restore chunk from archive.
15:14:27 Process exited with return code 127: /bin/sh /bin/sh -c /infor
mix/QAS/etc/logevent.qas 3 4 "Chunk is off-line, mirror is active: 53693
3232." "I/O error, Prima
15:14:29 See Also: /tmp/af.7c0b0
15:14:29 Process exited with return code 127: /bin/sh /bin/sh -c /infor
mix/QAS/etc/logevent.qas 3 4 "Chunk is off-line, mirror is active: 53693
3320." "chunk failed san
15:14:29 I/O error, Primary Chunk '/informix/PRO/sapdata/physdev05/data05' -- Offline(sanity)
15:14:29 Process exited with return code 127: /bin/sh /bin/sh -c /infor
mix/QAS/etc/logevent.qas 3 4 "Chunk is off-line, mirror is active: 53693
3232." "I/O error, Prima
15:14:29 Assert Failed: chunk failed sanity check
15:14:29 Informix Dynamic Server Version 7.30.UC7XK
15:14:29 Who: Session(1, informix@ZAPATA01, 0, 0)
Thread(7, main_loop(), 0, 1)
File: rspartn.c Line: 6890
15:14:29 Results: Chunk 14 is being taken OFFLINE.
15:14:29 Action: Restore chunk from archive.
15:14:31 See Also: /tmp/af.7c0b0
15:14:31 Process exited with return code 127: /bin/sh /bin/sh -c /infor
mix/QAS/etc/logevent.qas 3 4 "Chunk is off-line, mirror is active: 53693
3320." "chunk failed san
15:14:31 I/O error, Primary Chunk '/informix/PRO/sapdata/physdev03/data15' -- Offline (sanity)
15:14:31 Process exited with return code 127: /bin/sh /bin/sh -c /infor
mix/QAS/etc/logevent.qas 3 4 "Chunk is off-line, mirror is active: 53693
3232." "I/O error, Prima
15:14:34 Informix Dynamic Server Initialized -- Shared Memory Initializ
ed.
15:14:34 Warning: Invalid dbspace 'tmpdbs1' listed in DBSPACETEMP.
15:14:34 Warning: Invalid dbspace 'tmpdbs2' listed in DBSPACETEMP.
15:14:34 Warning: Invalid dbspace 'tmpdbs3' listed in DBSPACETEMP.
15:14:34 Physical Recovery Started.
15:14:34 Physical RecoveryComplete: 0 Pages Restored.
15:14:34 Logical Recovery Started.
15:14:37 Logical Recovery Complete.
0 Committed, 1 Rolled Back, 0 Open, 0 Bad Locks
So, according note 173970 after succesfully restore ofthe DB backup, it'
s necesarry that DB is 'on-line'??
I mean, at this moment DB is named PRO instead QAS.
So, Can I continue with the DB rename acoording note 173070 points 7,8 and 9??
Thanks for your hekp...
ERIC
FYI: I installed a complete standard R/3 QAS system and then just restore the PRO backup over it.
Answer:
15:14:25 Assert Failed: chunk failed sanity check
Hi esalazar,
It seems you have several dbspaces missing ...
15:14:24 Requested shared memory segment size rounded from 692KB to 704 KB
15:14:25 Informix Dynamic Server Version 7.30.UC7XK Software Serial Number AAB#J996970
15:14:25 WARNING! LTXHWM (70) and/or LTXEHWM (80) config parameters exceed recommended values of 50 and 60. This may
This is for information purposes only (You can view the same thing in your QA) ....
15:14:34 Informix Dynamic Server Initialized -- Shared Memory Initializ
ed.
15:14:34 Warning: Invalid dbspace 'tmpdbs1' listed in DBSPACETEMP.
15:14:34 Warning: Invalid dbspace 'tmpdbs2' listed in DBSPACETEMP.
15:14:34 Warning: Invalid dbspace 'tmpdbs3' listed in DBSPACETEMP.
This tells us the status of the shared memory (memory was successfully allocated) and tempdbs (though tempdbs is not important at this point, you may want to check if its created/copied successfully) ...
Resolution: As seen in the logs, the best way to resolve this issue is to verify '/informix/PRO/sapdata/physdev04/data16' , '/informix/PRO/sapdata/physdev04/data05' and '/informix/PRO/sapdata/physdev04/data15' . Though mirroring was implemented, Informix is having some problems with your mirror chunks when trying to perform a fast recovery ...
Hope this helps[/quote]