Re: Informix backup - questions

Thank you so much. It works great that way. Bless you that helped me. Forgive my ignorance but I am a network admin not a DBA so bear with me, please What I am planning is to write a shell script which will make the backup in a file ontape -s, zip the file and copy it in a hard drive where I will keep all of the backups. The zip file will have the date stamp as part of its name so I won't overwrite the files. Then the backup file will be deleted and an empty one will be created so the next backup can be written (or can the file be overwritten without problem ?) Does this sound ok ? I am planning to run a 0 level backup once a week and a 1 level backup every night. Do I need to backup logical logs as well (ontape -a) besides ontape -s ? What about the block size ? I am keeping it 1024. Is it ok ? And what about the tape size ? I have no idea how big the file might be. How big should be the tapesize ? If there is any manual for dummies on informix backup out there please let me know. Genti On 5/24/05, Everett Mills <eemills@nationalbeef.com> wrote: > > Genti- > Informix cannot write to a directory, it needs a file or a > device. Try this, instead: Create a file in each directory that looks > like this: > > -rw-rw-rw- 1 informix informix 0 May 11 18:21 backup.info > > example: > > $pwd > /tape > $whoami > informix > $touch backup.info > $chmod 666 backup.info > > Alter your onconfig to look like this: > > TAPEDEV /tape/backup.info # Tape device path > > LTAPEDEV /logtape/backup.info # Log tape device path > > I am assuming that you're dumping your backups to disk in order > to write them to tape with an OS backup. Be aware that if you loose the > backup disk before the tape is created, you will lose your backup. > > --EEM > > > > -----Original Message----- > > From: Gentian Hila [mailto:genti.tech@gmail.com] > > Sent: Tuesday, May 24, 2005 3:46 PM > > To: informix-list@iiug.org > > Subject: ontape on hard drive - Could not write archive tape > > > > I configured the onconfig file (Informix 9.40 on redhat ES 3 ) with > > the following parameters so it can backup on hard drive: > > > > TAPEDEV /tape # Tape device path > > TAPEBLK 1024 # Tape block size (Kbytes) > > TAPESIZE 230000000 # Maximum amount of data to put on > > tape (Kbytes)> > > > # Log Archive Tape Device > > > > LTAPEDEV /logtape # Log tape device path > > LTAPEBLK 1024 # Log tape block size (Kbytes) > > LTAPESIZE 230000000 # Max amount of data to put on log > > tape (Kbytes)> > > > I am not a DBA but network administrator so I have to take care of the > > Informix backup but as you can tell I do not know too much about > > Informix. > > > > I was trying to run otape -s manually > > then entering level 0 when it asked > > > > but that ask me to mount a tape and press Return. > > > > I hit return but here is all I get: > > Could not write archive tape. and then asks again: Please mount tape 1 > > on /tape and press Return to continue. > > > > Actually the two directories which are actually hard drives mounted on > > these directories. I made sure informix and root have write > > permissions in there. Actually at a certain point I gave, owner, group > > and others write permissions. > > > > WHat am I doing wrong ? > > > > I exported INFORMIXDIR=/apps/informix/9.40 which the informix > directory > > > > $INFORMIXSERVER=dbserver1_shm (found from ONCONFIG file > > =/apps/informix/9.40/etc/onconfig.dbserver1) This information was > > given to me from the people who installed the db. > > > > Please help me to backup archives and logical logs on disk. > > > > Any suggestion is welcomed. > > > > Genti > > > > sending to informix-list > > sending to informix-list > sending to informix-list