Re: Onbar Backup/Restore

In article <20010102222702.01189.00006988@ng-ch1.aol.com>, DIDAS <didas@aol.com> writes >we have decided to stop logical logs, putting LTAPEDEV to /dev/null >backups are good but restores fail. we do not want to use onbar -b -w option >due to single thread. pushing database to 6 drive tape library via Veritas >Datacenter. > >Any suggestions, Please reply >kwood@acs.roadway.com > >Thanks, Kelly What errors do you get with the restore? How exactly do you restore? -- David Williams

We checked with Informix and they stated "You CANNOT restore the database without some logs without the -w option. The bar_act.log just complained about not being able to retrieve log xxx for the storage mgr. INFX suggested to turn logging back on, get a few logs backed up to whatever then do a point in time restore. This failed to our goal! We backed up to say log 5, simulated log backups (onmode -l and onmode -c)On the restore it salvaged the current log say 20 and restored to that point. We then did onbar -b -L 0 (log 5) onmode -l/onmode -c (to log 20) onbar -r -p onbar -r -l -n 5It worked to our plan Any ideas for improvement? We would love to hear it! Thanks, Kelly

Hi DIDAS. I also did a similar experience. Plase try this following command. 1. onbar -b -L 0 2. onbar -r 3. onmode -m (please see following messages) Tue Dec 19 16:52:09 2000 16:52:09 Event alarms enabled. ALARMPROG = '/informix/IIF2000/9.21.UC1-1/etc/l og_full.sh' 16:52:09 Booting Language <c> from module <> 16:52:09 Loading Module <CNULL> 16:52:09 Booting Language <builtin> from module <> 16:52:09 Loading Module <BUILTINNULL> 16:52:14 Informix Dynamic Server 2000 Version 9.21.UC1 SoftwareSerial Numb er AAC#J902091 16:52:14 Informix Dynamic Server 2000 Initialized -- Shared MemoryInitialized. 16:52:14 Dataskip is now OFF for all dbspaces 16:52:14 Recovery Mode 16:52:15 Physical Restore of rootdbs started. 16:52:31 Dynamically allocated new virtual shared memory segment (size 8192KB) 16:52:31 Checkpoint Completed: duration was 0 seconds. 16:52:31 Checkpoint loguniq 4, logpos 0x2c1550 16:52:31 Physical Restore of rootdbs Completed. 16:52:31 Checkpoint Completed: duration was 0 seconds. 16:52:31 Checkpoint loguniq 4, logpos 0x2c1550 16:56:18 Physical Recovery Started. 16:56:18 Physical Recovery Complete: 0 Pages Restored. 16:56:18 Logical Recovery Started. 16:56:18 10 recovery worker threads will be started. 16:56:20 Logical Recovery Complete. 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks 16:56:21 Bringing system to On-Line Mode with no Logical Restore. 16:56:22 On-Line Mode In article <20010103220013.26764.00005632@ng-fi1.aol.com>, didas@aol.com (DIDAS) wrote: > We checked with Informix and they stated "You CANNOT restore the database > without some logs without the -w option. The bar_act.log just complained about > not being able to retrieve log xxx for the storage mgr. > INFX suggested to turn logging back on, get a few logs backed up to whatever > then do a point in time restore. > This failed to our goal! > We backed up to say log 5, simulated log backups (onmode -l and onmode -c)On> the restore it salvaged the current log say 20 and restored to that point. > > We then did onbar -b -L 0 (log 5) > onmode -l/onmode -c (to log 20) > onbar -r -p > onbar -r -l -n 5> It worked to our plan > > Any ideas for improvement? We would love to hear it! > > Thanks, Kelly > > Regards. -- Tsutomu Ogiwara From Japan. Sent via Deja.com http://www.deja.com/