RE: alert log file
just backup it ( cp alertDBSID.log backupalert.old) and empty it (echo /dev/null alertDBSID.log) no need to bounce DB rui -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Monday, March 31, 2003 4:54 PMTo: Multiple recipients of list ORACLE-LSubject: alert log file for one of the db over here alert log is biggg .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
RE: alert log file
Title: Message 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-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of AKSent: Monday, March 31, 2003 7:54 AMTo: Multiple recipients of list ORACLE-LSubject: alert log file for one of the db over here alert log is biggg .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
RE: alert log file
You can rename the alert log or move it. Oracle will create a new one the next time it has to write to it. You don't need to bounce the DB. Dave -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Monday, March 31, 2003 9:54 AMTo: Multiple recipients of list ORACLE-LSubject: alert log file for one of the db over here alert log is biggg .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
Re: alert log file
rename it, Oracle will create a new alert log file when it needs to write to the alert log again --- AK [EMAIL PROTECTED] wrote: for one of the db over here alert log is biggg .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 __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: alert log file
If you move the alert log to another directory, Oracle will create a new one in its place. There is no need to bounce the DB. -Scott At 07:54 AM 3/31/03 -0800, you wrote: for one of the db over here alert log is biggg .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 ** Scott Stefick Systems / Oracle Certified DBA Wm. Rainey Harper College 847.925.6130 **
Re: alert log file
Copy the alert log to the desired location and then CAT /dev/null into the alert log. CAT /dev/null alert.log This will zero out the alert log and allow you to keep the old data. Ron [EMAIL PROTECTED] 03/31/03 10:53AM for one of the db over here alert log is biggg .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: Ron Rogers INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: alert log file
When I see a humungous file like that, I build a little ksh script that hasn't failed me yet. suffix=`date +%y%m%d` cp -p alertSID.log alertSID_${suffix}.log alertSID.log The only thing that might happen is if Oracle is updating the log file at EXACTLY the moment you execute this script then that log line may be lost. As I said, it hasn't happened - yet - that I know of - but YMMV. Cheers, Mike -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Monday, March 31, 2003 7:54 AMTo: Multiple recipients of list ORACLE-LSubject: alert log file for one of the db over here alert log is biggg .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
RE: alert log file
Title: RE: alert log file We compress ours which makes them much smaller for storage. Oracle will create a new alert log file and there is no need to bounce the db. Jerry Whittle ASIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: AK [SMTP:[EMAIL PROTECTED] for one of the db over here alert log is biggg .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
Re: alert log file
thanks, - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, March 31, 2003 8:53 AM rename it, Oracle will create a new alert log file when it needs to write to the alert log again --- AK [EMAIL PROTECTED] wrote: for one of the db over here alert log is biggg .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 __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: AK INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).