instead of stripping the other files from the controlfile, have you
tried to use the original controlfile, mount the database and then
offline drop the datafiles of the tablespaces you don't care about
before you open the database?
- John.Dailey_at_ing-fsi-na.com wrote:
> OK.... we had some data deleted from our production database and
> reporting
> database that shouldn't have been deleted. We want to take from
> the
> most recent backup the 3 tablespaces affected by the delete and the
> system
> tablespace and restore those files to a temporary database with a
> backup
> controlfile so we can pull the data we need out. We have stripped
> the
> other files from the controlfile creation script. We are getting a
> 600
> error when we attempt to create the controlfile - we have 2 DBAs here
> who
> have successfully completed this scenario in the past but we are
> stifled by
> the 600 error this time around. Oracle Support is saying we can't do
> this
> anymore in 8.1.7.... we aren't so sure. Can anyone think of
> something
> we are missing? Anyone performed this operation before?
>
> Restoring from the full backup is an option but it is our last one
> due to
> the size and time required to do this.
>
> Oracle 8.1.7.0
> AIX 4.3.3
>
> Any and all help is welcomed -
>
> thanks!
>
>
> John Dailey
> Corporate Systems DBA
> ING Americas
> Atlanta, GA
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: John.Dailey_at_ing-fsi-na.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing
> Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at
http://shopping.yahoo.com
or bid at
http://auctions.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Fri Dec 21 2001 - 07:06:54 CST