Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: RMAN problem
StefanKapitza wrote:
> DMina_at_laiki.com wrote:
>> I have found the tablespace which Oracle thinks the extra file belongs >> to. It shows that that file is offline!. >> The tablespace itself is ok. I can stop/start the database without any >> problem. >> >> Any ideas?
In order to offline drop a datafile, I think you need to drop the tablespace first, but if the tablespace contains other legitimate files you don't want to do that. You might try recreating the controlfile without that datafile. Do a cold backup first though. I've never seen this situation before and I would definitely proceed with caution.
-- To reply by email remove "_nospam"Received on Wed Feb 01 2006 - 14:18:47 CST