1

I have an Oracle 10g database.

Unfortunately, our machine and system crashed and all the backups and Oracle archive logs, but we have old image copies of our data files and one of the control file (copy & paste)

How can I restore our database from these copies?

I tried to create a new database and replace the old files with new files, but I couldn't (I got message, we need to open the database with resetlogs, but we can't open it if we didn't make incomplete recovery)

Please help me

2
  • 2
    This is not an SO question. Try asking for help on Database Administrators
    – Mike W
    Oct 3, 2013 at 22:21
  • If you, at some point in the past, have had copied all the relevant files while the database was shutdown, it surely wouldn't complain about resetlogs. Since it does complain, either you didn't restore all the relevant files, or the files are corrupted. My first guess is that the files were copied while modified, hence they are inconsistent, hence you have no backup to restore.
    – kubanczyk
    Oct 4, 2013 at 22:16

1 Answer 1

1

Try to "recover until SCN..." before doing "open resetlogs".

You'll need the online redo logs to perform this (not clear from your question whether you have them or not)

4
  • thanks for replay, but how I can execute this command (I don't have any database, I have the old files only), have I to create new database? if "Yse" how I can assigne the old redo logs file to the new database? Oct 5, 2013 at 14:41
  • You should be able to execute this at the point where you were typing ´open resetlogs´. Recover until SCN would do the incomplete recovery...
    – hal9000
    Oct 7, 2013 at 13:36
  • I can't make recover until SCN, becz I don't have archivelog files Oct 9, 2013 at 9:19
  • You'll need the online Redo logs and the SCN of the last checkpoint to recover until SCN.
    – hal9000
    Oct 9, 2013 at 12:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.