Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Datafiles
This might be a little easier...
You don't have to do a full cold restore, you can do it with just
system datafiles and this datafile if you have a consistent cold
backup of these to go with your datafile...
Find an area for a new database..(consisting of just that one
datafile and the system datafiles, rollbacks and redo logs wouldn't
hurt either )
I think if you bring up the database in nomount mode you can offline
drop every other file except the one your interested in. (and system,
redo and rollback)
This essentially simulates bringing up a database that is so damaged that almost every disk drive has crapped out on you...
You should then be able to open the database and then take an export of the table,, jam it in the "real database"..
Something along these lines does work, I have restored a large production Oracle financial database on a test box with just 5 datafiles of the original 200 just to run some reports, and this might save you the time of doing major cold restores and backups which take a lot of room.
If you have problems.. e-mail me... I'll go back to my notes and figure out how I did this..
HOWEVER - if all you have is this lone copy of a datafile, I think your out of luck.. I think it's useless by itself.. but I retain hope of sneaky tricky things. Theoretically, there should seem to be some way to pull tables out of a lone datafile, but I don't think it's been done yet.. Proprietary stuff you know...
On Wed, 02 Aug 2000 19:22:38 -0700, Ethan Post <epost1NOepSPAM_at_yahoo.com.invalid> wrote:
>I don't know of an easier way than the following.
>
>1. Shutdown database and take a cold backup.
>2. Restore previous database from backup.
>3. Export table (start taking nightly exports to avoid this in
>the future)
>4. Shutdown database and restore data from cold backup
>5. Truncate table or drop it and restore from export you just
>took.
>
>-Ethan
>http://www.gnumetrics.com
>
>
>-----------------------------------------------------------
>
>Got questions? Get answers over the phone at Keen.com.
>Up to 100 minutes free!
>http://www.keen.com
Received on Thu Aug 03 2000 - 00:00:00 CDT