Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Is it possible to remove temporary added datafile from tablespace ?

Re: Is it possible to remove temporary added datafile from tablespace ?

From: <satar_at_my-dejanews.com>
Date: Tue, 17 Nov 1998 02:03:20 GMT
Message-ID: <72qlh8$k8h$1@nnrp1.dejanews.com>


I'm sorry, I do not think I understand the question. You "offline drop" the datafile belonging to the Roll Back Segment Tablespace? I'm not sure if you can recreate this tablespace, if anyone can answer this question, I'd greatly appreciate it.
According to the Backup and Recovery Guide, It states: ORACLE WORLDWIDE SUPPORT FAQ
Problem: File needs Media Recovery at Startup *If the datafile is in the SYSTEM or ROLLBACK Segment Tablespace, you must restore the entire database to your most recent full backup. The database will now contain data as of the time you took your full backup.

> =================================================================
> WARNING: THIS IS NOT INTENDED AS A SERIOUS SOLUTION. DON'T TRY IT.
> =================================================================
>
> Option 3:
> OFFLINE DROP the file in Oracle, then `rm` the file from the O/S.
>
> (It does mean you can't backup that tablespace anymore though, that's why it
is
> a bad idea).
>
> Satar, since I have actually done the above, do I now have to drop and
recreate
> the tablespace, or is there some other option. I know there are no tables or
> references to anything in the dropped file. The file is offline, when I do a
> backup controlfile to trace, the new control file lists the removed file, but
> then OFFLINEs it. Can I convice the DB to do the "DROP" bit I asked it to?
> --
> ,-,_|\ George Dau, __

Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Nov 16 1998 - 20:03:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US