how to clean up alert_SID.log File ?

[vr76413]

hello all

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

Thanks
Ron

[abhaysk]

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.

[Giani]

Clean your file and try this :

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

[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

[marist89]

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

mv alert.log alert.log.old; touch alert.log

[Giani]

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