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@xxxxxxxxx> 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@xxxxxxxxx>
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@xxxxxxxxx> 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
