DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: HELP..No alert log info is being recorded!!

  1. #1
    Join Date
    Feb 2001
    Posts
    99
    Okay, We took the system down for cold backups yesterday. had a slight problem with shutting down. Ended up having to kill the services. I did a startup and shutdown again just to make sure I got a clean close on the system. Backups were done and system brought back up, users logged in. All appears well.

    I came in this morning to look at my alert log to view the errors from the shutdown and found that NOTHING is being written to my alert log. The startup/shutdown and then the startup for the users was not in there, no checkpointing info, no hot backup info....nada.

    Logs are switching and all appears right in the user world.

    HOW can I get this loggin again? Is there a flag to check? Nothing was changed in my init file.

    ARRGHHH>

  2. #2
    Join Date
    Feb 2001
    Posts
    99
    Okay..more info now.

    I have found where my alert file is now. It is in the rdbms73\trace directory. Thats not where it was when the system was shutdown, but on reboot, it is now there. Still checking out why....

    Any thoughts.?

  3. #3
    Join Date
    Apr 2002
    Posts
    61
    Check your init file for the parameter background_dump_dest; this where your alert log should appear unless otherwise you run out space at the above specified location.


  4. #4
    Join Date
    Feb 2001
    Posts
    99
    my first thought as well. Checked my inti.ora and did the Show Parameter in sqlplus. Both gave me the location where I wanted the files to go.

    No space issue...got 21gigs left


  5. #5
    Join Date
    Oct 2000
    Location
    Charlotte, USA
    Posts
    330
    Check the (alert log located) disc condn...whether monted or unmounted...If it is unmounted it will go to default location...?.
    If so mount the disc and try to stop /start you will see the writing in alert log.
    Thanks.
    Thanigaivasan.

  6. #6
    Join Date
    Feb 2001
    Posts
    99
    we are running in a Windows NT environment. Disc appears fine. I can access the disk from my workstation. In fact, just cleared out a bunch of archive logs for 3 mths back that were on that disk.

  7. #7
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    If you could, just rename the old alert.log file and restart the database. Anytime was the only solution for me.

    Cheers

    Angel

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