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.

Other related posts: