Archivelog
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Archivelog

  1. #1
    Join Date
    Nov 2003
    Location
    Brasil -
    Posts
    16

    Question 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

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Read this twice and then re-ask your question. http://download-west.oracle.com/docs...a96519/toc.htm
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    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

  4. #4
    Join Date
    Nov 2003
    Posts
    5
    Dear,

    You can manually delete those file through OS command.

    Sunil Bhutani
    Sunil Bhutani

  5. #5
    Join Date
    Nov 2003
    Location
    Brasil -
    Posts
    16
    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

  6. #6
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    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."

    Amar's Blog  Get Firefox!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width