Error Cloning 9i Database 1

[DrSeussFreak]

I just cloned my database, I am now working on the recovery of it, when I use the following command, it goes into an infinite recovery look (keeps asking for more recovery)

RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;

Once I run

ALTER DATABASE OPEN RESETLOGS;

The oracle error code I receive is

ORA-01113

Thanks in advance

 

[karluk]

How many archive logs did you apply before entering cancel? You have to apply at least one archive log to an online backup to make the database files consistent. If you didn't apply any at all, you could very well get this type of "file ... needs media recovery" error.

 

[DrSeussFreak]

There is really only 1 archive log I need it to pull from, but I am recovering from 2. Even after that though, when I open it, it keeps asking for another log, which does not exist

 

[karluk]

Your symptoms sound as if you have at least one data file in your clone that is more recent than the point where you cancel the recovery. That would force all of the other data files to be brought up to the same point in time in order to have a consistent database. That could cause your ORA-01113 error.

 

[DrSeussFreak]

I was thinking it was the syntax. Any thoughts?

 

[karluk]

I noticed the syntax possibility that yesterday, but I never got around to running a test, so I didn't mention it. I always put the "until cancel" clause before the "using backup controlfile" clause. I'm not sure if Oracle syntax is flexible enough to accept these clauses in any order. I suppose it's possible that putting the "until cancel" clause out of order might cause it to be ignored (although I would actually expect it to generate an ORA- error and fail completely). If it's ignored, that might explain the symptoms you're seeing of getting endlessly prompted to do more recovery.

In any case it would probably be worth your while to run a test with the clauses switched around and see if it makes a difference.

 

[DrSeussFreak]

I actually just finished this, and it worked perfectly, thanks a lot!