DBAsupport.com Forums - Powered by vBulletin
Page 2 of 4 FirstFirst 1234 LastLast
Results 11 to 20 of 38

Thread: Instance crashes

  1. 06-12-2006, 04:09 PM #11
    matthew00
    matthew00 is offline Member
    Join Date
    Mar 2006
    Posts
    176
    I was going to say, your back or third party software. Basically, you have some processes that tried to access to the controlfiles and the controlfiles was updated at the same time, the file locked up so the DB crashed.
    Reply With Quote Reply With Quote
  2. 06-12-2006, 04:47 PM #12
    Mr.Hanky's Avatar
    Mr.Hanky
    Mr.Hanky is offline X-Mas poo
    Join Date
    Jan 2001
    Posts
    3,134
    Quote Originally Posted by Eberman
    We use RMAN for backup (hot backup), However I find out today that we use TSM software to backup UNIX server. It does backup of Oracle home directory which is on /u01/app.. Could this caused this errors? Should I stop this back up job?

    Eugene.
    Are you in charge of the OS or does you shop have a sytem admin for that.

    It would seem strange that something that has been running with no problems would suddenly start spitting out errors. Has anything changed on the backup for the OS?

    Can you just skip the control file mount points without cancelling the entire backup?
    I remember when this place was cool.
    Reply With Quote Reply With Quote
  3. 06-13-2006, 05:39 AM #13
    KenCunningham
    KenCunningham is offline Member
    Join Date
    Apr 2003
    Location
    Gourock, Scotland
    Posts
    102
    If your controlfile is in the /u05/oracle filesystem and you're just backing up /u01/app, I doubt it. What time is the backup scheduled?
    If I have to choose between two evils, I always like to choose the one I haven't tried yet.
    Reply With Quote Reply With Quote
  4. 06-13-2006, 07:46 AM #14
    Eberman
    Eberman is offline Junior Member
    Join Date
    Nov 2000
    Posts
    57
    Backup Between 5 and AM. Happend this morning again. Even without OS Backup (we removed it from Scheduler)

    Also once I restart Oracke everything works Ok and this control file is being updated fine. Until 5 AM?!

    Eugene.
    Reply With Quote Reply With Quote
  5. 06-13-2006, 10:40 AM #15
    ixion
    ixion is offline Senior Member
    Join Date
    Jun 2006
    Posts
    259
    Eugene,

    Its unlikely that your backup software is causing this. You don't really need to backup the Oracle control files as part of the OS backup. These are part of the DB.

    This sounds like an oracle bug. What version of oracle?
    I'd file a bug with Oracle.


    Ken
    Last edited by ixion; 06-13-2006 at 10:43 AM.
    Reply With Quote Reply With Quote
  6. 06-13-2006, 10:47 AM #16
    abhaysk's Avatar
    abhaysk
    abhaysk is offline Krishna
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Not really a bug.. we faced the write errors on some of the datafiles and was due to the space on that mount point being full.


    Check the free space


    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
    Reply With Quote Reply With Quote
  7. 06-13-2006, 10:47 AM #17
    Eberman
    Eberman is offline Junior Member
    Join Date
    Nov 2000
    Posts
    57
    Oracle version is 10.1.0.3.0

    I opened SR with Oracle and they suggest to download Remote Diagnostic Agent and run and then send output report to them

    E.
    Reply With Quote Reply With Quote
  8. 06-13-2006, 10:51 AM #18
    Mr.Hanky's Avatar
    Mr.Hanky
    Mr.Hanky is offline X-Mas poo
    Join Date
    Jan 2001
    Posts
    3,134
    Quote Originally Posted by abhaysk
    Not really a bug.. we faced the write errors on some of the datafiles and was due to the space on that mount point being full.

    Check the free space
    Abhay.
    We are thinking along the same lines but when it happens at the same time every day it should not be free space, although it is certainly worth investigating.

    You know, it could be that they are running a batch file that is blowing up that mount point at the same time every day. Where do you have your TEMP and UNDO files located?
    Cause if they swell up during a batch job, that could cause the error. Then by the time you get in they shrink down and everything looks fine.
    I remember when this place was cool.
    Reply With Quote Reply With Quote
  9. 06-13-2006, 10:52 AM #19
    ixion
    ixion is offline Senior Member
    Join Date
    Jun 2006
    Posts
    259
    Quote Originally Posted by abhaysk
    Not really a bug.. we faced the write errors on some of the datafiles and was due to the space on that mount point being full.


    Check the free space


    Abhay.
    Ahh,

    But then you'd get errors in your OS messages saying your file system was full. And you'd get a different error in your alert log. He had no OS messages.
    Reply With Quote Reply With Quote
  10. 06-13-2006, 10:56 AM #20
    Eberman
    Eberman is offline Junior Member
    Join Date
    Nov 2000
    Posts
    57
    The only space issue we found on Oracle Home drive. It was 85% full. We just cleaned up to 50%.

    However control file drive has plenty of space

    E.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width