RE: alert log file

No problems, just move it. No need to shutdown, Oracle will just create a new file next time it needs to write to it.  

Moving the alert log should be something you do on a regular basis.

Pete

"Controlling developers is like herding cats."

Kevin Loney, Oracle DBA Handbook

"Oh no, it's not. It's much harder than that!"

Bruce Pihlamae, long-term Oracle DBA  

-----Original Message-----
Sent: Monday, March 31, 2003 7:54 AM
To: Multiple recipients of list ORACLE-L

for one of the db over here alert log is biggggggg .Looks like its never been truncated or backup .
Is it a problem if i just move this alert log file to another directory , will oracle create a new alert log file ? Do I need to bounce db ?  

btw its 8.1.6 ( hp-ux )
-ak  

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Pete Sharman
  INET: peter.sharman_at_oracle.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).