Recovery
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: Recovery

  1. #1
    Join Date
    May 2002
    Posts
    15
    IS recovery possible if I have control file and and data files.

    If yes, how?

    Thanks

  2. #2
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    In what mode was database before:
    ARCHIVELOG or NOARCHIVELOG ?
    and than
    Do u have list of all redo log files, that u lost?

  3. #3
    Join Date
    May 2002
    Posts
    15
    Database was not in Archive mod.

    My hard drive died but I was able to recover control file and data files.

    Basicaly, nothing is lost.

    Now I have new hard drive and I want to create the sane DB as on the old one.

  4. #4
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    What about redo log files - this is very important in this case.

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    your database was open when disk crashed?
    if so without redo logs say byebye to your database

    good luck

  6. #6
    Join Date
    May 2002
    Posts
    15
    I do not have Redo Log Files but I think I don't need them because everything was saved in data files.

    At the moment when my hard drive died, Oracle was not started, so there is no data lost

  7. #7
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    if the database was not open then simplt mount the database and then open the database with resetlogs option (make sure the datafile/redologs PATHs are there

  8. #8
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    In that case your database needs no recovery at all, so the subject line of this thread is misnomer .

    Having all datafiles and controlfile is all you need in this case, no recovery will be needed, all you'll have to do is to recreate your redo log files before opening your database.

    Provided of course that your database was shut down cleanly before the disk crash happened.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  9. #9
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    resetlogs recreates redo logs though

  10. #10
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by pando
    resetlogs recreates redo logs though
    That's one of the options that I had in mind when I said "you'll have to do is to recreate your redo log files before opening your database". Although the command is "ALTER DATABASE OPEN RESETLOGS", you are actually creating new (or overwriting existing ones) redo logs *before* you open the database.

    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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