ontape - how to bypass a database?

Hello, We would like to bypass the backup of a database (dbx) using ontape. Will the following work? If not, please advise. unix> ontape -N dbx -s -L 0 We are using 11.50.FC5 under Solaris. Thanks! Reyna _________________________________________________________ Reyna Sabina Phone: (305) 361-4324 NOAA/AOML/PHOD Fax: (305) 361-4392 4301 Rickenbacker Causeway Email: Reyna.Sabina@noaa.gov Miami, FL 33149-1087 "Things do not get better by being left alone." -Winston Churchill

I'm not sure that I understand the question. It looks like you are asking if you can backup the Informix server but not back up one of the databases it manages, namely the dbx database. Is that it? Then the answer is no and no. No, -N dbx will not do that and no there is no way that you can back up only certain databases and not others. The -N option to ontape just changes the logging status of the database(s) named so that they no longer support transactions and so do not log changes in the logical logs. Ontape and onbar back up the entire server (ok with onbar you have to option to back up only selected dbspaces). Even if you isolate the dbx database in dbspaces that you do not archive, you will have to recover those dbspaces if you should have to restore the server or they will be marked offline after the restore, so you will have to back up those dbspaces periodically anyway and if the dbx database is a logged database, then if the back ups of its dbspaces are very old, you will have to roll forward many many logical log back ups to successfully restore the server to a usable state. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Jun 16, 2011 at 3:44 PM, Reyna.Sabina <Reyna.Sabina@noaa.gov> wrote: > Hello, > > We would like to bypass the backup of a database (dbx) using > ontape. Will the following work? If not, please advise. > > unix> ontape -N dbx -s -L 0 > > We are using 11.50.FC5 under Solaris. > > Thanks! > > Reyna > _________________________________________________________ > Reyna Sabina Phone: (305) 361-4324 > NOAA/AOML/PHOD Fax: (305) 361-4392 > 4301 Rickenbacker Causeway Email: Reyna.Sabina@noaa.gov > Miami, FL 33149-1087 > > "Things do not get better by being left alone." > > -Winston Churchill > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --bcaec501c446f5325b04a5d9ac66