Sanity Check Please: Removing Datafiles after Dropping Tablespace?
From: Chris Taylor <christopherdtaylor1994_at_gmail.com>
Date: Tue, 25 May 2021 09:21:20 -0400
Message-ID: <CAP79kiT2z8xcR0nhU4pYYhcQrBW4mH79_ct8askC-8hjXGSiBA_at_mail.gmail.com>
Env :12.1.0.2 x86-64 Linux NON-RAC,NON-ASM
Date: Tue, 25 May 2021 09:21:20 -0400
Message-ID: <CAP79kiT2z8xcR0nhU4pYYhcQrBW4mH79_ct8askC-8hjXGSiBA_at_mail.gmail.com>
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 Received on Tue May 25 2021 - 15:21:20 CEST