-
Archive log removing statergy
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|