Re: Database layout
Date: Mon, 01 Mar 2021 00:19:11 +0100
Message-ID: <3be5686e633119720b8bb964a637b5f6_at_stijf.com>
Hi,
we use a similar setup too. Een though /u01/app/oracle is quite small
and only used for dba scripts.
With multiple database you create more mountpoints. We sepearate
redo/oradata/fra in separate mountpoints too. It allows us to assign
different i/o profiles to different mountpoints. OEM-agent, backup and
DB tree are located on HHD storage. The others are mixed SSD/HHD storage
with Tier 1 (highest performance for redo filesystem).
Do you have any reason to think this is a bad layout?
Regards,
Arian
On 2021-02-28 23:48, Michael Kline wrote:
> Database setup
>
> First time I've seen this layout?
>
> Anyone else using it?
>
> Each is a whole file system. Not sure what they do if you are running
> 5-8 databases on a server.
>
> /u01/app/oracle
>
> /u01/app/oracle/agent
>
> /u01/app/oracle/backup/<DB_NAME>
>
> /u01/app/oracle/<DB_NAME>/oradata ß All data here I guess.
>
> /u01/app/oracle/<DB_NAME>/redo_01
>
> /u01/app/oracle/<DB_NAME>/redo_02
>
> /u01/app/oracle/<DB_NAME>/fra
>
> Michael Kline
>
> 13308 Thornridge Ct
>
> Midlothian, VA 23112
>
> Cell: 804.314.6262
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Mar 01 2021 - 00:19:11 CET