Re: Sanity Check Please: Removing Datafiles after Dropping Tablespace?
Date: Tue, 25 May 2021 14:30:38 +0100
Message-ID: <CADFytLhLefwKOvEXpPCJ_iymje2FfbSKj55wEPwFtyr5yYy_OQ_at_mail.gmail.com>
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-lReceived on Tue May 25 2021 - 15:30:38 CEST