Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: URGENT: INCOMPLETE RECOVERY

Re: URGENT: INCOMPLETE RECOVERY

From: Rhojel Echano <rhojel.echano_at_gmail.com>
Date: Thu, 12 Apr 2007 20:18:28 +0800
Message-ID: <16e45e3f0704120518y1f726e9i43b1f86d5060f7b0@mail.gmail.com>


have you tried copying the current redo log from the source and applying it to the clone?

On 4/12/07, Paula Stankus <paulastankus_at_yahoo.com> 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=X3oDMTE4MGw4Z2hlBF9TAzk3MTA3MDc2BHNlYwNtYWlsdGFncwRzbGsDZ3JlZW5jZW50ZXI->at Yahoo! Autos' Green Center.
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Apr 12 2007 - 07:18:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US