Re: Backup & Restore

In article <35BCD2D7.22658C80@sterlingdi.com>, morrisma@sterlingdi.com 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?) > ontape -s (archive level 0 backup, no logs)You cannot perform a backup when server is offline: /opt/informix:->ontape -s Server is in an incompatible state or user authentication failed. Program over. > drop a user table to drop the table, the server would have to be on line at some point. > ontape -r you can restore on or offline. if restoring offline, you're doing a full restore, including critical dbspaces, and no variations to onconfig or chunks allowed. One question -- why are you archving, then turning around to restore? Is this a test? > > 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. > We rebooted the Sun server several times to no avail each time the boot > process which had previously restarted informix and the user's app, > failed to initialize shared memory. It's critical to bring the instance up to online mode after restoring, so chunks are marked with consistency -- you will encounter problems with the restore if you do not bring the instance into online mode after the restore (like trying to bounce it, bring it down, then back up again, or bounce the whole box). > > What have we done wrong ? > We never even took the tape out of the drive between backup & restore. > What can we do (short of reloading informix) to fix this ? check your online.log for errors. try the restore again -- wait for queiscent mode, then bring online using onmode -my. also, if you don't restore logical logs (assuming you are using them) your chunks will not come up, will remain inconsistent. Informix has to mark them as online. > > TIA > --------------------------------------------------- > Mike Morris Sterling Diagnostic Imaging > Roads go ever ever on... morrisma@sterlingdi.com > --------------------------------------------------- > > -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum