Home » RDBMS Server » Server Administration » switching alert.log while db is up
switching alert.log while db is up [message #49875] Fri, 15 February 2002 00:06 Go to next message
Holger
Messages: 7
Registered: February 2002
Junior Member
Hi,

I'd like to force oracle to start with an new alert.log and put the old one on storage.
So I think there must be a possibility to trigger this event by sql?!

Where could I find where the mark is set when to switch the log?

The other way to get rid of the old alert.log could be to move it by OS-instructions and touch a new one. Could I do that without to harm the running database?

thx for help
Holger

Report message to a moderator

Re: switching alert.log while db is up [message #49879 is a reply to message #49875] Fri, 15 February 2002 03:38 Go to previous messageGo to next message
tommy
Messages: 22
Registered: July 2000
Junior Member
To switch the alert log, rename old one or move it to new location and the database will automagically create a new one the next time it writes to the alert log.

Report message to a moderator

Re: switching alert.log while db is up [message #49882 is a reply to message #49875] Fri, 15 February 2002 05:09 Go to previous message
Holger
Messages: 7
Registered: February 2002
Junior Member
Fine. I asked because I was not sure that it wouldn't harm the living database.

thx
Holger

Report message to a moderator

Previous Topic: Re: CAN U PLZ TELL ME FULL FORM OF ORACLE
Next Topic: Export-Import Oracle from Unix to Windows 2000
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jan 11 17:12:02 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.