disaster recovery
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: disaster recovery

  1. #1
    Join Date
    Nov 2000
    Posts
    440

    disaster recovery

    At my client site:
    One of his disk went down on a raid 4, the raid reconstruct the disk or what ever its supose to do when a disk goes down.(i dont know that much hardware)

    Now when i start the database, i have :
    ORA-01122: database file 1 failed verification check
    ORA-01110: data file 1: 'C:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF'
    ORA-01207: file is more recent than controlfile - old controlfile

    If i check the dates of my 2 control files, they seem fine, but oracle dont see it that way, anyways, now i have to recover from backup. Il be ok in 1 hour. But the real problem is the following.

    One of the major reason to have a raid configuration, is that if a disk goes down, the raid reconstruct the failed disk and life goes on right?
    But then its does something to my oracle files and when i try to startup the database, its says my files are srewed.

    If someone has links or info on how to configure raid so it wont mess my oracle files, please dont hesitate.

  2. #2
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Ok, you may try something like this

    Shutdown
    Startup Mount
    Alter database backup controlfile to trace;

    use the create contole file statement(generated in trace file) and for all datafiles, logfiles use REUSE command.

    Shutdown
    Startup nomount
    Run Create ControlFile statement
    OPEN DB

    I think this should work..

    before this make sure you have offline backup of all DB files.

    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"

  3. #3
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    pure guessing:
    this storage of yours probably has some sort of write cache. I think it's possible that cache was not completely cleaned out on the disk prior to failure, so you've got some previous state of control files together with succesfully updated state of datafiles.
    Tomaž
    "A common mistake that people make when trying to design something completely
    foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams

  4. #4
    Join Date
    Nov 2000
    Posts
    440
    Good observation, so what raid configuration would be ok so when one disk failed, i dont have that
    ORA-01122: database file 1 failed verification check
    ORA-01110: data file 1: 'C:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF'
    ORA-01207: file is more recent than controlfile - old controlfile



    I know my raid 0 + 1 would be cool cuse the appication is write intensive. With no cache?

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Because of this very reason, I prefer to place one of my control files on the local disk and two somewhere on the RAID (different controllers). In fact, during the power outage last week this saved my A** for three databases.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  6. #6
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    since your raid is probably not failing every day, you can as well do some recovery "once in few years". that's why you have backups, right?
    Tomaž
    "A common mistake that people make when trying to design something completely
    foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams

  7. #7
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Did you have sparesets available in the array when the disk failed?
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  8. #8
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Originally posted by SANJAY_G
    Did you have sparesets available in the array when the disk failed?
    absolutely, but the spares don't kick in when the power goes out.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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