Re: Backup & Restore

Mike Morris wrote: > > We have a new informix database based application and we were following > the vendor's backup and restore procedures (as best we could) and we > have run into a few problems. > > First, what we did: > onmode -k (offline?) I don't see any need to do this - ontape is designed to do full instance backups on the fly. > ontape -s (archive level 0 backup, no logs)> drop a user table Don't see the need for this either.... > ontape -r should do a full restore of the instance, looks good. > > The results: > Tape lights flashed and data seemed to go both ways. > Once the restore completed, we tried to do an onmode -m with no luck. I wouldn't bother with the shutdown / restart sequence, just ontape -s -L 0 # to archive ontape -r # restore.... Simplify, Simplify.... Snip.... -- Greg Moye The above are my opinions only.