OraFAQ Forum: Server Administration » deleting old archive log files..!

Home » RDBMS Server » Server Administration » deleting old archive log files..!

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

deleting old archive log files..! [message #131361]

Fri, 05 August 2005 09:55

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

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

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

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 09:07:46 CST 2025