dbTalk Databases Forums  

RE: Question about ontape

comp.databases.informix comp.databases.informix


Discuss RE: Question about ontape in the comp.databases.informix forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Diego Morales
 
Posts: n/a

Default RE: Question about ontape - 08-26-2003 , 08:18 AM








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 (AT) comcast (DOT) net]
Enviado el: martes 26 de agosto de 2003 14:44
Para: dmorales (AT) districenter (DOT) 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 (AT) districenter (DOT) es>
To: <informix-list (AT) iiug (DOT) org>
Sent: Tuesday, August 26, 2003 07:03
Subject: Question about ontape


Quote:
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


Reply With Quote
  #2  
Old   
Simmons, Keith
 
Posts: n/a

Default RE: Question about ontape - 08-26-2003 , 09:24 AM







Diego

That is correct, you can only archive the entire instance (all databases).
For several different reasons (not the least the fact you can back up the
live separate to the test) I would recommend you create another (small)
instance and move your test database into this.

keith

-> -----Original Message-----
-> From: Diego Morales [mailto:dmorales (AT) districenter (DOT) es]
-> Sent: Tuesday, August 26, 2003 12:03 PM
-> To: informix-list (AT) iiug (DOT) org
-> 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
->

************************************************** ********************************
This message is sent in strict confidence for the addressee only. It may
contain legally privileged information. The contents are not to be disclosed
to anyone other than the addressee. Unauthorised recipients are requested
to preserve this confidentiality and to advise the sender immediately of any
error in transmission.
This footnote also confirms that this email message has been swept for the
presence of computer viruses, however we cannot guarantee that this message
is free from such problems.
************************************************** ********************************
sending to informix-list

Reply With Quote
  #3  
Old   
Madison Pruet
 
Posts: n/a

Default Re: Question about ontape - 08-26-2003 , 02:30 PM



Diego,

Maybe you should consider making the test database into a second instance.


"Diego Morales" <dmorales (AT) districenter (DOT) es> wrote

Quote:

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



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.