logical restore

logical restore

Post by Aszalós Gy?rg » Sat, 25 Mar 2000 04:00:00



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 Complet
e." "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:
                Gy* Aszalos

 
 
 

1. External restore plus ON-Bar Logical restore

Does anyone have experience of performing a physical restore, external to
Informix, then using ON-Bar to perform the logical restore to bring the
Instance current?

Also can this be performes on a machine (identical configuration) other than
the one from which the data was copied and the logical logs were created and
backed up on? (ON-Bar)

Thanks in advance
Murray Wood

2. Question about archive log mode

3. Problem in logical restore with ontape -r -D

4. Stopping data entry

5. logical restore - end log marked as end log ?

6. Network X Communications Processors

7. onbar logical restore with Omniback

8. VFP Utility CD-ROM / Selecting printers in VFP

9. Reg,Ontape logical restore...Very urgent....

10. Logical Restore

11. Onbar - suspend the logical restore?

12. Logical restore problem on ODS 7.23 (NT)

13. Logical Restores