Forum OpenACS Q&A: Re: OT: Oracle off-line export

Collapse
2: Re: OT: Oracle off-line export (response to 1)
Posted by Glenn Cadman on 12/23/02 03:08 PM
Whilst I may be shot down in flames, I dont think it is possible to do as you wanted. The system tablespace contains the data dictionary, which is needed to retrieve the data logically. Also the existing datafiles and the backup datafiles are now inconsistent, (unless it was an archive tablespace).

To restore I think you have to shutdown and save the current db, restore the old db and tablespace, export your old data. The move back your good database and startup again, import the good data.

Collapse
3: Re: OT: Oracle off-line export (response to 2)
Posted by Andrei Popov on 12/23/02 03:23 PM
<blockquote> To restore I think you have to shutdown and save the
current db, restore the old db and tablespace, export
your old data. The move back your good database and
startup again, import the good data.
</blockquote>

This is a luxury I no longer have -- the rest of the db is
gone...

I remember seeing a mention of a certain utility (dbu?
dbunload?) that could do something along the lines of what I
need, but I cannot seem to find a single trace of it
anywhere...

Collapse
4: Re: OT: Oracle off-line export (response to 3)
Posted by Sebastiano Pilla on 12/23/02 06:49 PM
Sometimes I've seen mentioned an Oracle DUL (data unloader) tool, to be used for situations like yours. However, DUL seems to be an internal Oracle tool: you'll have to call Oracle support and ask to have somebody sent to your place to recover the database, and it can be very expensive.

You could also try http://sourceforge.net/projects/jdul/, although the project doesn't seem to have any release now.

All the best, take it as a lesson in backup and recovery you'll never forget.