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.

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.c om...
> 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.c om...
> "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

> gee, I can post!!! :-)


> "Abanero" <abanero@supereva.it> wrote in message
> news:ad9fb198.0405202354.554fe1b4@posting.google.c om...
> > "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.
>
>