-
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
-
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"
-
Clean your file and try this :
SQL> execute sys.dbms_system.ksdwrt(2,to_char(sysdate)|| ' I have just create a new file.');
Giani
-
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
-
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
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|