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

Quote:

---

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.

Clean your file and try this :

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

:D

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

Quote:

---

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

---

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.

Marist, You won:D