RE: Ontape

IDS 11.50.FC5 on Solaris 10 I thought that I heard a while back that ontape can be used to back up an instance, and restore the instance to a different instance on the same server. Am I remembering correctly or not? If not, can a database be restore from an ontape backup to a different instance on the same server? Also, I have always used a tape drive for backing up with ontape. Do network drives work as well, so that an instance can be backed up to a network drive, and then later be archived to tape with the system backup? Thank you. Larry

On Mon, Nov 12, 2012 at 6:16 PM, LARRY SORENSEN <lsorensen25@msn.com> wrote: > IDS 11.50.FC5 on Solaris 10 I thought that I heard a while back that ontape > can be used to back up an instance, and restore the instance to a different > instance on the same server. Am I remembering correctly or not? If not, > can a > Yes, but you have to use the rename chunks feature, and if you miss any chunk, your original chunk will be overwritten which is not good for obvious reasons. So, be very careful with it! You'll also need to change the environment (INFORMIXSERVER, ONCONFIG etc.) I would not advise anyone to do this unless it's strictly necessary. Hopefully IBM will try to do something that prevents the users to make mistakes, but there's nothing in there at this moment that will prevent a mistake, and a mistake can cost you the integrity of your production server. > database be restore from an ontape backup to a different instance on the > same > server? Also, I have always used a tape drive for backing up with ontape. > Do > network drives work as well, so that an instance can be backed up to a > network > drive, and then later be archived to tape with the system backup? Thank > you. > Not sure what you mean by network drives and system backup. Ontape can archive to a file or directory (filename will be generated automatically. I suppose this will do want you want. Regards. -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --047d7b6d7d5096a58b04ce50653b

ontape is an instance level utility. It backs up to a device or pipe. = The device can be a disk file - wherever it happens to be located - of = course you will introduce latency with an NFS mounted disk file. You could use it to restore to a different instance on the same machine, = but you would have to rename the devices (under the dbspaces) during the = restore. cheers j. On Nov 12, 2012, at 1:16 PM, LARRY SORENSEN wrote: > IDS 11.50.FC5 on Solaris 10 I thought that I heard a while back that = ontape=20 > can be used to back up an instance, and restore the instance to a = different=20 > instance on the same server. Am I remembering correctly or not? If = not, can a=20 > database be restore from an ontape backup to a different instance on = the same=20 > server? Also, I have always used a tape drive for backing up with = ontape. Do=20 > network drives work as well, so that an instance can be backed up to a = network=20 > drive, and then later be archived to tape with the system backup? = Thank you.=20 > Larry=20 >=20 >=20 > = **************************************************************************= *****=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20= >=20

