DBAsupport.com Forums - Powered by vBulletin
Page 3 of 4 FirstFirst 1234 LastLast
Results 21 to 30 of 38

Thread: Instance crashes

  1. 06-13-2006, 10:59 AM #21
    ixion
    ixion is offline Senior Member
    Join Date
    Jun 2006
    Posts
    259
    Eugene,
    what is your hardware configuration on the disk where the control file is stored?
    What is you fs type and mounting options?
    Reply With Quote Reply With Quote
  2. 06-13-2006, 11:03 AM #22
    abhaysk's Avatar
    abhaysk
    abhaysk is offline Krishna
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Well any n/w outages at 5am daily?.. and that ur control file is remote to the server?
    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
  3. 06-13-2006, 11:15 AM #23
    Eberman
    Eberman is offline Junior Member
    Join Date
    Nov 2000
    Posts
    57
    Hardware config:

    aix- jsf2
    all oracle filessystems are mirroed
    /dev/u03lv -- /u03 jfs2 125829120 rbr,rbw,dio,rw no no

    Also no network issues.

    Would UNIX Server reboot solve this issue? We had not reboot this box for long time

    E.
    Reply With Quote Reply With Quote
  4. 06-13-2006, 12:34 PM #24
    ixion
    ixion is offline Senior Member
    Join Date
    Jun 2006
    Posts
    259
    A reboot probably won't help, but it wouldn't hurt either. Plus if there are hardware issues the startup diagnostics should help pick these up. The startup FSCK should also pick up any file system issues. Its worth a try.

    What is the storage device? How is it attached? IS it an EMC or some other SAN?
    Can you relocate control03 to say an internal disk (temporarily)?

    Just a thought. I wonder if you're getting intermittent write errors on the mirrored device? hardware mirroring or software?
    Reply With Quote Reply With Quote
  5. 06-13-2006, 01:54 PM #25
    Eberman
    Eberman is offline Junior Member
    Join Date
    Nov 2000
    Posts
    57
    All I know its an ibm fast-t900

    We will reboot Unix Server at night time and I will move control files just like suggested yesterday. See if it helps us.

    Eugene.
    Reply With Quote Reply With Quote
  6. 06-13-2006, 03:12 PM #26
    ixion
    ixion is offline Senior Member
    Join Date
    Jun 2006
    Posts
    259
    Eugene..

    I looked. The hardware supports internal mirroring. It is a FCAL (fibre chanel arbitrated loop) device. There are basically two connections to each physical drive on seperate loops.

    I'd get you sys admin too look and see if there are any hardware errors and run diagnostics on this as well during your reboot/downtime.

    Is this located on site? I once had a strange problem with db crashing. The cleaning personel were unplugging the disk subsystem to plug in their vacum.
    Reply With Quote Reply With Quote
  7. 06-14-2006, 03:00 AM #27
    Thomasps
    Thomasps is offline Advisor
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    But, why the crash is happeneing only at 5AM..? If there is any general H/w issue, the DB can crash at any point not restricted to 5AM?
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/
    Reply With Quote Reply With Quote
  8. 06-14-2006, 12:28 PM #28
    Eberman
    Eberman is offline Junior Member
    Join Date
    Nov 2000
    Posts
    57
    Last nigth we stop Unix server OS backup and stop RMAN backup as well. No downtime!!

    We will bring back RMAN only to see if this Unix Server OS backup casing trouble.

    Eugene
    Reply With Quote Reply With Quote
  9. 06-14-2006, 01:14 PM #29
    ixion
    ixion is offline Senior Member
    Join Date
    Jun 2006
    Posts
    259
    There You go... Its one of those then. Process of elimination from here out.

    Let us know which one caused the problem.
    Ken
    Reply With Quote Reply With Quote
  10. 06-18-2006, 03:49 AM #30
    nguyenjl
    nguyenjl is offline Junior Member
    Join Date
    Jun 2006
    Posts
    5
    first mount the db and issue an recover automatic database may solve the problem if not recreate the controlfile ..I think you know the rest.
    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