Re: Database Copy
On 07/06/07, Ogiwara Tsutomu <tsutomu_ogiwara@hotmail.com> wrote:
> Hi, Howard.
>
> Just a thought.
>
> If you use all chunk on block file system(not using raw device), how about
> the following ?
> (Be aware, I do not test it.)
>
> mount new disk on HP-UX.
> Then dump / restore.
>
> dump 0f - /dev/rdsk/c0t0d0s7 | (cd /ifx_data; restore xf -)
> umount old disk (Need oninit -ky before umount).
> mount new disk on old device.
>
> Then oninit.
>
> How do you think my idea ?
>
> Just my $0.02.
>
> --
> Tsutomu Ogiwara from Tokyo Japan.
>
>
>
>
>
> >From: "howie.lfc@googlemail.com" <howie.lfc@googlemail.com>
> >To: informix-list@iiug.org
> >Subject: Database Copy
> >Date: Wed, 06 Jun 2007 03:38:27 -0700
> >
> >Informix Ver 9.40.FC4
> >HP-UX 11.11
> >
> >We have a 350Gb database running baan that the customer wishes to
> >replicate.
> >They are in the process of purchasing enough disks for this to be
> >carried out on the same server as live.
> >
> >The question I have is there any way of copying the database other
> >than to use export/import as this has been calculated to take in the
> >region of 6 days!
> >
> >The last time I had to carry out anything like this was onto a new
> >server which I did by creating all the dbspaces/chunks as live then
> >used the level 0 backup to copy the data across....not an option here
> >I guess...
> >
> >Thanks in advance....
> >
> >
> >Howard
> >
> >_______________________________________________
> >Informix-list mailing list
> >Informix-list@iiug.org
> >http://www.iiug.org/mailman/listinfo/informix-list
>
> _________________________________________________________________
> MSNグルメ「今日のレシピ」をRSSで毎日逃さずキャッチできる MSN版IE7
> http://promotion.msn.co.jp/ie7/
>
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>
Only trouble with this (or any other disk to disk copying or
mirror/mirror split) is that the 'new' instance still has the path
names of the chunks embedded in the rootdbs so you cannot have both
copies running on the same machine at the same time (unless you want
to try binary editting the rootdbs to change the chunk paths !!!). The
rename option on restore was specifically written for this scenario,
it is reliable and works well (see previous caveat !!)
Keith