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

Collapse
Posted by Andrei Popov on
<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
Posted by Sebastiano Pilla on
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.