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

Yeah that's what I *thought. *Just being paranoid I guess.

Thanks,
Chris

On Tue, May 25, 2021 at 9:56 AM Mark J. Bobak <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> 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>
>> 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 Chris Taylor <
>>> 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