RE: Is a physical only whole backup possible?

Onbar aways initiates a logical log backup at the end of a whole system (onbar -b -w) backup. However, you can perform a physical restore with "onbar -r -w -p". After the restore completes, the Informix instance will remain in "Fast Recovery" mode. If you do not intend to apply any logical logs, issue an "onmode -m" command. This command will compleete the restore operation and bring the instance into "On-Line" mode. However, this does not occur immediately. On our systems this switch to "On-Line" has taken up to 20 minutes. Meanwhile I have observed heavy I/O activity. -----Original Message----- From: aaronluz@my-deja.com To: informix-list@iiug.org Sent: 4/17/00 9:18 AM Subject: Is a physical only whole backup possible? I'm using IDS 7.31TC5 on Windows NT4. As an XBSA storage manager for ONBar, I'm using the included ISM 2.20. The Backup and Restore Guide states, The advantage of using a whole-system backup is that you can restore the storage spaces with or without the logical logs. Because the data in all storage spaces is consistent in a whole-system backup, you do not need to restore the logical logs to make the data consistent. Given that I can restore a system to a previous physical state using "onbar -r -p -w," is there a corresponding option to perform a physical only whole backup? I have tried "onbar -b -p -w," but ONBar only returns a command synopsis. A physical only whole backup is possible by running "onbar -b -w" while LTAPEDEV is set to NUL. However, the onbar process returns error 131. According to the Backup and Restore Guide this means "a failure occurred in the interface between ON-Bar and the database server." Is there a recommended way of performing a physical only whole backup using ONBar? When error 131 is returned from "onbar -b -w," is there a reliable method for determining if the physical portion of the backup was performed successfully? If possible, I would like a method that can be used within a Windows NT batch file. Sent via Deja.com http://www.deja.com/ Before you buy.