onbar restore trouble
Posted in 1997
I've very anonying problem with restoring Informix database. Following is
the Informix log, bar_act.log and daemon.log (/nsr/logs Legato Networker).
What I did is to have a daily full backup: one on 7/18 and two on 7/19.
I was having no problem at 7/19 to restore the 7/19 or 7/18's images, but
at 7/20 when I tried to restore 7/19 image, I get
"
DBspace logdbs not recovered from same archive backup as DBspace
rootdbs.
Cannot change to Quiescent Mode.
"
Any idea how it may go wrong? Thanks.
Chris
==================================
Sun Jul 20 10:47:06 1997
10:47:06 Event alarms enabled. ALARMPROG = '/usr/informix722/etc/log_full.sh'
10:47:08 DR: DRAUTO is 0 (Off)
10:47:08 AIX MP latch code enabled
10:47:08
10:47:08
10:47:09 INFORMIX-OnLine Initialized -- Shared Memory Initialized.
10:47:09 Dataskip is now OFF for all dbspaces
10:47:09 Recovery Mode
10:47:10 Physical Restore of rootdbs started.
10:47:11
10:47:12 Physical Restore of rootdbs Completed.
10:47:12 Checkpoint Completed: duration was 0 seconds.
10:47:12 Physical Restore of logdbs started.
10:47:13 Physical Restore of datadbs started.
10:47:57 Physical Restore of logdbs Completed.
10:47:57 Checkpoint Completed: duration was 0 seconds.
10:49:31 Physical Restore of datadbs Completed.
10:49:31 Checkpoint Completed: duration was 1 seconds.
10:49:31 Logical Recovery Started.
10:49:31 Checkpoint Completed: duration was 0 seconds.
10:49:31 Start Logical Recovery - Start Log 522, End Log ?
10:49:31 Starting Log Position - 522 0x4d1ac
10:49:53 DBspace logdbs not recovered from same archive backup as DBspace
rootdbs.
10:49:53 Cannot change to Quiescent Mode.
===========================================
1997-07-20 10:55:10 70126 59560 onbar -r -t 1997-07-19 23:59:00
1997-07-20 10:55:10 70126 59560 Successfully connected to Storage Manager.
1997-07-20 10:55:15 70126 59560 Begin salvage for log 522.
1997-07-20 10:55:28 70126 59560 Completed salvage of logical log 522.
1997-07-20 10:55:41 70126 59560 Successfully connected to Storage Manager.
1997-07-20 10:55:54 70126 59560 Begin cold level 0 restore rootdbs.
1997-07-20 10:56:13 70126 59560 Completed cold level 0 restore rootdbs.
1997-07-20 10:56:13 70966 70126 Process 70966 70126 successfully forked.
1997-07-20 10:56:13 48696 70126 Process 48696 70126 successfully forked.
1997-07-20 10:56:13 70966 70126 Successfully connected to Storage Manager.
1997-07-20 10:56:13 48696 70126 Successfully connected to Storage Manager.
1997-07-20 10:56:19 48696 70126 Begin cold level 0 restore datadbs.
1997-07-20 10:56:36 70966 70126 Begin cold level 0 restore logdbs.
1997-07-20 10:56:36 70966 70126 Completed cold level 0 restore logdbs.
1997-07-20 10:56:55 70966 70126 Process 70966 70126 completed.
1997-07-20 10:58:28 48696 70126 Completed cold level 0 restore datadbs.
1997-07-20 10:58:28 48696 70126 Process 48696 70126 completed.
1997-07-20 10:58:29 70126 59560 Successfully connected to Storage Manager.
1997-07-20 10:58:38 70126 59560 Begin restore logical log 522.
1997-07-20 10:58:38 70126 59560 Completed restore logical log 522.
1997-07-20 10:58:53 70126 59560 ON-Bar is waiting for the OnLine server to exit fast recovery mode.
1997-07-20 10:58:59 70126 59560 ON-Bar is waiting for the OnLine server to exit fast recovery mode.
1997-07-20 10:59:04 70126 59560 ON-Bar is waiting for the OnLine server to exit fast recovery mode.
1997-07-20 10:59:09 70126 59560 ON-Bar is waiting for the OnLine server to exit fast recovery mode.
1997-07-20 10:59:14 70126 59560 ON-Bar is waiting for the OnLine server to exit fast recovery mode.
1997-07-20 10:59:19 70126 59560 ON-Bar is waiting for the OnLine server to exit fast recovery mode.
1997-07-20 10:59:24 70126 59560 ON-Bar is waiting for the OnLine server to exit fast recovery mode.
1997-07-20 10:59:30 70126 59560 ON-Bar is waiting for the OnLine server to exit fast recovery mode.
1997-07-20 10:59:35 70126 59560 ON-Bar is waiting for the OnLine server to exit fast recovery mode.
1997-07-20 10:59:40 70126 59560 ON-Bar is waiting for the OnLine server to exit fast recovery mode.
1997-07-20 10:59:45 70126 59560 ON-Bar is waiting for the OnLine server to exit fast recovery mode.
1997-07-20 10:59:50 70126 59560 ON-Bar is waiting for the OnLine server to exit fast recovery mode.
1997-07-20 10:59:55 70126 59560 ON-Bar is waiting for the OnLine server to exit fast recovery mode.
1997-07-20 11:00:00 70126 59560 ON-Bar is waiting for the OnLine server to exit fast recovery mode.
1997-07-20 11:00:06 70126 59560 ON-Bar is waiting for the OnLine server to exit fast recovery mode.
1997-07-20 11:00:11 70126 59560 ON-Bar is waiting for the OnLine server to exit fast recovery mode.
1997-07-20 11:00:16 70126 59560 ON-Bar is waiting for the OnLine server to exit fast recovery mode.
1997-07-20 11:00:21 70126 59560 ON-Bar is waiting for the OnLine server to exit fast recovery mode.
1997-07-20 11:00:27 70126 59560 ON-Bar is waiting for the OnLine server to exit fast recovery mode.
1997-07-20 11:00:32 70126 59560 ON-Bar is waiting for the OnLine server to exit fast recovery mode.
1997-07-20 11:00:37 70126 59560 ON-Bar is waiting for the OnLine server to exit fast recovery mode.
1997-07-20 11:00:42 70126 59560 ON-Bar is waiting for the OnLine server to exit fast recovery mode.
1997-07-20 11:00:48 70126 59560 ON-Bar is waiting for the OnLine server to exit fast recovery mode.
1997-07-20 11:00:53 70126 59560 ON-Bar is waiting for the OnLine server to exit fast recovery mode.
1997-07-20 11:00:58 70126 59560 ON-Bar is waiting for the OnLine server to exit fast recovery mode.
1997-07-20 11:01:03 70126 59560 ON-Bar is waiting for the OnLine server to exit fast recovery mode.
1997-07-20 11:01:08 70126 59560 ON-Bar is waiting for the OnLine server to exit fast recovery mode.
1997-07-20 11:01:13 70126 59560 ON-Bar is waiting for the OnLine server to exit fast recovery mode.
1997-07-20 11:01:45 70126 59560 ERROR: Unable to open connection to server: could not fork server connection.
1997-07-20 11:01:45 70126 59560 SQL -25588 The appl process cannot connect to OnLine server prulifeulp.
1997-07-20 11:01:45 70126 59560 SQL -25588 The appl process cannot connect to OnLine server prulifeulp.
==========================================
7/20/97 10:55:14 nsrd: j30:INFORMIX:/prulifeulp saving to pool 'DBMILogs' (01000242)
7/20/97 10:55:16 nsrd: j30:INFORMIX:/prulifeulp done saving to pool 'DBMILogs' (01000242)
7/20/97 10:55:42 nsrd: media info event: 8mm tape 01000241 will be needed
7/20/97 10:55:49 nsrd: media event cleared: confirmed mount of 01000241 on /dev/rmt1.1
7/20/97 10:55:49 nsrd: j30:INFORMIX:/prulifeulp (7/19/97) starting read from 01000241 of 2.2 MB
7/20/97 10:56:13 nsrd: j30:INFORMIX:/prulifeulp (7/19/97) done reading 2.2 MB
7/20/97 10:56:14 nsrd: media info event: 8mm tape 01000241 will be needed
7/20/97 10:56:15 nsrd: media info event: 8mm tape 01000241 will be needed
7/20/97 10:56:18 nsrd: media event cleared: confirmed mount of 01000241 on /dev/rmt1.1
7/20/97 10:56:19 nsrd: j30:INFORMIX:/prulifeulp (7/19/97) starting read from 01000241 of 268 MB
7/20/97 10:56:19 nsrd: j30:INFORMIX:/prulifeulp (7/19/97) starting read