RE: Ontape restore to another server

Excellent idea Keith!! A second informix instance on the same solaris box is a great idea, informix has such a small footprint anyway. And if you PRD db is a large memory instance, you can make the second instance much smaller, restore take longer, but who cares, you don't want to impact PRD much. If your solaris box doesn't have the disk space, heck..... nfs mount the space from the linux box u were going to use..... you can leave it cooked, informix don't care, ......... BUT.... would there be a problem with the links? If DB1 (production) has dbspace-root set to linkX to raw deviceB Then.... second instance.... .... sorry, my brain just stopped there.... guys, would there be a problem at this point.... Norma Jean Sebastian ERP Support Administration IT - Enterprise Technical Services -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Keith Simmons Sent: Thursday, December 28, 2006 10:40 AM To: Gary Quiring Cc: informix-list@iiug.org Subject: Re: Ontape restore to another server On 28 Dec 2006 07:57:44 -0800, Gary Quiring <gquiring@gmail.com> wrote: > Sebastian, Norma J. wrote: > > Don't think that's different than other DB products. > > > > Use the right tool (dbexport/import like Keith said), and it'll work > > fine. > My current backup is in ontape format. The only place to get that data > is on that tape. I don't have another Sun box to restore the data to. > Looking forward I don't see using dbexport as a practical backup > solution for a 150gig DB. Other DB products may be alike but that does > not excuse the issue. I think it's silly they can't make backup data > compatible between hardware platforms. > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > Gary You were not asking for an archive/backup solution, only data transfer. Horses for courses. Ontape is designed to archive data and then restore it to the same or similar server. The two servers you have probably have different page sizes (2K for Sol, 4K for Linux) possibly different endedness (big or little), different procesors (Sparc and Intel). Text files wold probably ftp between them OK but ontape stores the data in binary page images (for speed of archive and restore). I would have thought cpio or tar wold not work between these servers either, and they would only be transfering 'data'. Do you have enough space on your Solaris box to create another instance and then restore to this (using chunk renaming) just to extract the table you need. ou could investigate table level restores as well, although I can't remember off the top of my head whether this is available at v9.4. Keith _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list ============================================================ The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any reproduction, dissemination or distribution of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. Tellabs ============================================================

Sebastian, Norma J. wrote: > Excellent idea Keith!! > > A second informix instance on the same solaris box is a great idea, > informix has such a small footprint anyway. And if you PRD db is a > large memory instance, you can make the second instance much smaller, > restore take longer, but who cares, you don't want to impact PRD much. > This instance idea with a mounted file system sounds like a solution. I did use links for my raw devices so that should not be an issue. My dev box is also Solaris but has no space for the restore but the mounted system from Linux can solve that. Getting back to the tape drive which is unique on the production box. If I add an instance on my dev box to use the production tape, is it full proof that when I issue the ontape -r on the dev box that the restore will be done locally and not on production? I don't want the restore stepping on the prod box. Question for instances. I have never configured one. I would copy the onconfig to another name and change the DBSERVERNAME, DBSERVERALIASES, MSGPATH, SERVERNUM & ROOTHPATH. I can keep my current INFORMIXDIR right? Or do I need to make a complete copy else where? I should just need to change ONCONFIG & INFORMIXSERVER?