redo logs or control file problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: redo logs or control file problem

  1. #1
    Join Date
    Jun 2007
    Posts
    4

    redo logs or control file problem

    Hi

    currently, i don't no what happened that redo logs or control files in our organization Database( 10g )are deleted and database is down.

    this event happend in a special time period for example ( each 2 weeks ).

    therefore I execute some command for giving back.

    please help me, so that this problem is a critical for my organization.

    Thanks alot.

  2. #2
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Any cron jobs running at that time, clearing any temp files? Check the time window and crontab.
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  3. #3
    Join Date
    Jun 2007
    Posts
    4

    redo log

    thanks a lot for your answer .

    i check this subject that view that results.

  4. #4
    Join Date
    Jun 2007
    Posts
    4
    which temp file must be deleted?

  5. #5
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Well, as this is happening in every two weeks, I expect some cron tab job kicked in, trying to clear some temp files and may be deleted your control files. This is just a possibility... By any means, Oracle cannot delete the control files automatically..

    Please don't ask what are those temp files
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  6. #6
    Join Date
    Jun 2007
    Posts
    4

    redo log or control files

    Hi

    thanks for your answer

    I have checked cron and there is no schedule task for this subject.

  7. #7
    Join Date
    Nov 2001
    Posts
    335
    Check root crontab and all other powerfull users crontab
    One, who thinks that the other one who thinks that know and does not know, does not know either!

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