RE: Archive Level 0 from Unix to Disk

Thank's to all for the ideas!!! I will work on these problem with yours indications/hints. thank's again!. Gustavo Tobares Administrador de Sistemas y DBA Centro de C'mputos - Red Megatone TE: 0342-4500972 - Fax: 0342-4500940 -----Mensaje original----- De: Dirk Moolman [mailto:DirkM@mxgroup.co.za] Enviado el: Jueves, 08 de Enero de 2004 06:33 a.m. Para: informix-list@iiug.org Asunto: RE: Archive Level 0 from Unix to Disk Once a month I run a level 0 (+- 250 Gb) to disk, to refresh one of my servers. Solaris 8, IDS 7.31FD3 I created a raw device using volume (damager) manager, and run a normal ontape backup to this device, and then ontape -r from this device to refresh the report server - no problems -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of timothy.a.brown@marconi.com Sent: Wednesday, January 07, 2004 10:12 PM To: gtobares@redmegatone.com Cc: Murray Wood (IList); informix-list@iiug.org; owner-informix-list@iiug.org Subject: RE: Archive Level 0 from Unix to Disk Hi Gustavo, Using the remote device option (tapedev system:tapedevice) is definitely NOT the way to go since you want to write to a filesystem with a 2gb file limitation. There IS a way you can perform a level 0 ontape backup to a filesystem. All you need is a mount point to a filesystem (and it doesn't matter where the actual filesystem resides). All you need is to have sufficient space to hold the archive, since the archive is split into files. The process is pretty straight forward. First, you need to have TAPEDEV set to a symbolic link and have TAPEBLK set to 8 and have TAPESIZE set to a value larger than the Informix instance you want to backup. Next, you start two processes; namely, run compress to a named pipe, and run split to a named pipe. The output from ontape is sent to TAPEDEV and is then routed through 'compress' which then routes through 'split' and produces one or more files that are compressed with a 2048mb limit. I have a simple shell script that does just this. If you want to use it as an example just let me know. The standard compression usually reduces the archive by around 80% depending on the data. I have an instance that has 6.7gb of used dbspace, and it compresses to around 1.4gb. The restore process requires just one named pipe (TAPEDEV will symbolically point to it); however, during the 'ontape -r' you have to start the stream (cat `ls -1 compressedsplitfile*` | uncompress -c > tapedev.symmlink) twice because ontape performs a rewind immediately after reading the header of the archive. Besides this, the restore is the same as any restore using 'ontape -r'. You can apply Informix logical logs and etc... -Tim Gustavo Tobares <gtobares@redmegat To: "Murray Wood (IList)" <ifxmaillist@quanta.co.nz>, one.com> informix-list@iiug.org Sent by: cc: owner-informix-lis Subject: RE: Archive Level 0 from Unix to Disk t@iiug.org 01/07/2004 08:37 AM I all, SCO Unix have a limitation to files (2 Gigas Max), if I mount the NT share (with samba or NFS) I get these limitation..., I need to archive 8 Gigas or more. I make the changes on hosts and hosts.equiv files but still not work. I try nt://share/file nt:/share/file nt:\\share\\file And always get the same result... Gustavo Tobares Administrador de Sistemas y DBA Centro de C'mputos - Red Megatone TE: 0342-4500972 - Fax: 0342-4500940 -----Mensaje original----- De: Murray Wood (IList) [mailto:ifxmaillist@quanta.co.nz] Enviado el: Lunes, 05 de Enero de 2004 06:56 p.m. Para: informix-list@iiug.org Asunto: RE: Archive Level 0 from Unix to Disk I have not done this combination... Your unix server needs to be a trusted host of the W2K server - you can put the unix host in the hosts.equiv file in (I think) %WINDIR%\\system32\\drivers\\etc. You may need to try different combinations of / or \\ in the file name. If you have samba (or equivalent) on your unix server you can try the full UNC name or mount the W2K share as a filesystem. MW > -----Original Message----- > From: owner-informix-list@iiug.org > [mailto:owner-informix-list@iiug.org]On Behalf Of Gustavo Tobares > Sent: Tuesday, 6 January 2004 5:45 a.m. > To: informix-list@iiug.org > Subject: Archive Level 0 from Unix to Disk > > > Hi all, > > I wish to know if they are a way to make level 0 > archives from Unix > (SCO) to one disk file on w2k. > > I share a folder named "level0" with a file name > "backup", then I > modify the tbconfig TAPEDEV to ip_nt:/level0/backup > > When I start de archive (tbtape -s) I receive one error > "Connection > Refused". > > Some one have some experience or idea? > > Thank's you very much (and sorry for my english). > > > > Gustavo Tobares > Administrador de Sistemas y DBA > Centro de C'mputos - Red Megatone > TE: 0342-4500972 - Fax: 0342-4500940 > > > sending to informix-list sending to informix-list sending to informix-list sending to informix-list ________________________________ << ella for Spam Control >> has removed 492 Spam messages and set aside 18 Newsletters for me You can use it too - and it's FREE! www.ellaforspam.com sending to informix-list sending to informix-list