SEO

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 [mailtoirkM@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 [mailtowner-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

> [mailtowner-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