If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Originally posted by tamilselvan You cannot get back your data with mount stage.
You have to open the database.
How ever, if you are willing to pay a huge amt (in $$$$), then oracle can recover the data.

Tamil

DUL data unloader, not a pleasant proposition -)

Realy though what's wrong with the db, perhaps an error might be of use to us, it's xmas afterall and perhaps we can help

Re: database can mount but not open. Can I get data out?

8.1.7 on Win2k-Serv. My database can be mounted but not opened. Apparently there's trouble with the DR01.DBF. Unfortunatly backups are corrupted, too.

Can I still get data and/or table structure out of it?

Thx,
D.

If you have enough redo and or archive logs you should be able to recover. Are you in archive log mode? Have you tried using the recover database command? You can use this command even if you aren't in archivelog mode, which you should be, however you will be limited in what you can recover from. But you won't know until you try.

Cannot recreate the error anymore. Either my HDD is going bad or my troubleshooting has made things worse. Orginally, when opening the database from DBAStudio I would receive an error somthing to the affect of "error reading DR01.DBF. File needs to be reconvered from backup."

Wish I could give you more, but I suspect I'm going to have give this all up for morbid. :-\

Originally posted by dsmcd Cannot recreate the error anymore. Either my HDD is going bad or my troubleshooting has made things worse. Orginally, when opening the database from DBAStudio I would receive an error somthing to the affect of "error reading DR01.DBF. File needs to be reconvered from backup."

Wish I could give you more, but I suspect I'm going to have give this all up for morbid. :-\

Thanks,
D.

Have you tried opening the database from svrmgrl? Have you looked at the alert log, it is in $ORACLE_BASE\admin\{SIDNAME}\udump? i.e. c:\Oracle\Admin\mydb\udump\mydbalert.log, or something like that.

Did you delete any of you data files? If you are trying to learn Oracle, then resovling this, if you can, would be good training.

Originally posted by gandolf989 Have you tried opening the database from svrmgrl? Have you looked at the alert log, it is in $ORACLE_BASE\admin\{SIDNAME}\udump? i.e. c:\Oracle\Admin\mydb\udump\mydbalert.log, or something like that.

Did you delete any of you data files? If you are trying to learn Oracle, then resovling this, if you can, would be good training.

Originally posted by stmontgo in your original post you mentioned trouble with DR01.DBF.

Why can't the file not be read, is it there?

Yes. It's there and where it should be. FYI...trouble began when someone tried to create a new database and ran out of freespace before the creation completed. Crashed the server while the database I'm having trouble with was active.

Originally posted by dsmcd Yes. It's there and where it should be. FYI...trouble began when someone tried to create a new database and ran out of freespace before the creation completed. Crashed the server while the database I'm having trouble with was active.

Thanks,
D.

oooh. could they have tried to create the system df where your system df was an overwrote that one? hmmm? perhaps?