Hopefully this was fixed last week but just in case the last time I had this problem I was able to resolve it by simply following the following stops: 1. recover database until cancel using backup controlfile; 2. cancel; While I had gotten that error after the auto apply of archive logs, manually cancelling it allowed me to do an open resetlogs. Jay Miller Sr. Oracle DBA x68355 ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Bobak, Mark Sent: Friday, April 13, 2007 2:16 PM To: rhojel.echano@xxxxxxxxx; paulastankus@xxxxxxxxx Cc: oracle-l Subject: RE: URGENT: INCOMPLETE RECOVERY If she's doing an incomplete recovery, she'll never get far enough in recovery to apply current redo log from the source..... Paula, I know you said you were sure about begin/end backup on everything, but, check your alert.log. Does it have any messages about "fuzzy" datafiles? If so, you missed a begin/end backup somewhere. Also, make sure you ended backup on all datafiles: select distinct status from v$backup; The above should return a single line: NOT ACTIVE Finally, if none of that works, please post the exact text of the error message you're getting. -Mark -- Mark J. Bobak Senior Oracle Architect ProQuest/CSA "There are 10 types of people in the world: Those who understand binary, and those who don't." ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Rhojel Echano Sent: Thursday, April 12, 2007 8:18 AM To: paulastankus@xxxxxxxxx Cc: oracle-l Subject: Re: URGENT: INCOMPLETE RECOVERY have you tried copying the current redo log from the source and applying it to the clone? On 4/12/07, Paula Stankus < paulastankus@xxxxxxxxx <mailto:paulastankus@xxxxxxxxx> > wrote: This should be a simple clone and I have done it a million times. However, finding the space and cloning a 200+Gb with over 188 files is difficult especially when you don't have the space readily available to clone to. So here I am exhausted trying to bring a database open after incomplete recovery. I have checked and double-checked that I have done a begin backup...cp,,,end backup on each datafile, have a controlfile and database in mounted stated, have all the logs - in fact, apply logs that I know were created far after the backup. mounted database recover database using backup controlfile until cancel endless applying of archive logs I cannot open the database with resetlogs. I cannot open it at all. I am getting that error that not all my files are in-synch. sigh. Any good ideas out there - maybe I just need another set of eyes. :) Thanks, Paula Version 8.1.7.4 ________________________________ Looking for earth-friendly autos? Browse Top Cars by "Green Rating" <http://autos.yahoo.com/green_center/;_ylc=X3oDMTE4MGw4Z2hlBF9TAzk3MTA3M Dc2BHNlYwNtYWlsdGFncwRzbGsDZ3JlZW5jZW50ZXI-> at Yahoo! Autos' Green Center.