ontape Info

Hi All, i'm not a DBA, my question is very simply. I have executed the following command: ontape -s -L 0.

You've backed up all databases in ONE instance - the instance defined by the INFORMIXSERVER environment variable of the session you used to execute the ontape utility. "Abanero" <abanero@supereva.it> wrote in message news:ad9fb198.0405200900.57abaa48@posting.google.com... > Hi All, > > i'm not a DBA, my question is very simply. I have executed the following command: > > ontape -s -L 0.> > From the documentation this command backup all system. > what's is mean? i have backuped all informations stored in Informix? each istances? > > > > Configuration of Tape Parameters: > > Press ESC to change tape parameters. > Press Interrupt to return to the Archive menu. > Press F2 or CTRL-F for field level help. > > > MODIFYING TAPE PARAMETERS > > > Tape Device [/dev/rmt/0 ] > > Block Size [ 16] Kbytes Tape Size [ 24000000] Kbytes > > Log Tape Device [/products/informix/ids.93/databases/devnull ] > > Block Size [ 16] Kbytes Tape Size [ 102400] Kbytes > > > Thanks in advance > Abanero.

"Neil Truby" <neil.truby@ardenta.com> wrote in message news:<2h47atF8lir0U1@uni-berlin.de>... > You've backed up all databases in ONE instance - the instance defined by the > INFORMIXSERVER environment variable of the session you used to execute the > ontape utility. Thanks to all, just to understand, my informix database has 4 instances, with command: ontape -s -L 0. I have backed up all databases in ONE nistance. This means if I restore database from Tape I lose all instances and only one istance are restore? Thanks Abanero

"Abanero" <abanero@supereva.it> wrote in message news:ad9fb198.0405202354.554fe1b4@posting.google.com... > "Neil Truby" <neil.truby@ardenta.com> wrote in message news:<2h47atF8lir0U1@uni-berlin.de>... > > You've backed up all databases in ONE instance - the instance defined by the > > INFORMIXSERVER environment variable of the session you used to execute the > > ontape utility. > > Thanks to all, just to understand, my informix database has 4 > instances, with command: > > ontape -s -L 0.> > I have backed up all databases in ONE nistance. This means if I > restore database from Tape I lose all instances and only one istance > are restore? No. You have backed up one instance. If you restore from that tape you will restore just that instance. The others will not be affected. In order to back up the other three instances, or restore them, you would need to set the INFORMIXSERVER environment variable to some other appropriate value.

On Fri, 21 May 2004 03:54:57 -0400, Abanero wrote: > "Neil Truby" <neil.truby@ardenta.com> wrote in message > news:<2h47atF8lir0U1@uni-berlin.de>... >> You've backed up all databases in ONE instance - the instance defined by >> the INFORMIXSERVER environment variable of the session you used to execute >> the ontape utility. > > Thanks to all, just to understand, my informix database has 4 instances, > with command: > > ontape -s -L 0.> > I have backed up all databases in ONE nistance. This means if I restore > database from Tape I lose all instances and only one istance are restore? Sounds like a terminology problem here. In Informix parlance, an 'instance' is a database server, all of the oninit processes connected to the same shared memory segments (see the output of onstat -g glo). An IDS instance can and usually does manage multiple databases. Access to one instance or another is controlled by the environment variables INFORMIXSERVER (and for server and DBA processes also ONCONFIG). There are other database servers (Oracle comes to mind) that only manage a single database (perhaps with multiple schemas) and since there is a correspondence between server instance and database many sloppy spoken Oracle folk refer to a database as in 'instance'. When you make an archive using ontape or onbar in IDS this archives ALL databases managed by the single 'instance' (in Informix terms) and restoring such an archive will restore ALL databases managed by that instance (ignoring single dbspace restores for the moment). If you have more than one 'instance' of the IDS server running (there will be multiple onconfig files with different DBSERVERNUM values set in each and the oninits that are running on the machine will not all be listed in any one onstat -g glo report if you really do have multiple instances). Hope this helps Art S. Kagel