你在这里

You are here:

recover tablespace data afte re-create of a database - possible?

Posted by PDSERVICE on 4月 18, 2017 In

We, by a bad chance, created a new database on top of an existing one. Used the wrong ORACLE_SID basically. So now there are shiny new system, undo etc tablespaces, and a separate tablespace with all the important data in it, which is completely intact and contains everything we need.

The question is: is there a way to recover that data somehow? Basically, I'm seeking a way to recover data from an intact tablespace when the rest of the database is missing.

The database in question is 10.2.0.5 (linux 32bit), tablespace is locally managed and contains both tables (about 600 of them) and indexes. It were running in NOarchivelog mode.

(To make the story a bit less stupid: we performed conversion from 8i to 10g yesterday, and I haven't done any backups yet and didn't configure archivelogs etc, -- i wanted to do it now, but instead of doing backup I ran the yesterday's procedure. So, basically, I've a "backup" from yesterday, but today was quite productive day too)

Answer:

http://www.fors.com/velpuri2/dul_ucg8.html

Oracle's Data UnLoader (DUL) can do what you need.

Submit a Service Request

or you may try PRM-DUL : http://www.parnassusdata.com/