logical restore
Posted in 2000
Hello,
we run Informix Dynamic Server Version 7.31.UC2AX4 on SINIX-Y 5.43.
Problem for normal logical restore
About one case
"Restore complete with Rollforward with local tapes". for SMP test
execution:
1.Login as 'smsadm1' and bring down the SMP processes.
2.Exit then login informix
3.type the follow commands:
3-1.onbar -l -c
3-2.onmode -ky
3-3.onbar -l -s
3-4.onbar -r
(Using onbar -r for the normal logical restore of th data.)
3-5.onmode -m
At step 3-4, we can sure that restore is failure and prove from log
file.
In bar_act.log I found the entry
XBSA Error (BSAGetObject): Backup object does not exist in
Storage Manager.
ERROR: Unable to open connection to server: could not fork
server connection.
Some details from bar_act.log:
2000-03-17 00:00:33 7192 7191 XBSA Error (BSACreateObject): A system error
occurred. Aborting XBSA session.
2000-03-17 10:54:35 28795 28794 /home1/informix/bin/onbar_d -b -L 0
2000-03-17 10:54:45 28795 28794 Begin level 0 backup rootdbs.
2000-03-17 10:54:45 28795 28794 Successfully connected to Storage Manager.
2000-03-17 10:54:49 28795 28794 Completed level 0 backup rootdbs.
2000-03-17 10:55:10 29005 28795 Process 29005 28795 successfully forked.
2000-03-17 10:55:10 29006 28795 Process 29006 28795 successfully forked.
2000-03-17 10:55:10 29008 28795 Process 29008 28795 successfully forked.
2000-03-17 10:55:10 29007 28795 Process 29007 28795 successfully forked.
2000-03-17 10:55:13 29005 28795 Begin level 0 backup blobdbs1.
2000-03-17 10:55:14 29005 28795 Successfully connected to Storage Manager.
2000-03-17 10:55:15 29008 28795 Begin level 0 backup scedbs.
2000-03-17 10:55:15 29007 28795 Begin level 0 backup pnpdbs.
2000-03-17 10:55:15 29007 28795 Successfully connected to Storage Manager.
2000-03-17 10:55:15 29008 28795 Successfully connected to Storage Manager.
2000-03-17 10:55:16 29007 28795 Completed level 0 backup pnpdbs.
2000-03-17 10:55:16 29005 28795 Completed level 0 backup blobdbs1.
2000-03-17 10:55:17 29008 28795 Completed level 0 backup scedbs.
2000-03-17 10:55:18 29006 28795 Begin level 0 backup blobdbs2.
2000-03-17 10:55:19 29006 28795 Successfully connected to Storage Manager.
2000-03-17 10:55:36 29007 28795 Process 29007 28795 completed.
2000-03-17 10:55:36 29058 28795 Process 29058 28795 successfully forked.
2000-03-17 10:55:37 29005 28795 Process 29005 28795 completed.
2000-03-17 10:55:37 29008 28795 Process 29008 28795 completed.
2000-03-17 10:55:37 29064 28795 Process 29064 28795 successfully forked.
2000-03-17 10:55:39 29058 28795 Begin level 0 backup stammdbs.
2000-03-17 10:55:39 29058 28795 Successfully connected to Storage Manager.
2000-03-17 10:55:41 29064 28795 Begin level 0 backup statdbs.
2000-03-17 10:55:41 29064 28795 Successfully connected to Storage Manager.
2000-03-17 10:55:52 29006 28795 Completed level 0 backup blobdbs2.
2000-03-17 10:55:53 29006 28795 Process 29006 28795 completed.
2000-03-17 10:55:58 29058 28795 Completed level 0 backup stammdbs.
2000-03-17 10:56:00 29064 28795 Completed level 0 backup statdbs.
2000-03-17 10:56:00 29058 28795 Process 29058 28795 completed.
2000-03-17 10:56:18 29064 28795 Process 29064 28795 completed.
2000-03-17 10:56:18 28795 28794 Begin backup logical log 157.
2000-03-17 10:56:18 28795 28794 Successfully connected to Storage Manager.
2000-03-17 10:56:40 28795 28794 Completed backup logical log 157.
2000-03-17 10:56:40 28795 28794 Begin backup logical log 158.
2000-03-17 10:56:43 29248 29247 /home1/informix/bin/onbar_d -l
2000-03-17 10:56:44 29248 29247 WARNING: A log backup is already running.
Can't start another.
2000-03-17 10:57:02 28795 28794 Completed backup logical log 158.
2000-03-17 11:03:14 3473 3472 /home1/informix/bin/onbar_d -l -c
2000-03-17 11:03:14 3473 3472 Begin backup logical log 159.
2000-03-17 11:03:14 3473 3472 Successfully connected to Storage Manager.
2000-03-17 11:03:38 3473 3472 Completed backup logical log 159.
2000-03-17 11:06:14 4486 4485 /home1/informix/bin/onbar_d -l -s
2000-03-17 11:06:14 4486 4485 Successfully connected to Storage Manager.
2000-03-17 11:06:19 4486 4485 Begin salvage for log 160.
2000-03-17 11:06:49 4486 4485 Completed salvage of logical log 160.
2000-03-17 11:09:03 5027 5026 /home1/informix/bin/onbar_d -r
2000-03-17 11:09:03 5027 5026 Successfully connected to Storage Manager.
2000-03-17 11:09:08 5027 5026 Begin salvage for log 160.
2000-03-17 11:09:40 5027 5026 Completed salvage of logical log 160.
2000-03-17 11:11:00 5027 5026 Successfully connected to Storage Manager.
2000-03-17 11:11:00 5027 5026 XBSA Error (BSAGetObject): Backup object
does not exist in Storage Manager.
2000-03-17 11:11:33 5027 5026 ERROR: Unable to open connection to server:
could not fork server connection.
2000-03-17 11:43:43 20302 20301 /home1/informix/bin/onbar_d -b -L 0
----------------------------------------------------------------------------
----------------------------------------------------------------------------
-------
Some details from online.log:
10:52:57 Checkpoint Completed: duration was 0 seconds.
10:54:45 Checkpoint Completed: duration was 0 seconds.
10:54:45 Level 0 Archive started on rootdbs
10:55:07 Archive on rootdbs Completed.
10:55:09 Checkpoint Completed: duration was 0 seconds.
10:55:13 Checkpoint Completed: duration was 0 seconds.
10:55:13 Level 0 Archive started on blobdbs1
10:55:15 Checkpoint Completed: duration was 0 seconds.
10:55:15 Level 0 Archive started on scedbs
10:55:15 Level 0 Archive started on pnpdbs
10:55:18 Level 0 Archive started on blobdbs2
10:55:36 Archive on pnpdbs Completed.
10:55:37 Archive on blobdbs1 Completed.
10:55:37 Archive on scedbs Completed.
10:55:39 Checkpoint Completed: duration was 0 seconds.
10:55:39 Level 0 Archive started on stammdbs
10:55:41 Checkpoint Completed: duration was 0 seconds.
10:55:41 Level 0 Archive started on statdbs
10:55:53 Archive on blobdbs2 Completed.
10:56:00 Archive on stammdbs Completed.
10:56:18 Archive on statdbs Completed.
10:56:18 Logical Log 157 - Backup Started
10:56:40 Logical Log 157 - Backup Completed
10:56:41 Logical Log 158 - Backup Started
10:56:43 Logical Log 158 Complete.
10:56:49 Process exited with return code 152: /bin/sh /bin/sh -c
/home1/informix/etc/log_full_smp.sh 2 23 "Logical Log 158 Complete." "Logical Log 158 Complete."
10:57:02 Logical Log 158 - Backup Completed
11:00:57 Checkpoint Completed: duration was 0 seconds.
11:03:20 Logical Log 159 - Backup Started
11:03:21 Logical Log 159 Complete.
11:03:38 Logical Log 159 - Backup Completed
11:04:45 Checkpoint Completed: duration was 0 seconds.
11:04:47 Informix Dynamic Server Stopped.
Fri Mar 17 11:25:34 2000
11:25:34 Event alarms enabled. ALARMPROG =
'/home1/informix/etc/log_full_smp.sh'
What is the problem? Could somebody help us?
Thanks:
Gyorgy Aszalos