Oracle 11g RAC database on ASM, ACFS or OCFS2

简介: I see a lot of questions on shared file systems that can be used when people move from single instance to Oracle RAC database and Grid Infrastructure.

I see a lot of questions on shared file systems that can be used when people move from single instance to Oracle RAC database and Grid Infrastructure. The most common question is the following: “Should I place archive logs in OCFS2 or ASM or ACFS of 11g?” I’ll try to clarify this topic below.

First we need to understand a separation between Oracle database files and non-database files.

Database files belong to an Oracle database and include control files, data files, archived logs, online redo logs, etc. Oracle ASM is the preferred storage manager for all database files. It has been specifically designed and optimized to provide the best performance for database file types. The file list supported by Oracle ASM becomes longer with every new version and it includes nowadays also spfile, RMAN backupsets and some other file types. You can however use other shared cluster file systems, including OCFS2 to store Oracle RAC database files.

Non-database files are everything that does not belong to database files including Oracle binaries (ORACLE_HOME, etc.). Oracle ACFS is the preferred file manager for non-database files. It is optimized for general purpose files and can be shared across the RAC cluster. You can use both ACFS or local file system, like Ext3 to store Oracle database binaries (ORACLE_HOME).

ACFS is a part of Oracle Grid Infrastructure. It cannot be used for a root file system, boot file system, or a file system containing the executables for Grid Infrastructure. It is also not supported to store in ACFS any files that can be natively stored in ASM; i.e., it is not supported to store Oracle database files (controlfiles, datafiles, archived logs, online redo logs, etc.). Also, the Grid Infrastructure Home cannot be installed in ACFS, it must be installed in a separate file system; e.g.; ext3. You can use ACFS though for Oracle binaries (ORACLE_HOME), but I would not recommend this.

However, and this is new, since Oracle database version 11.2.0.3 archive logs are supported in ACFS. See details: http://t.co/vOT8bMrE. I reflected everything in below support matrix.

Why not OCFS2

You can use OCFS2 to store both database file and Oracle database binaries (ORACLE_HOME) However Oracle does not recommend using OCFS2 anymore for RAC systems, for the following reasons:

-  OCFS2 and Grid infrastructure (Oracle Cluster-ware) are two separate cluster-wares. Therefore you would be running with 2 cluster-wares instead of one.
- OCFS2 will not gain any new functionality in regard of databases. OCFS2 will be used for Oracle VM and all new functionalities are more targeted in this direction than for databases.

As a summary, the recommendation of Oracle is clearly to use ASM for database files, and for everything which cannot be placed directly in ASM to use ACFS. However OCFS2 will be continued to be supported (at least at the moment).

Below is a support matrix for Oracle RAC / Grid Infrastructure installation

Supported Storage Option Voting/OCR GRID Software Database files Database Software
Automatic Storage Manager (ASM) Yes No Yes No
ASM Cluster File System (ACFS) No No Partially (11.2.0.3+) Yes
Oracle Cluster File System (OCFS2) Yes (1.4.1+) Yes (1.4.1+) Yes (1.4.1+) Yes (1.4.1+)
Red Hat Global File System (GFS) No (11g+) No (11g+) No (11g+) No (11g+)
NFS (certified only) Yes Yes Yes Yes
Local Storage No Yes No Yes

.
Check out RAC Technologies Matrix for Linux Platforms

http://www.dadbm.com/oracle-11g-rac-database-on-asm-acfs-or-ocfs2/

http://www.serkey.com/oracle-11g-r2-rac-on-vmware-ocfs2-problem-bfqbk7.html

目录
相关文章
|
7月前
|
SQL Oracle 关系型数据库
WARNING: Too Many Parse Errors With error=911 When Running a JDBC Application Connected to an Oracle 19c database
WARNING: Too Many Parse Errors With error=911 When Running a JDBC Application Connected to an Oracle 19c database (
94 2
|
7月前
|
Oracle 关系型数据库
19c 开启Oracle Database Vault
19c 开启Oracle Database Vault
164 1
|
4月前
|
运维 Oracle 前端开发
Oracle 11g RAC集群日常运维命令总结
Oracle 11g RAC集群日常运维命令总结
99 2
|
4月前
|
Oracle 关系型数据库
分布式锁设计问题之Oracle RAC保证多个节点写入内存Page的一致性如何解决
分布式锁设计问题之Oracle RAC保证多个节点写入内存Page的一致性如何解决
|
5月前
|
存储 负载均衡 Oracle
|
5月前
|
存储 Oracle 关系型数据库
|
7月前
|
SQL Oracle 关系型数据库
Connect to Autonomous Database Using Oracle Database Tools
Connect to Autonomous Database Using Oracle Database Tools
61 1
|
6月前
|
Oracle 关系型数据库 Linux
Requirements for Installing Oracle Database/Client 19c on OL8 or RHEL8 64-bit (x86-64) (Doc ID 2668780.1)
Requirements for Installing Oracle Database/Client 19c on OL8 or RHEL8 64-bit (x86-64) (Doc ID 2668780.1)
50 0
|
7月前
|
人工智能 Oracle 关系型数据库
一篇文章弄懂Oracle和PostgreSQL的Database Link
一篇文章弄懂Oracle和PostgreSQL的Database Link

推荐镜像

更多