Re: moving instance old drives to new

Kevin <kevin_burdish@timeinc.com> wrote in message news:7h9uar$90q$1@ffx2nh3.news.uu.net... > Hey Boys and Girls! > > We are about to attempt to move an instance from 1 set of drives to a new > set of drives on the same machine. I am looking for any and all suggestions > on the best way to accomplish this. > In addition to the drive change, there will be changes to the dbspace names > (some will remain the same) and sizes( bigger). I'm thinking I need the > dbspaces to remain intact while I insert/select into the new dbspaces. I've > sort of eliminated a backup/restore scenario since the dbspace names > couldn't be changed. The DB is about 100 GB which I don't think we would > have the space for a dbexport/dbimport. This is the production machine and > I'm going to try to accomplish this over a weekend. We are planning on > bringing the memory from 1.5 GB to 3 Gb. This is on Solaris 2.6 on a 4 CPU > Enterprise 3000 with IFMX 7.30. > > Q. Is this the way to go? Am I missing a far easier scenario? > > Q. Can the INFORMIXSERVER and aliases be renamed back to the old names once > the original instance is dropped? > > Q. Could I do this with one instance and somehow rename the dbspaces later? > The devices are currently the c0t3d0s0 nomenclature, these will become Vol01 > vol02 etc etc with the Veritas Storage Mgr. The devices are symbolically > linked. Would this allow me to create another set of links and have dbspaces > with the same name? > > Q. What are the gotchas for creating a 2nd instance (temporarily) on the > same machine. Kernal parameters need to be changed? Etc. ETc. > I am planning on capping each instance to only use 1/2 the memory with the > SHMTOTAL parameter. Anything else??? > > Please respond with any suggestions or alternatives!!! Thanks! > Kevin > > > What I've done in the past, though not on Solaris, is:- unmount the filesystems Go into single user mode Run divvy (or it's Solaris equiv) Renamed the current filesystem(s) Created a new filesystem(s) with the old names from above mount both the old and new filesystems Copied the data from the old filesystem(s) to the new one and restarted the server in multi-user. This seems the simplest way with no involvement of tapes. I have also done this with HP-UX and LVMs, SCO UNIX and a few others. This saves me dropping the data onto tape, always have 2 current backups anyway, and getting involed in extra downtime. It also means that it's a straight disk to disk transfer, no variables to change etc.. -- Pete pete@viper.karoo.co.uk www.karoo.net/viper