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:DBRECOVER for Oracle
DBRECOVER Recovery Options
For Oracle incidents, start with the DBRECOVER for Oracle trial to verify table visibility, row previews, and export readiness on copied datafiles. For MySQL and InnoDB incidents, DBRECOVER for MySQL is free software and can inspect.ibd files, ibdata1, and database directories locally.
When the case is urgent, preserve the original files first, work from copies, and contact paid emergency support with the database version, platform, error messages, file list, and recovery objective.