Larry: See my in-line responses below: Art Art S. Kagel Advanced DataTools (www.advancedatatools.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 my employer, Advanced DataTools, 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 Mon, Nov 12, 2012 at 1:16 PM, LARRY SORENSEN <lsorensen25@msn.com> wrote: > IDS 11.50.FC5 on Solaris 10 > I thought that I heard a while back that ontape > can be used to back up an instance, and restore the instance to a different > instance on the same server. Am I remembering correctly or not? Yes, you would do what's called a "redirected restore". You basically tell ontape to write each chunk to a different file/device than the one it came from. Note, this will be a completely new instance. Quick and dirty: - Create a new ONCONFIG file for the restored instance and make entries for it in your sqlhosts file. - Change the ROOTPATH, DBSERVERNAME, DBSERVERALIASES, & HA_ALIAS if they are set, to describe the new server instance. - Create a file mapping each chunk (including the ROOTPATH chunk) to its new location (the format is in the Backup and Restore Guide) - Run "ontape -r -rename -f <path to the mapping file>" - That's it. If not, can a > database be restore from an ontape backup to a different instance on the > same > server? You can restore a single database or even a single table or just certain filtered rows from a table from an archive to any server using the archecker utility. See the Backup and Restore Guide for details. Also, I have always used a tape drive for backing up with ontape. Do > network drives work as well, so that an instance can be backed up to a > network > drive, and then later be archived to tape with the system backup? You can archive and restore to disk with ontape, yes, and the target can be a networked drive or a local one. You can use either the ONCONFIG parameter TAPEDEV or the ontape command line's -t option to specify a file or a directory. If you specify a directory, then ontape will handle creating and renaming the files so subsequent archives do not stomp on the previous one. > Thank you. > Larry > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --e89a8f235483f3328f04ce507415

Forgot to mention, you have to set INFORMIXSERVER and ONCONFIG to point to the new DBSERVERNAME and the new ONCONFIG file before starting the restore. Art Art S. Kagel Advanced DataTools (www.advancedatatools.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 my employer, Advanced DataTools, 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 Mon, Nov 12, 2012 at 1:27 PM, Art Kagel <art.kagel@gmail.com> wrote: > Larry: > > See my in-line responses below: > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.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 my employer, Advanced DataTools, 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 Mon, Nov 12, 2012 at 1:16 PM, LARRY SORENSEN <lsorensen25@msn.com> > wrote: > > > IDS 11.50.FC5 on Solaris 10 > > > I thought that I heard a while back that ontape > > can be used to back up an instance, and restore the instance to a > different > > instance on the same server. Am I remembering correctly or not? > > Yes, you would do what's called a "redirected restore". You basically > tell ontape to write each chunk to a different file/device than the one it > came from. Note, this will be a completely new instance. Quick and dirty: > > - Create a new ONCONFIG file for the restored instance and make entries > > for it in your sqlhosts file. > > - Change the ROOTPATH, DBSERVERNAME, DBSERVERALIASES, & HA_ALIAS if > > they are set, to describe the new server instance. > > - Create a file mapping each chunk (including the ROOTPATH chunk) to its > > new location (the format is in the Backup and Restore Guide) > > - Run "ontape -r -rename -f <path to the mapping file>" > > - That's it. > > If not, can a > > database be restore from an ontape backup to a different instance on the > > same > > server? > > You can restore a single database or even a single table or just certain > filtered rows from a table from an archive to any server using the > archecker utility. See the Backup and Restore Guide for details. > > Also, I have always used a tape drive for backing up with ontape. Do > > network drives work as well, so that an instance can be backed up to a > > network > > drive, and then later be archived to tape with the system backup? > > You can archive and restore to disk with ontape, yes, and the target can be > a networked drive or a local one. You can use either the ONCONFIG > parameter TAPEDEV or the ontape command line's -t option to specify a file > or a directory. If you specify a directory, then ontape will handle > creating and renaming the files so subsequent archives do not stomp on the > previous one. > > > Thank you. > > Larry > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --e89a8f235483f3328f04ce507415 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --f46d04479769c0887704ce507e37

Thank you all for your quick responses. I will have to sit down now and do some configuring and testing now that I know it's possible. I may have a few questions later if you are all willing. Larry > To: ids@iiug.org > From: art.kagel@gmail.com > Subject: Re: Ontape [28794] > Date: Mon, 12 Nov 2012 13:30:32 -0500 > > Forgot to mention, you have to set INFORMIXSERVER and ONCONFIG to point to > the new DBSERVERNAME and the new ONCONFIG file before starting the restore. > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.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 my employer, Advanced DataTools, 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 Mon, Nov 12, 2012 at 1:27 PM, Art Kagel <art.kagel@gmail.com> wrote: > > > Larry: > > > > See my in-line responses below: > > > > Art > > > > Art S. Kagel > > Advanced DataTools (www.advancedatatools.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 my employer, Advanced DataTools, 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 Mon, Nov 12, 2012 at 1:16 PM, LARRY SORENSEN <lsorensen25@msn.com> > > wrote: > > > > > IDS 11.50.FC5 on Solaris 10 > > > > > I thought that I heard a while back that ontape > > > can be used to back up an instance, and restore the instance to a > > different > > > instance on the same server. Am I remembering correctly or not? > > > > Yes, you would do what's called a "redirected restore". You basically > > tell ontape to write each chunk to a different file/device than the one it > > came from. Note, this will be a completely new instance. Quick and dirty: > > > > - Create a new ONCONFIG file for the restored instance and make entries > > > > for it in your sqlhosts file. > > > > - Change the ROOTPATH, DBSERVERNAME, DBSERVERALIASES, & HA_ALIAS if > > > > they are set, to describe the new server instance. > > > > - Create a file mapping each chunk (including the ROOTPATH chunk) to its > > > > new location (the format is in the Backup and Restore Guide) > > > > - Run "ontape -r -rename -f <path to the mapping file>" > > > > - That's it. > > > > If not, can a > > > database be restore from an ontape backup to a different instance on the > > > same > > > server? > > > > You can restore a single database or even a single table or just certain > > filtered rows from a table from an archive to any server using the > > archecker utility. See the Backup and Restore Guide for details. > > > > Also, I have always used a tape drive for backing up with ontape. Do > > > network drives work as well, so that an instance can be backed up to a > > > network > > > drive, and then later be archived to tape with the system backup? > > > > You can archive and restore to disk with ontape, yes, and the target can be > > a networked drive or a local one. You can use either the ONCONFIG > > parameter TAPEDEV or the ontape command line's -t option to specify a file > > or a directory. If you specify a directory, then ontape will handle > > creating and renaming the files so subsequent archives do not stomp on the > > previous one. > > > > > Thank you. > > > Larry > > > > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > --e89a8f235483f3328f04ce507415 > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --f46d04479769c0887704ce507e37 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

only if the chunks are defined using relative path names From: "LARRY SORENSEN" <lsorensen25@msn.com> To: ids@iiug.org, Date: 11/12/2012 12:17 PM Subject: RE: Ontape [28790] Sent by: ids-bounces@iiug.org IDS 11.50.FC5 on Solaris 10 I thought that I heard a while back that on= tape can be used to back up an instance, and restore the instance to a diffe= rent instance on the same server. Am I remembering correctly or not? If not,= can a database be restore from an ontape backup to a different instance on th= e same server? Also, I have always used a tape drive for backing up with ontap= e. Do network drives work as well, so that an instance can be backed up to a network drive, and then later be archived to tape with the system backup? Thank= you. Larry ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =

Actually, your ONCONFIG has to have ROOTPATH set to the old ROOTPATH = before you rename it. In the process of renaming the dbspace, it wil = update the new ONCONFIG. j. On Nov 12, 2012, at 1:30 PM, Art Kagel wrote: > Forgot to mention, you have to set INFORMIXSERVER and ONCONFIG to = point to=20 > the new DBSERVERNAME and the new ONCONFIG file before starting the = restore.=20 >=20 > Art=20 >=20 > Art S. Kagel=20 > Advanced DataTools (www.advancedatatools.com)=20 > Blog: http://informix-myview.blogspot.com/=20 >=20 > Disclaimer: Please keep in mind that my own opinions are my own = opinions=20 > and do not reflect on my employer, Advanced DataTools, the IIUG, nor = any=20 > other organization with which I am associated either explicitly,=20 > implicitly, or by inference. Neither do those opinions reflect those = of=20 > other individuals affiliated with any entity with which I am = affiliated nor=20 > those of the entities themselves.=20 >=20 > On Mon, Nov 12, 2012 at 1:27 PM, Art Kagel <art.kagel@gmail.com> = wrote:=20 >=20 >> Larry:=20 >>=20 >> See my in-line responses below:=20 >>=20 >> Art=20 >>=20 >> Art S. Kagel=20 >> Advanced DataTools (www.advancedatatools.com)=20 >> Blog: http://informix-myview.blogspot.com/=20 >>=20 >> Disclaimer: Please keep in mind that my own opinions are my own = opinions=20 >> and do not reflect on my employer, Advanced DataTools, the IIUG, nor = any=20 >> other organization with which I am associated either explicitly,=20 >> implicitly, or by inference. Neither do those opinions reflect those = of=20 >> other individuals affiliated with any entity with which I am = affiliated nor=20 >> those of the entities themselves.=20 >>=20 >> On Mon, Nov 12, 2012 at 1:16 PM, LARRY SORENSEN <lsorensen25@msn.com>=20= >> wrote:=20 >>=20 >>> IDS 11.50.FC5 on Solaris 10=20 >>=20 >>> I thought that I heard a while back that ontape=20 >>> can be used to back up an instance, and restore the instance to a=20 >> different=20 >>> instance on the same server. Am I remembering correctly or not?=20 >>=20 >> Yes, you would do what's called a "redirected restore". You basically=20= >> tell ontape to write each chunk to a different file/device than the = one it=20 >> came from. Note, this will be a completely new instance. Quick and = dirty:=20 >>=20 >> - Create a new ONCONFIG file for the restored instance and make = entries=20 >>=20 >> for it in your sqlhosts file.=20 >>=20 >> - Change the ROOTPATH, DBSERVERNAME, DBSERVERALIASES, & HA_ALIAS if=20= >>=20 >> they are set, to describe the new server instance.=20 >>=20 >> - Create a file mapping each chunk (including the ROOTPATH chunk) to = its=20 >>=20 >> new location (the format is in the Backup and Restore Guide)=20 >>=20 >> - Run "ontape -r -rename -f <path to the mapping file>"=20 >>=20 >> - That's it.=20 >>=20 >> If not, can a=20 >>> database be restore from an ontape backup to a different instance on = the=20 >>> same=20 >>> server?=20 >>=20 >> You can restore a single database or even a single table or just = certain=20 >> filtered rows from a table from an archive to any server using the=20 >> archecker utility. See the Backup and Restore Guide for details.=20 >>=20 >> Also, I have always used a tape drive for backing up with ontape. Do=20= >>> network drives work as well, so that an instance can be backed up to = a=20 >>> network=20 >>> drive, and then later be archived to tape with the system backup?=20 >>=20 >> You can archive and restore to disk with ontape, yes, and the target = can be=20 >> a networked drive or a local one. You can use either the ONCONFIG=20 >> parameter TAPEDEV or the ontape command line's -t option to specify a = file=20 >> or a directory. If you specify a directory, then ontape will handle=20= >> creating and renaming the files so subsequent archives do not stomp = on the=20 >> previous one.=20 >>=20 >>> Thank you.=20 >>> Larry=20 >>>=20 >>>=20 >>>=20 >>>=20 >>=20 >>=20 > = **************************************************************************= *****=20 >>> Forum Note: Use "Reply" to post a response in the discussion forum.=20= >>>=20 >>>=20 >>=20 >> --e89a8f235483f3328f04ce507415=20 >>=20 >>=20 >>=20 >>=20 > = **************************************************************************= *****=20 >> Forum Note: Use "Reply" to post a response in the discussion forum.=20= >>=20 >>=20 >=20 > --f46d04479769c0887704ce507e37=20 >=20 >=20 > = **************************************************************************= *****=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20= >=20

Here's a how to I did a while back, this was under Windows, but the same = things should apply in the real world: I want to restore a backup taken from one machine to another where the = dbspaces are in different locations. For example - the backup image I am = restoring has rootdbs on D:\\\\IFMXDATA\\\\cvprpt120\\\\rootdbs_dat.000 the = machine I am restoring to has D: as a DVD drive - I need to put it in = E:\\\\IFMXDATA\\\\cvpdbrep1\\\\rootdbs_dat.000. So I have to rename the chunks from the backup to map them to my chunks = on the way in. ontape allows you to do this either on the command line = or in a file (since I want to repeat this in the future and there are 6 = dbspaces I'll use a file). File looks like: oldchunk offset newchunk offset or D:\\\\IFMXDATA\\\\cvprpt120\\\\rootdbs_dat.000 0 = E:\\\\IFMXDATA\\\\cvpdbrep1\\\\rootdbs_dat.000 0 and so forth - each chunk remap on it's own line. I can then: ontape -r -rename -f <filename> Except that I get an error: Physical restore failed - ONCONFIG ROOTPATH: = 'E:\\\\IFMXDATA\\\\cvp_db_cvpdbrep1\\\\rootdbs_dat.000' differs from archive: = 'D:\\\\IFMXDATA\\\\cvp_db_cvprpt120\\\\rootdbs_dat.000' Correct ONCONFIG before restoring this archive.=20 I have to go change %INFORMIXDIR%/etc/%ONCONFIG% and change ROOTDBS to = be D:\\\\IFMXDATA\\\\cvprpt120\\\\rootdbs_dat.000 - even though I don't have such = a drive or chunk - ontape will rename it for you later on. A little = unclear from the doc =20 NOTE: Database has to be in a down state before starting the restore. = "onmode -yuk" will take it there. During the restore, you will be asked: Do you want to backup the current log (no) Do you want to restore a level 1 backup (no - unless of course you = really do have a level 1 to restore) Do you want to restore logical logs (no) When the restore is complete, the database will be in a quiescent state = and will need to be taken into online mode with a "onmode -m". Notes: 1 Case on chunk renames must match.=20 2 If you have two chunks in one file, use the offset to identify/rename = them. Note that case must match and that offset is in KBYTES, not pages = - so multiple the offset reported by onstat -d *2 (Linux) or 4 (Windows) = or whatever custom size you used. On Nov 12, 2012, at 1:30 PM, Art Kagel wrote: > Forgot to mention, you have to set INFORMIXSERVER and ONCONFIG to = point to=20 > the new DBSERVERNAME and the new ONCONFIG file before starting the = restore.=20 >=20 > Art=20 >=20 > Art S. Kagel=20 > Advanced DataTools (www.advancedatatools.com)=20 > Blog: http://informix-myview.blogspot.com/=20 >=20 > Disclaimer: Please keep in mind that my own opinions are my own = opinions=20 > and do not reflect on my employer, Advanced DataTools, the IIUG, nor = any=20 > other organization with which I am associated either explicitly,=20 > implicitly, or by inference. Neither do those opinions reflect those = of=20 > other individuals affiliated with any entity with which I am = affiliated nor=20 > those of the entities themselves.=20 >=20 > On Mon, Nov 12, 2012 at 1:27 PM, Art Kagel <art.kagel@gmail.com> = wrote:=20 >=20 >> Larry:=20 >>=20 >> See my in-line responses below:=20 >>=20 >> Art=20 >>=20 >> Art S. Kagel=20 >> Advanced DataTools (www.advancedatatools.com)=20 >> Blog: http://informix-myview.blogspot.com/=20 >>=20 >> Disclaimer: Please keep in mind that my own opinions are my own = opinions=20 >> and do not reflect on my employer, Advanced DataTools, the IIUG, nor = any=20 >> other organization with which I am associated either explicitly,=20 >> implicitly, or by inference. Neither do those opinions reflect those = of=20 >> other individuals affiliated with any entity with which I am = affiliated nor=20 >> those of the entities themselves.=20 >>=20 >> On Mon, Nov 12, 2012 at 1:16 PM, LARRY SORENSEN <lsorensen25@msn.com>=20= >> wrote:=20 >>=20 >>> IDS 11.50.FC5 on Solaris 10=20 >>=20 >>> I thought that I heard a while back that ontape=20 >>> can be used to back up an instance, and restore the instance to a=20 >> different=20 >>> instance on the same server. Am I remembering correctly or not?=20 >>=20 >> Yes, you would do what's called a "redirected restore". You basically=20= >> tell ontape to write each chunk to a different file/device than the = one it=20 >> came from. Note, this will be a completely new instance. Quick and = dirty:=20 >>=20 >> - Create a new ONCONFIG file for the restored instance and make = entries=20 >>=20 >> for it in your sqlhosts file.=20 >>=20 >> - Change the ROOTPATH, DBSERVERNAME, DBSERVERALIASES, & HA_ALIAS if=20= >>=20 >> they are set, to describe the new server instance.=20 >>=20 >> - Create a file mapping each chunk (including the ROOTPATH chunk) to = its=20 >>=20 >> new location (the format is in the Backup and Restore Guide)=20 >>=20 >> - Run "ontape -r -rename -f <path to the mapping file>"=20 >>=20 >> - That's it.=20 >>=20 >> If not, can a=20 >>> database be restore from an ontape backup to a different instance on = the=20 >>> same=20 >>> server?=20 >>=20 >> You can restore a single database or even a single table or just = certain=20 >> filtered rows from a table from an archive to any server using the=20 >> archecker utility. See the Backup and Restore Guide for details.=20 >>=20 >> Also, I have always used a tape drive for backing up with ontape. Do=20= >>> network drives work as well, so that an instance can be backed up to = a=20 >>> network=20 >>> drive, and then later be archived to tape with the system backup?=20 >>=20 >> You can archive and restore to disk with ontape, yes, and the target = can be=20 >> a networked drive or a local one. You can use either the ONCONFIG=20 >> parameter TAPEDEV or the ontape command line's -t option to specify a = file=20 >> or a directory. If you specify a directory, then ontape will handle=20= >> creating and renaming the files so subsequent archives do not stomp = on the=20 >> previous one.=20 >>=20 >>> Thank you.=20 >>> Larry=20 >>>=20 >>>=20 >>>=20 >>>=20 >>=20 >>=20 > = **************************************************************************= *****=20 >>> Forum Note: Use "Reply" to post a response in the discussion forum.=20= >>>=20 >>>=20 >>=20 >> --e89a8f235483f3328f04ce507415=20 >>=20 >>=20 >>=20 >>=20 > = **************************************************************************= *****=20 >> Forum Note: Use "Reply" to post a response in the discussion forum.=20= >>=20 >>=20 >=20 > --f46d04479769c0887704ce507e37=20 >=20 >=20 > = **************************************************************************= *****=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20= >=20

As long as you get everything set properly .. this works like a charm .... Peter Logan Senior Database Administrator Phone: 616/878-8309 From: "LARRY SORENSEN" <lsorensen25@msn.com> To: ids@iiug.org, Date: 11/12/2012 01:38 PM Subject: RE: Ontape [28795] Sent by: ids-bounces@iiug.org Thank you all for your quick responses. I will have to sit down now and do some configuring and testing now that I know it's possible. I may have a few questions later if you are all willing. Larry > To: ids@iiug.org > From: art.kagel@gmail.com > Subject: Re: Ontape [28794] > Date: Mon, 12 Nov 2012 13:30:32 -0500 > > Forgot to mention, you have to set INFORMIXSERVER and ONCONFIG to point to > the new DBSERVERNAME and the new ONCONFIG file before starting the restore. > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.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 my employer, Advanced DataTools, 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 Mon, Nov 12, 2012 at 1:27 PM, Art Kagel <art.kagel@gmail.com> wrote: > > > Larry: > > > > See my in-line responses below: > > > > Art > > > > Art S. Kagel > > Advanced DataTools (www.advancedatatools.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 my employer, Advanced DataTools, 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 Mon, Nov 12, 2012 at 1:16 PM, LARRY SORENSEN <lsorensen25@msn.com> > > wrote: > > > > > IDS 11.50.FC5 on Solaris 10 > > > > > I thought that I heard a while back that ontape > > > can be used to back up an instance, and restore the instance to a > > different > > > instance on the same server. Am I remembering correctly or not? > > > > Yes, you would do what's called a "redirected restore". You basically > > tell ontape to write each chunk to a different file/device than the one it > > came from. Note, this will be a completely new instance. Quick and dirty: > > > > - Create a new ONCONFIG file for the restored instance and make entries > > > > for it in your sqlhosts file. > > > > - Change the ROOTPATH, DBSERVERNAME, DBSERVERALIASES, & HA_ALIAS if > > > > they are set, to describe the new server instance. > > > > - Create a file mapping each chunk (including the ROOTPATH chunk) to its > > > > new location (the format is in the Backup and Restore Guide) > > > > - Run "ontape -r -rename -f <path to the mapping file>" > > > > - That's it. > > > > If not, can a > > > database be restore from an ontape backup to a different instance on the > > > same > > > server? > > > > You can restore a single database or even a single table or just certain > > filtered rows from a table from an archive to any server using the > > archecker utility. See the Backup and Restore Guide for details. > > > > Also, I have always used a tape drive for backing up with ontape. Do > > > network drives work as well, so that an instance can be backed up to a > > > network > > > drive, and then later be archived to tape with the system backup? > > > > You can archive and restore to disk with ontape, yes, and the target can be > > a networked drive or a local one. You can use either the ONCONFIG > > parameter TAPEDEV or the ontape command line's -t option to specify a file > > or a directory. If you specify a directory, then ontape will handle > > creating and renaming the files so subsequent archives do not stomp on the > > previous one. > > > > > Thank you. > > > Larry > > > > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > --e89a8f235483f3328f04ce507415 > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --f46d04479769c0887704ce507e37 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.