CODEWITHSUNDEEP
databaseoracle-databaserecovery
hunsbct
hunsbct

Reputation: 31

Is it possible to recover Oracle data from a broken installation that does not permit expdp?

I have an Oracle instance on hand in which all of the Windows services have mysteriously disappeared. Naturally this means that I have no TNS listener running and cannot create a backup with the usual expdp command.

As far as I can tell, all of the application files including datafiles are still intact. I have no idea what else might have been damaged by whatever removed the services, so my thinking is that I'd like to somehow create a .dmp file from the datafiles, or install a new instance of Oracle and somehow import/tie in those files. Any time I've ever touched datafiles in the past everything breaks so I'm trying to be careful about my approach.

Has anyone experienced something like this, and if so how were you able to recover data?

Upvotes: 0

Views: 177

Answers (1)

EdStevens
EdStevens

Reputation: 3872

There is no simple way to 'export' if the database is not open.

Have you been taking any rman backups? If not, why not?

The VERY FIRST thing you should do is COPY all of the data, redo, init, spfiles, any rman backup files and archivelog files to a safe location so that you do not break things like you say you have done in the past.

The second thing I'd be doing is figure out how a bunch of Windows services 'mysteriously dissappeared'. That is very troubling.

The next thing I'd do is determine if the ORACLE_HOME, and the oracle entries in the registry are intact.

You can recreate the listener service by simply going to command prompt (as administrator), setting ORACLE_HOME and PATH correctly, and issuing a 'lsnrctl start'.

If you are very lucky, you could use 'oradim' to recreate your database services and from there start your databases.

Upvotes: 1

Related Questions