Archivelog

[pvaliati]

Hi everyboby! I was checking an Oracle 9i Database when I saw that It has 345 files with .arc extension (archivelog files), some of then 3 months old. How can I delete then if my backups are ok? Where can I set a retention time for then?
Since now Thanks,

[marist89]

Read this twice and then re-ask your question. http://download-west.oracle.com/docs...a96519/toc.htm

[julian]

Originally posted by pvaliati
Hi everyboby! I was checking an Oracle 9i Database when I saw that It has 345 files with .arc extension (archivelog files), some of then 3 months old. How can I delete then if my backups are ok? Where can I set a retention time for then?
Since now Thanks,

What do you mean by " ow can I delete then if my backups are ok?" :-))

OK how?

[Sunil Bhutani]

Dear,

You can manually delete those file through OS command.

Sunil Bhutani

[pvaliati]

Hi,
Is there necessary to shutdown the database? Is there a configuration to automatically delete these old old archivelog?
Thanks for the anwser Sunil.
Since now thanks. Pedro Valiati.

[adewri]

Originally posted by pvaliati
Hi,
Is there necessary to shutdown the database? Is there a configuration to automatically delete these old old archivelog?
Thanks for the anwser Sunil.
Since now thanks. Pedro Valiati.

I would rather suggest u to copy those files to tape. Make sure copy was successful and then delete if you want to.

Read the backup and recovery manual, u will need those files to recover ur database in case of a crash and how many of them are needed will depend on the backup.

Read the manuals "Backup and Recovery". The link has been provided by Jeff.