Copy database
User asked if copying a 2TB Informix database's cooked files to a new instance with identically-defined spaces would work. Experts confirmed it works if the source database is offline or blocked (onmode -c block). User's plan to copy from a replicated instance offline, then sync back was approved. Additional advice: ensure sufficient logical logs to prevent wrapping during sync, and consider using ifxclone tool for copying live databases.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
I want to make a copy of a 2TB database using cooked files. Most of that space
is sblob. Will it work to copy the data files from the old to the new instance
if my spaces are defined exactly the same on both servers?
12.1FC5 on Linux:
$uname -a
Linux psdb11-prodrf.ps.utah.gov 2.6.32-504.12.2.el6.x86_64 #1 SMP Sun Feb 1
12:14:02 EST 2015 x86_64 x86_64 x86_64 GNU/Linux
$onstat -
IBM Informix Dynamic Server Version 12.10.FC5 -- On-Line -- Up 45 days
07:18:32 -- 2388908 Kbytes
Yes, as long as the copy is made while the engine is either offline or
under onmode -c block as if you are taking an external archive.
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.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 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 Wed, Jun 3, 2015 at 4:23 PM, BEVIS KENNEDY <bkennedy@utah.gov> wrote:
> I want to make a copy of a 2TB database using cooked files. Most of that
> space
> is sblob. Will it work to copy the data files from the old to the new
> instance
> if my spaces are defined exactly the same on both servers?
> 12.1FC5 on Linux:
>
> $uname -a
> Linux psdb11-prodrf.ps.utah.gov 2.6.32-504.12.2.el6.x86_64 #1 SMP Sun Feb
> 1
> 12:14:02 EST 2015 x86_64 x86_64 x86_64 GNU/Linux
>
> $onstat -
> IBM Informix Dynamic Server Version 12.10.FC5 -- On-Line -- Up 45 days
> 07:18:32 -- 2388908 Kbytes>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--089e01182f7228a1fe0517a3353f
Thanks Art. My plan is to take a replicated instance offline, ftp the datafiles, then sync everything back up. Saturdays have the lowest transaction load so if I do the copy then I'm hoping syncing things back up afterwards won't be too painful.
Assuming by "replicated instance" you mean an RSS or HDR secondary or an ER replicant. That should work just fine. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.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 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 Wed, Jun 3, 2015 at 5:01 PM, BEVIS KENNEDY <bkennedy@utah.gov> wrote: > Thanks Art. > My plan is to take a replicated instance offline, ftp the datafiles, then > sync > everything back up. > Saturdays have the lowest transaction load so if I do the copy then I'm > hoping > syncing things back up afterwards won't be too painful. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a113321ee5fbfcc0517a36920
Just ensure you have enough logical logs so that logs doesn't not get wrapped till you sync up the data to secondary node. Regards, Vaibhav S Dantale IBM Informix CTE Lead Mobile - +91-9503161335 email- vdantale@in.ibm.com Twitter - @dantalevs Blog - http://timeseriesibm.blogspot.in/ (Works better in firefox) From: "BEVIS KENNEDY" <bkennedy@utah.gov> To: ids@iiug.org Date: 06/04/2015 02:31 AM Subject: Re: Copy database [35220] Sent by: ids-bounces@iiug.org Thanks Art. My plan is to take a replicated instance offline, ftp the datafiles, then sync everything back up. Saturdays have the lowest transaction load so if I do the copy then I'm hoping syncing things back up afterwards won't be too painful. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
Should do, although as per Art the source database, be it the Primary or an RSS/HDR, would have to be offline for the duration of the copy. Have you considered ifxclone for this? It's pretty cool and can be run against a running source.