Rename/Moving Alert Log.
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Rename/Moving Alert Log.

  1. #1
    Join Date
    Nov 2000
    Location
    Charlotte
    Posts
    88

    Question Rename/Moving Alert Log.

    I'm a newly apointed DBA at my job and the SR. DBA is out. Our alert logs are larger than we'd like to have them.

    Can I save off the current alter log by renaming it (to .old) while the database is up and running? Will Oracle create another alert log
    dynamically when it needs to if it doesn't exists?

    We are on a Solaris system running Oracle 8.0.6 and 8.1.7.


    Thanks,
    smoothyc

  2. #2
    Join Date
    Nov 2002
    Posts
    170
    I have tried this and it sure works. Rename the alert log and have a new alert.log file so that oracle can start writing to the blank file. I guess oracle p'bly would create a new one but to be in the safe side just have a blank file out there.

  3. #3
    Join Date
    Jul 2000
    Posts
    119
    Sure, you can, just rename it to something like filename.old. Oracle will create new alert file dynamically while instance is up.
    OCP 8.0, 8i, 9i

  4. #4
    Join Date
    Nov 2000
    Location
    Charlotte
    Posts
    88
    Thanks. I will rename it on our development box and if all goes well... onto production.

    Thanks again for all the help!

    smoothyc...

  5. #5
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    If you run Linux, do not try to rename or move trace files of background processes, you will not crush Oracle, but Oracle will keep file handle opened even if file does not exists anymore. In that situation all trace information will not be written, new trace files will not be created.
    Best wishes!
    Dmitri

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width