Home » RDBMS Server » Server Administration » deleting old archive log files..!
deleting old archive log files..! [message #131361] Fri, 05 August 2005 09:55 Go to next message
balavignesh
Messages: 180
Registered: March 2005
Senior Member
hai,

we have written a shell script to delete old archived log files that is older that recent 60 days and executed the same to avoid archiver error. is it ok to delete old archived logs older than recent 60 days..?plz suggest.

regards
bala

Report message to a moderator

Re: deleting old archive log files..! [message #131363 is a reply to message #131361] Fri, 05 August 2005 09:58 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
It is ok to delete old archivelogs.
But, why 60 days??!!.
and are you backing all these everyday? again and again?.

Report message to a moderator

Re: deleting old archive log files..! [message #131364 is a reply to message #131361] Fri, 05 August 2005 10:01 Go to previous messageGo to next message
balavignesh
Messages: 180
Registered: March 2005
Senior Member
hai mahesh,

thanks for ur response.

we are not taking daily backup of the archived log files.in that case , how many days beyond shall we delete those files..?i.e instead of 60 what is advisable..?

bala

Report message to a moderator

Re: deleting old archive log files..! [message #131366 is a reply to message #131364] Fri, 05 August 2005 10:14 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Depends on your local retention policy.

EveryTime you backup the database, always backup archived logs also. A good backup should always have datafiles,archivedlogs,controlfile and spfile.
This backupset(s) all will go under one tag something like backup_taken_on_that_day.

Once backup is done, you can remove all the archived logs ( that are backed up).
If your backuppolicy is to retain atleast 3 backups locally,
then all you need is to have 3 sets of backups locally. THe rest can be removed. (to be in safer side, you can have all the archived logs that are created between these 3 backups locally, and rest can be removed. BUt this is just redundant, as your RMAN backups already have these archivedlogs).

>>.?i.e instead of 60 what is advisable..?
THere is no standard policy here.
If you can afford to have all archived logs locally have it!.

Report message to a moderator

Re: deleting old archive log files..! [message #131367 is a reply to message #131366] Fri, 05 August 2005 10:24 Go to previous message
balavignesh
Messages: 180
Registered: March 2005
Senior Member
hai mahesh,

thanks a lot...!

bala

Report message to a moderator

Previous Topic: what is the tool to read exp file
Next Topic: Remote login works even without password file
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Feb 13 13:56:25 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.