URGENT : Recovery of production DB
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: URGENT : Recovery of production DB

  1. #1
    Join Date
    Jul 2000
    Posts
    37
    Help, please.

    I had to restore 3 datafiles from a backup of 2 nights ago. These files were full, and are mostly only written to, not updated, deleted etc. I was short on disk space, so I took the files offline, but this didn't free up the disk space, so I shut down the database (this freed up the disk space.) I then restored the three files from the backup, and applied the archived redologs, and opened the database. Now, the three recovered .dbfs still say in the status of v$datafile "RECOVER"

    Why should I need to do this. please help if you can, it's a production DB

    cheers

    chris.

  2. #2
    Join Date
    Oct 2000
    Posts
    90
    Hey chris,
    I an sorry I can't help you. Any way if it's a production database, why wait? Call Oracle Support for help

  3. #3
    Join Date
    Mar 2000
    Location
    Sydney
    Posts
    9
    Put the datafile offline and get rid of them at OS level and do a fresh restore. When you recover the database, mention to which thread you want to recover to.

    I mean
    RECOVER DATABASE UNTIL arc.5465;

    Hope this helps.
    GK

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