Hi Guys,

We have database of 200GB.
We are taking hotbackup using scipts on tape.
Hotbackup starts every night and take back up of all tablespaces and archive logs.
there are appox. 6-8 archive logs of 100 mb each.

I would like to know how many days archive we should keep in our archive_log destination. Currently we are keeping last 3 days.
Also can someone highlight on how offen we should do log swith? Currently it is daily 1-2 times in one of the database and few other database it is 1 hour.

My concer in about a databse where i have log switch once or twice a day which has 100mb redo log.

Your opinion will be highly appericiated.

Thanks and regards,
RBP