RECOVERY!!! URGENT!!! TAMIL,PANDO and EVERYBODY join !!!
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: RECOVERY!!! URGENT!!! TAMIL,PANDO and EVERYBODY join !!!

  1. #1
    Join Date
    Aug 2000
    Posts
    87

    HI All,

    VERSION 8.0.6 oracle running in Archive Mode.

    Its Urgent my production system has some probs.....I will tell the the situation,,,first my junior dba added a datafile to a tablespace and which lead to the status of the datafile in RECOVER Mode....So what he did is ,,he gave a statement to Recover the datafile

    Recover datafile '/path'

    While it what recovering he cancled it seems...

    So after that he called me and now i used the give the RECOVER DATAFILE '/path' which leads to error saying cancled during Recovery and its no not recovering it.

    and what i didnt is gave alter database datafile 'path' offline drop.

    and checked the status in the v$datafile but still it is RECOVER mode.

    So i took the control file back and removed the entry of the newly added datafile and RECREATE the control file with RESETLOGS.

    Then now i checked the status of the datafile and found its '/path/Missing00066'

    Then i gave alter database RENAME file '/path/MISSING00066' to the old '/path'

    But the entry in the datafile got changed from MISSING00066 to the path and the file name i gave.....but still the datafile is in RECOVER mode...Please Let me know the solution...ITS VERY VERY URGENT.

    Thanks & Regards,
    Vinod Kumar.

  2. #2
    Join Date
    Nov 1999
    Location
    Elbert, Colorado, USA
    Posts
    81
    Vinod -
    This is a long shot, but have you tried
    ALTER DATABASE RECOVER CANCEL;

    This might kill all recovery operations and allow you to drop the file.

  3. #3
    Join Date
    Aug 2000
    Posts
    87

    Hi,
    No i havent tried that....Since the control file has been recreated with RESETLOGS.I cant use that command.

    RECOVER DATABASE UNTIL CANCEL.


  4. #4
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    Best Way is if you can down the database, restore the previous day's backup. Recover it and apply all redo logs till just before the new datafile is added.

    I had the same situation and nothing worked and I finally had to restore the last night's database and aply the archive log file.

    Thanks
    Kishore Kumar

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    this is tricky, it hasnt happened to me in a real database but it did happen with a test database although the situation was a bit different, the problem I had was I changed the database structure by adding a datafile then the database crashed Since I didnt have any backup of the new datafile I came across with this problem of datafile being recover and missing00xx. The only way I could recover it was going back 1 day and applied the logs until just before I added the datafile with a backup controlfile as well.
    I conclude that whenever i change the database structure immediately I should make a cold backup...

  6. #6
    Join Date
    Aug 2000
    Posts
    87


    Hi All,
    See we have O/S backup of all the filesystem..Say if iam going to restore all the datafiles,controlfiles,Logfiles,Archives of the previous days backup...and if i start the database..will it come without any probs..May be i may lose todays transaction...but will i get at least data from yesterday nights.We have O/S backup of 29th night.

    Thanks and Regards.

  7. #7
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092

    Depends on if your backup was done with the database up or down.

    If the database was down, everything should come up OK.

    If the database was up, you still have a chance to restore.

    Either way, you can recover using a backup control file:
    1. copy the restored control file to the locations your original control files were located.
    2. start the database in mount mode
    3. recover the database using the backup controlfile (alter database recover until cancel using backup controlfile).
    4. keep applying archived redologs until just before the problem.
    5. alter database open resetlogs.

    (This procedure is outlined in note 69468.1 on metalink.oracle.com.)
    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."

  8. #8
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    If nothing is stored in the datafile, try to recreate the data file and do the recovery .

    After the control file was recreated, while opening the data base, did you get error message?

  9. #9
    Join Date
    Jul 2000
    Posts
    50
    If you can effort to loose data after last full backup(i.e 29 th nite backup), then you should restoreandrecover your database from that backup as mentioned by Kishore. Your DB will come without anyprobs.

    If you want to restore your DB just before the new data file, restore all the data files from 29th backup and recover the DB with current control file (not the control file that you created after the crash) with until cancel time(I hope you have all the archive logs) option.

    Good luck

    abhijit

  10. #10
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    You cannot use the current controlfile since the structure of the database changed from last backup.

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