MIME-Version: 1.0
References: <CAP79kiT2z8xcR0nhU4pYYhcQrBW4mH79_ct8askC-8hjXGSiBA@mail.gmail.com>
In-Reply-To: <CAP79kiT2z8xcR0nhU4pYYhcQrBW4mH79_ct8askC-8hjXGSiBA@mail.gmail.com>
From: Todd Bellaver <todd.bellaver@gmail.com>
Date: Tue, 25 May 2021 15:02:52 -0400
Message-ID: <CAKVQkW6nN_X0yQExPMCi6imfdi3BRvK+T=ncGK=Er+G0XBZjkQ@mail.gmail.com>
Subject: Re: Sanity Check Please: Removing Datafiles after Dropping Tablespace?
To: christopherdtaylor1994@gmail.com
Cc: "oracle-l@freelists.org" <oracle-l@freelists.org>
Content-Type: multipart/alternative; boundary="000000000000e77ecd05c32c2c9f"
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: todd.bellaver@gmail.com
--000000000000e77ecd05c32c2c9f
Content-Type: text/plain; charset="UTF-8"

Hey there,

Some things you may want to try before deleting them:
 - If Linux, run lsof (lsof | grep filename) to check if the database still
has these files open
 - Check the date/time stamp.  If timestamps are current, the file(s) are
still being used
 - if you're still unsure, rename/compress the files.  This way if files
are still needed, you can 'restore' them by renaming/uncompressing them

hth,

Todd

On Tue, May 25, 2021 at 9:21 AM Chris Taylor <
christopherdtaylor1994@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
>
>
>

--000000000000e77ecd05c32c2c9f
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hey there,<div><br></div><div>Some things you may want to =
try before deleting them:</div><div>=C2=A0- If Linux, run lsof (lsof | grep=
 filename) to check if the database still has these files open</div><div>=
=C2=A0- Check the date/time stamp.=C2=A0 If timestamps are current, the fil=
e(s) are still being used</div><div>=C2=A0- if you&#39;re still unsure, ren=
ame/compress the files.=C2=A0 This way if files are still needed, you can &=
#39;restore&#39; them by renaming/uncompressing them</div><div><br></div><d=
iv>hth,</div><div><br></div><div>Todd</div></div><br><div class=3D"gmail_qu=
ote"><div dir=3D"ltr" class=3D"gmail_attr">On Tue, May 25, 2021 at 9:21 AM =
Chris Taylor &lt;<a href=3D"mailto:christopherdtaylor1994@gmail.com">christ=
opherdtaylor1994@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"gma=
il_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,2=
04,204);padding-left:1ex"><div dir=3D"ltr"><div class=3D"gmail_default" sty=
le=3D"font-family:arial,helvetica,sans-serif">Env :12.1.0.2 x86-64 Linux NO=
N-RAC,NON-ASM</div><div class=3D"gmail_default" style=3D"font-family:arial,=
helvetica,sans-serif"><br></div><div class=3D"gmail_default" style=3D"font-=
family:arial,helvetica,sans-serif">As haste makes waste (or leaves waste as=
 the case may be), I dropped a tablespace as part of a scheduled maintenanc=
e.=C2=A0 However, I neglected the &quot;INCLUDING CONTENTS AND DATAFILES&qu=
ot; portion of the drop command.<br></div><div class=3D"gmail_default" styl=
e=3D"font-family:arial,helvetica,sans-serif"><br></div><div class=3D"gmail_=
default" style=3D"font-family:arial,helvetica,sans-serif">So now I have a l=
ot of datafiles left on the OS.=C2=A0 =C2=A0=C2=A0<br><br>I&#39;ve confirme=
d that fuser doesn&#39;t show any PIDs touching the datafiles.</div><div cl=
ass=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif"><br>=
</div><div class=3D"gmail_default" style=3D"font-family:arial,helvetica,san=
s-serif">I <i>think </i>I can drop the datafiles straight from the OS now o=
n both the primary and standby, but need a sanity check here if anyone know=
s something different?=C2=A0 I&#39;m being careful here in case I&#39;ve fo=
rgotten something.=C2=A0</div><div class=3D"gmail_default" style=3D"font-fa=
mily:arial,helvetica,sans-serif"><br></div><div class=3D"gmail_default" sty=
le=3D"font-family:arial,helvetica,sans-serif">Thanks,<br>Chris</div><div cl=
ass=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif"><br>=
<br></div></div>
</blockquote></div>

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