RE: URGENT: INCOMPLETE RECOVERY
- From: "Robert Freeman" <robertgfreeman@xxxxxxxxx>
- To: <paulastankus@xxxxxxxxx>, "'oracle-l'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 12 Apr 2007 23:23:35 -0600
Any update on this problem? Did you get it fixed or do you still need help?
RF
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]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.
Other related posts:
