Re: Sanity Check Please: Removing Datafiles after Dropping Tablespace?

 Chris,    

Just as an added check/paranoia, you could also confirm via v$datafile & a backup controlfile tracefile that the o.s datafiles (that you plan to remove) are  

 not known to the database.      

 -Rajeev              

>
> On May 25, 2021 at 9:56 AM, <Mark J. Bobak (mailto:mark_at_bobak.net)> wrote:
>
>
>
> Yes, if you're sure Oracle is no longer using them, there should be no problem dropping them. As long as the tablespace is gone, you're good to drop the corresponding datafiles.
>
>
> -Mark
>
>
>
>
> On Tue, May 25, 2021 at 9:33 AM Chris Taylor <christopherdtaylor1994_at_gmail.com (mailto:christopherdtaylor1994_at_gmail.com)> wrote:
>
> >
> >
> > The datafiles are not listed as part of the database because I dropped the tablespace already.
> >
> >
> >
> > So now its just a matter cleaning the datafiles off the OS.
> >
> >
> >
> > Thanks,
> > Chris
> >
> >
> >
> >
> > On Tue, May 25, 2021 at 9:30 AM Guenadi Jilevski <gjilevski_at_gmail.com (mailto:gjilevski_at_gmail.com)> wrote:
> >
> > >
> > > Hi,
> > >
> > >
> > > Could you please look at : https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:515222144417%20
> > >
> > >
> > >
> > > ALTER DATABASE DATAFILE OFFLINE DROP..
> > >
> > >
> > >
> > > Best Regards,
> > >
> > >
> > >
> > > Guenadi Jilevski
> > >
> > >
> > >
> > >
> > > On Tue, May 25, 2021 at 2:21 PM (x-apple-data-detectors://6) Chris Taylor <christopherdtaylor1994_at_gmail.com (mailto:christopherdtaylor1994_at_gmail.com)> wrote:
> > >
> > > >
> > > >
> > > > Env :12.1.0.2 x86-64 Linux NON-RAC,NON-ASM
> > > >
> > > >
> > > >
> > > > As haste makes waste (or leaves waste as the case may be), I dropped a tablespace as part of a scheduled maintenance. However, I neglected the "INCLUDING CONTENTS AND DATAFILES" portion of the drop command.
> > > >
> > > >
> > > >
> > > > So now I have a lot of datafiles left on the OS.
> > > >
> > > > I've confirmed that fuser doesn't show any PIDs touching the datafiles.
> > > >
> > > >
> > > > I think I can drop the datafiles straight from the OS now on both the primary and standby, but need a sanity check here if anyone knows something different? I'm being careful here in case I've forgotten something.
> > > >
> > > >
> > > >
> > > > Thanks,
> > > > Chris
> > > >
> > > >
> > > >

--
http://www.freelists.org/webpage/oracle-l