how to clean up alert_SID.log File ?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: how to clean up alert_SID.log File ?

  1. #1
    Join Date
    Oct 2002
    Posts
    284

    how to clean up alert_SID.log File ?

    hello all

    My Laert_SID.log file is BIG one. How do i clean it up without bouncing the instance.

    Thanks
    Ron

  2. #2
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434

    Re: how to clean up alert_SID.log File ?

    Originally posted by vr76413
    hello all

    My Laert_SID.log file is BIG one. How do i clean it up without bouncing the instance.

    Thanks
    Ron
    Win?

    CONTORL X..and put it in some dumb file in other loc if u need histroy...and save.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  3. #3
    Join Date
    Nov 2002
    Location
    Dublin, Ireland
    Posts
    132
    Clean your file and try this :

    SQL> execute sys.dbms_system.ksdwrt(2,to_char(sysdate)|| ' I have just create a new file.');

    Giani

  4. #4
    Join Date
    Oct 2002
    Posts
    284
    no actually , its on Sun 5.8.

    If i move or delete the file from its current DEFAULT location, will ORacle create one if needed by itself ?

    thanks
    Ron

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Originally posted by vr76413
    no actually , its on Sun 5.8.

    If i move or delete the file from its current DEFAULT location, will ORacle create one if needed by itself ?

    thanks
    Ron
    sure, just

    Code:
    mv alert.log alert.log.old; touch alert.log
    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
    Nov 2002
    Location
    Dublin, Ireland
    Posts
    132
    yes oracle will create a new one.
    cd $ORACLE_BASE/admin/SID/bdump

    SQL> !cp alert_SID.log old_alert_SID.log

    SQL> !rm alert_SID.log

    SQL> execute sys.dbms_system.ksdwrt(2,to_char(sysdate)|| ' I have just create a new file.');


    PL/SQL procedure successfully completed.

    SQL> !cat alert_SID.log
    Fri Jun 20 17:08:37 2003
    20-JUN-03 I have just create a new file.
    Giani

  7. #7
    Join Date
    Nov 2002
    Location
    Dublin, Ireland
    Posts
    132
    Marist, You won
    Giani

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