RE: Question about ontape
Posted in 2003
Topics: High Availability & Replication, Backup & Restore, Storage & Space Management, Logging & Checkpoints
Backup dbspaces it's ok for me because I want to backup all dbspaces except
"testdbs". Anyway I don't know how do it... any help please???
-----Mensaje original-----
De: Mark Denham [mailto:mkdenham@comcast.net]
Enviado el: martes 26 de agosto de 2003 14:44
Para: dmorales@districenter.es
CC: ilist
Asunto: Re: Question about ontape
No. ontape and onbar care about dbspaces not databases.
If your databases reside in separate dbspaces in the instance then you could
backup those spaces, logically grouped but I have never found this to be
particularly useful myself.
Mark
----- Original Message -----
From: "Diego Morales" <dmorales@districenter.es>
To: <informix-list@iiug.org>
Sent: Tuesday, August 26, 2003 07:03
Subject: Question about ontape
>
> Is possible to do an "ontape" only on a select databases????? I don't want
> to backup the test-database.
>
> Checking the parameters seems that it is not possible... can anyone
confirm
> this or help me???
>
> TIA.
>
> ontape
> usage:
> { -a |
> -c |
> -l |
> -p |
> -r [-D DBspace_list] |
> -s [-L archive_level] [-A database_list] [-B database_list]
> [-N database_list] [-U database_list] }>
> -a Automatic backup of logical logs
> -c Continuous backup of logical logs
> -l Logical restore
> -p Physical restore for HDR
> -r Full restore DBspaces/BLOBspaces as listed
> -s Archive full system
> -A set the following database(s) to ansi logging
> -B set the following database(s) to buffered logging
> -N set the following database(s) to no logging
> -U set the following database(s) to unbuffered logging
>
>
> sending to informix-list
sending to informix-list
You cannot restrict what dbspaces ontape backs up ... it backs up the entire
instance. However, on the restore, you can specify what dbspaces to
restore.
"Diego Morales" <dmorales@districenter.es> wrote in message
news:bifo2f$kjt$1@terabinaries.xmission.com...
>
>
> Backup dbspaces it's ok for me because I want to backup all dbspaces
except
> "testdbs". Anyway I don't know how do it... any help please???
>
> -----Mensaje original-----
> De: Mark Denham [mailto:mkdenham@comcast.net]
> Enviado el: martes 26 de agosto de 2003 14:44
> Para: dmorales@districenter.es
> CC: ilist
> Asunto: Re: Question about ontape
>
>
> No. ontape and onbar care about dbspaces not databases.
>
> If your databases reside in separate dbspaces in the instance then you
could
> backup those spaces, logically grouped but I have never found this to be
> particularly useful myself.
>
> Mark
>
> ----- Original Message -----
> From: "Diego Morales" <dmorales@districenter.es>
> To: <informix-list@iiug.org>
> Sent: Tuesday, August 26, 2003 07:03
> Subject: Question about ontape
>
>
> >
> > Is possible to do an "ontape" only on a select databases????? I don't
want
> > to backup the test-database.
> >
> > Checking the parameters seems that it is not possible... can anyone
> confirm
> > this or help me???
> >
> > TIA.
> >
> > ontape
> > usage:
> > { -a |
> > -c |
> > -l |
> > -p |
> > -r [-D DBspace_list] |
> > -s [-L archive_level] [-A database_list] [-B database_list]
> > [-N database_list] [-U database_list] }> >
> > -a Automatic backup of logical logs
> > -c Continuous backup of logical logs
> > -l Logical restore
> > -p Physical restore for HDR
> > -r Full restore DBspaces/BLOBspaces as listed
> > -s Archive full system
> > -A set the following database(s) to ansi logging
> > -B set the following database(s) to buffered logging
> > -N set the following database(s) to no logging
> > -U set the following database(s) to unbuffered logging
> >
> >
> > sending to informix-list
>
> sending to informix-list