RE: URGENT: INCOMPLETE RECOVERY

From: Robert Freeman <robertgfreeman_at_yahoo.com>
Date: Thu, 12 Apr 2007 23:23:35 -0600
Message-ID: <KEEDIPJOJLCHPPAIDPDOAEJMDNAA.robertgfreeman@yahoo.com>

Any update on this problem? Did you get it fixed or do you still need help?

Robert G. Freeman
Oracle Press Author
Principle Engineer/Team Manager
The Church of Jesus Christ of Latter-Day Saints Collaborate '07
Come join my APEX University Session
and Join me to talk about Evolutionary Database Development!! The LDS Church is Hiring DBAs! Contact me if you are interested!

  -----Original Message-----
  From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Paula Stankus   Sent: Thursday, April 12, 2007 4:21 AM   To: 'oracle-l'
  Subject: RE: URGENT: INCOMPLETE RECOVERY

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" at Yahoo! Autos' Green Center.

--

http://www.freelists.org/webpage/oracle-l Received on Fri Apr 13 2007 - 00:23:35 CDT