Re: Ontape restore to another server

On 28/12/06, Sebastian, Norma J. <NormaJean.Sebastian@tellabs.com> wrote: > > I think the idea will work. I have to look at some of my systems and > remember some things. > > I am glad you said you would try this on your DEV box. Is the name of > your DEV database different than your PRD database? And what is the > name of your $INFORMIXDIR? > > I believe you pegged the right onconfig params that need to be changed. > Let me put some more thought into it, check my systems, and post back. > > Of course, once we plan this out, you may still want a warm/fuzzy with > IBM Informix tech support. I have done interesting things with my > systems, but I will only put my neck on the line, not yours ;) > > > 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 Gary Quiring > Sent: Thursday, December 28, 2006 2:20 PM > To: informix-list@iiug.org > Subject: Re: Ontape restore to another server > > > 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? > > _______________________________________________ Gary Please do not forget chunk renaming else in best case you will not be able to restore, in worst case you will overwrite your existing chunks regardless of any other changes you make. backup and Restore guide is your friend and describes the senario well. You need to keep the existing ROOTPATH in your new onconfig but rename it on the command line when you run ontape -r. The ontape will create a new onconfig with the new root path in it. Don't forget sqlhosts entries or /etc/services entries if you are using tcp connections. Also CONSOLE if it is directed to a file. You might also want to reduce BUFFERS and LOCKS if you are only looking to recover data (save a bit of memory). Keith