Delete Old archive log- URGENT
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Delete Old archive log- URGENT

  1. #1
    Join Date
    Jul 2001
    Posts
    45
    Hi all,
    Database is hanging error message
    check alert log

    [Edited by richardana on 11-20-2001 at 01:31 PM]

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    As long as they have been backed up, sure, delete them.
    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
    Jul 2001
    Posts
    45

    Prevention is better than cure.
    Thanks

    [Edited by richardana on 11-20-2001 at 01:31 PM]

  4. #4
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    to be very sure for recovery sake,
    just delete the archive log not later than the last offline backup.

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by richardana
    How ? this is my first time and I do not want screw anything
    Please give me an example of how. I know it sounds stupid but prevention is better than cure
    Thanks
    You can delete them with an OS command. For example, on unix, you can:
    find /u01/oraarch/mysid/ -mtime +1 -exec rm -f {} \;
    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."

  6. #6
    Join Date
    Oct 2001
    Posts
    83
    Hello,

    I you are not sure about backup, you can also look for free space in your machine and move some archivelog files to this new location.

    Hope this helps

    Regards

  7. #7
    Join Date
    Jul 2001
    Posts
    45
    Thanks to all of you

  8. #8
    Join Date
    May 2001
    Location
    Delhi
    Posts
    340

    Logs

    Yeah, you can delete logs after you have taken backup.

    Like in my case i take online backup of my database and archive log backup and delete the archived logs..
    --------------------------
    The Time has come ....

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