Maintaing the archieve log [message #306171] |
Thu, 13 March 2008 02:12 |
someswar1
Messages: 53 Registered: January 2008
|
Member |
|
|
Hi ,
I am new in Dba.So Can any one help me If I setup my databasesize 5 Gb. I am using the database in archivelog mode.If daily 7oomb data will come and some is update and some deleted daily. In 30 days later the total data size is approx 21 gb. So how can I manage/setup the archivelog in oracle 10g. please help.
Thanks & Regards
Someswar
|
|
|
Re: Maintaing the archieve log [message #306243 is a reply to message #306171] |
Thu, 13 March 2008 07:23 |
|
Mahesh Rajendran
Messages: 10708 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
The exact number / volume of archives generated depends on activity on the database.
A database of the size 21g is pretty minuscule. Depending on your backup strategy / local retention of archive logs, you can just back them up and remove the older ones.
|
|
|