RE: oracle binaries and datafiles

                Decades ago, I learned not to name my redo logs as .log.  The standard where I am now is .rdo.  This way no matter what type of file system you have they won’t be gotten by massive log delete.

Liz

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Justin Mungal Sent: Wednesday, March 28, 2018 4:14 PM To: jbeckstrom_at_gcrta.org
Cc: oracle-l-freelist
Subject: Re: oracle binaries and datafiles

Tim mentioned ASM... there are many benefits to it that are mentioned in the documentation, but it also adds protection to your database from non-Oracle people. A system admin wanting to free up filesystem space can't delete redo1.log if it's stored somewhere he doesn't know how to access.

Anyway, since you're building out a new environment maybe it's a good time to consider it.

-Justin

On Wed, Mar 28, 2018 at 2:34 PM, Jeffrey Beckstrom <jbeckstrom_at_gcrta.org<mailto:jbeckstrom_at_gcrta.org>> wrote: We are migrating to Linux. We are planning on storing the Oracle binaries and datafiles on the same mount point. Should we rethink this and separate them. The mount point points to a SAN if that matters.

Jeffrey Beckstrom
Lead Database Administrator
Information Technology Department
Greater Cleveland Regional Transit Authority 1240 W. 6th Street<https://urldefense.proofpoint.com/v2/url?u=https-3A__maps.google.com_-3Fq-3D1240-2BW.-2B6th-2BStreet-2BCleveland-2C-2BOhio-2B44113-26entry-3Dgmail-26source-3Dg&d=DwMFaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=8DBNTXyuDfMtpf1FxT8iufNlf8SGW17zCSBO4-ZBOnI&s=EcXkJskJRsklbSqg6Nv9J4-ziKQfsrKbdqXr9fNLSCQ&e=> Cleveland, Ohio 44113<https://urldefense.proofpoint.com/v2/url?u=https-3A__maps.google.com_-3Fq-3D1240-2BW.-2B6th-2BStreet-2BCleveland-2C-2BOhio-2B44113-26entry-3Dgmail-26source-3Dg&d=DwMFaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=8DBNTXyuDfMtpf1FxT8iufNlf8SGW17zCSBO4-ZBOnI&s=EcXkJskJRsklbSqg6Nv9J4-ziKQfsrKbdqXr9fNLSCQ&e=>

--

http://www.freelists.org/webpage/oracle-l Received on Thu Mar 29 2018 - 16:24:52 CEST