Hi,
Please tell me the way how can i archive my log files ? i guess its with archive command ..but on what basis should i archive them ??how many log files will go will it effect to users connected to the database or it should taken in a offline mode
my log files are of 100 gb now ..
Q1.what should be the strategy to archive the log files ? ?

Q2.also i am storing my log files on the system and data on the SAN box is it the correct way to be done !??

Q3.my databases have grown to 300 gb is it possible somewhere to reduce the size ? i mean data be compressed ? ?

you can archive to disk/tape/tsm
why such large log files - it will take long time to copy and if a crash occured, much data can be lost
make smaller log files - like 10M each
archive is asynch as occures when an active log file is closed
table compressing is possible in v9

thanks for the reply ! !
when i say its 100 gb means it means in total size of the log files ..not a single log file .
but if i archive them ..will the database will be effected ? and do i need them in case i am doing a restore ?
also please answer my question regarding log on hard disk and data on SAN box .