database can mount but not open. Can I get data out? - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

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

  1. #11
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,003
    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?
    this space intentionally left blank

  2. #12
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    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.

  3. #13
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    Originally posted by DaPi
    If the db was open, then this shouldn't be possible under Windows - OS file locking.
    *if*
    I'm stmontgo and I approve of this message

  4. #14
    Join Date
    Oct 2000
    Location
    Charlotte, USA
    Posts
    330
    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,
    Thanigaivasan

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width