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

[gandolf989]

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

I would have to concur with your diagnosis. Recovery, if possible, will be tricky.
Is there a more senior DBA who could intervene?

[DaPi]

Originally posted by dsmcd
...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 stmontgo
could they have tried to create the system df where your system df was an overwrote that one?

If the db was open, then this shouldn't be possible under Windows - OS file locking.

[stmontgo]

Originally posted by DaPi
If the db was open, then this shouldn't be possible under Windows - OS file locking.

*if*

[thanigai]

If you are able to mount As you said...
then query the database for the files needing recovery....
(use v$recover_file). Is it in archive log mode?.
when is the last successful backup you have and also the archive logs backup....

Thanks,