I have deleted a physical datafile space on Unix box before dropping the tablespace in Oracle. After the fact, when I try to drop Oracle tablespace the Instance crashed. I started the instance in mount mode, try to alter the tablespace offline Oracle tell me db is not open. I then tried to alter db open, I receive error 01157 cannot identify/lock datafile and ora 01110 datafile /oracle/----/----/ datafile"name".
How do I recover Oracle without having to do a backup of the datafile? This datafile has no useful purpose.
Is their a way to recover form this?
did you try either of the following at the mount stage --
alter database datafile 3 offline;
alter database datafile 3 offline drop;
you can use the datafile name also with the full path
you need to take the datafile offline, not the tablespace.
- mount the database
- then issue:
alter database datafile
When I tried datafile offline the following message occur>
ORA-01145: offline immediate disallowed unless media recovery enabled. Any suggestion how to do this. I am reading up on this. I am a Newbie in Oracle and a have been in MSSQL.
Magnus. Thank you too! Please read my reply to Rajeev and see how you can assist.
Thanks fells the off line drop methos work.
Click Here to Expand Forum to Full Width