If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > log file

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 12-18-07, 10:17
rorroja rorroja is offline
Registered User
 
Join Date: Dec 2007
Posts: 4
log file

Dear forum,
I need help. I have an instance that have many log archive generated by IDS since may of 2007.
I want delete this file, but without making a backup.
It is possible???
Thank a lot
R
Reply With Quote
  #2 (permalink)  
Old 12-18-07, 14:07
rorroja rorroja is offline
Registered User
 
Join Date: Dec 2007
Posts: 4
log file

Better;
Can I delete the log file form my IDS without making a logical-log backup?????
Pleas help me
Reply With Quote
  #3 (permalink)  
Old 12-18-07, 19:53
ceinma ceinma is offline
Registered User
 
Join Date: Apr 2007
Location: Jundiai / SP - Brasil
Posts: 311
I deduce you want to remove a logical-log, logs exhibit with command onstat -l, right?
If yes... you can remove with command "onparams -d -l <log_number>"
But with this command the log will marked with Delete flag, to complete the process you must execute a Physical Backup level 0 .

Now , if the problem is your logical logs are all without backup (flag B on onstat -l) , and you want to delete them... I think this is not possible...
You need execute a logical backup. If you do not have space on disk or tape to do this, alter you LTAPEDEV to /dev/null and execute ontape -a, or just link the file especified on the LTAPEDEV to /dev/null .
Exemple:
If your LTAPEDEV = /informix/archive/log/log.backup, remove this file and make the link: "ls -s /dev/null /informix/archive/log/log.backup"
execute the ontape -a
__________________
________________________________________
César Inacio Martins
Jundiai / SP - Brasil
http://www.imartins.com.br/informix - em Português
http://www.imartins.com.br/informix - English (translated by Google).
________________________________________
Reply With Quote
  #4 (permalink)  
Old 12-19-07, 13:47
rorroja rorroja is offline
Registered User
 
Join Date: Dec 2007
Posts: 4
Dear ceinma,
Thanks a lot for your answer.
I have an instance that have 80 logical log. This instance has produced 90 gb of logical log archives, since may. 2007. So. I need delete this files.
Questions:

1.- Can I delete this files without making a backup?
2.- If I make a backup, with ontape -a. How many space I need for the logical backup, if I have 90 gb of logical logs?

I hope that you understand my problem.
Reply With Quote
  #5 (permalink)  
Old 12-19-07, 14:14
rorroja rorroja is offline
Registered User
 
Join Date: Dec 2007
Posts: 4
Dear ceinma,
Better,
If I make a backup level 0 to dev/null, and then I delete all files that exist in the filesystem with the command rm *. I remember you, that this files isn't the logical log set in the onconfig, this files is produced every time that an logical log switch to other.
Reply With Quote
  #6 (permalink)  
Old 12-19-07, 14:32
ceinma ceinma is offline
Registered User
 
Join Date: Apr 2007
Location: Jundiai / SP - Brasil
Posts: 311
First, sorry my poor english..

Hum... I'm a bit confused ...

Well, lets start from zero..

1) What version of your IDS?
3) What configuration you have on LTAPEDEV and TAPEDEV ?
4) What exactly is this 90 GB of logical log archives? They are file on your file system?

To know how much size you will need to backup you Logical Log, just see the size column on the command "onstat -l ". But this is a pagesize, you must multiple to the page size of your IDS.

Just to explain some concepts...
- If you have your Physcal backup (TAPEDEV) to /dev/null , is useless save your Logical backup (LTAPEDEV). So, if your TAPEDEV = /dev/null, just set your LTAPEDEV = /dev/null too. (THIS WAY YOU DO NOT HAVE A BACKUP!)

- If you save your Logical Log (LTAPEDEV) to some file and TAPEDEV to another file and execute a Physical Backup Level 0 periodically : You always can delete the logical log files when execute a full Physical Backup Level 0/1/2 .
(this way you have a full backup with level 0 and incremental backup with level 1/2 plus Logical Log backup)
__________________
________________________________________
César Inacio Martins
Jundiai / SP - Brasil
http://www.imartins.com.br/informix - em Português
http://www.imartins.com.br/informix - English (translated by Google).
________________________________________
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On