-
Please help!
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?
THanks
Dev
-
did you try either of the following at the mount stage --
alter database datafile 3 offline;
or
alter database datafile 3 offline drop;
you can use the datafile name also with the full path
- Rajeev
Rajeev Suri
-
maybe ...
you need to take the datafile offline, not the tablespace.
- mount the database
- then issue:
alter database datafile
'/disk2/data/datafile_name.dbf' offline;
try that.
- Magnus
-
Thank Rajeev
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.
thanks
dev
-
Magnus. Thank you too! Please read my reply to Rajeev and see how you can assist.
Dev
-
Thanks fells the off line drop methos work.
cheers
Dave
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|