-
Archivelog
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,
Pedro Valiati - Brasil
-
-
Re: Archivelog
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?
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
Dear,
You can manually delete those file through OS command.
Sunil Bhutani
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.
Pedro Valiati - Brasil
-
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.
Amar
"There is a difference between knowing the path and walking the path."
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|