Printable View
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,
Read this twice and then re-ask your question. http://download-west.oracle.com/docs...a96519/toc.htm
What do you mean by " ow can I delete then if my backups are ok?" :-))Quote:
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,
OK how?
Dear,
You can manually delete those file through OS command.
Sunil Bhutani
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.Quote:
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.
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.