Re: Onbar and large databases

Jeffrey E. Screws wrote: > > I have a system that I inherited that has a 200gigabyte Informix > database. I need to come up with a more reliable backup procedure. > Currently we use a Spectralogics 10000 tape jukebox, with its > accompanied software "Alexandria". The currect backup process does a > RPF (?? I think this is right) backup of the raw logical volumes (HP-UX > lvm). This requires a full recovery of the entire database if a single > disk fails. It also takes 15 hours with the database offline. If you use onbar you can do your backups online. Onbar offers the possibility to do a parallel backup of your dbspaces: onbar -bThis does a Level 0 backup. First rootdbs and dbspaces containing physical and logical log are backed up. Then onbar starts to do a parallel backup of your dbspaces. > > I am fairly new to the Informix arena, but I had read a little about > Onbar. Is it true that Informix only recommends Onbar for databases of > 10gb or less? No, Informix says that if your database is 10GB or less you should use ontape, because there is no advantage in using onbar. If your database is greater then 10GB there is a markable increase in performance because of the possibilty of parallelism. > > I need to improve the speed and reliability of the backup for this > database. Any suggestions or ideas would be greatly appreciated. Use onbar. If you need more detailed information don't hesitate to email. Martina Lang