Saturday, January 27, 2024

RAC file system confusing?

Shared file between RAC DB Instances:
=====================================
>>> Below are the list of files which are shared between RAC cluster instances and each cluster instances can read and write same file.
>>> These are the single set of files and not instance specific files.

a. spfile ------- On ASM
b. controlfile ------- On ASM
c. system ------- On ASM
d. sysaux ------- On ASM
e. users... etc ------- On ASM
f. tempfile ------- On ASM
g. password file  ------- On ASM

Non-Shared file between RAC DB Instances or Each Instance specifi files:
=======================================================
>>> Below are the list of files which are non-shared between RAC cluster instances and each cluster instances can read the files but can not write same file.  
>>> These are instance specific files in RAC cluster.

a. undo (undo1 & undo2) ------- On ASM
b. redo group ------- On ASM
c. pfile ------- FS (OS storage) / SAN /NAS /NFS 


Each Instance specific files:  
============================
>>>These are instance specific files in RAC cluster.

a. alert log ------- FS (OS storage) / SAN / NAS /NFS 
b. trace ------- FS (OS storage) / SAN / NAS /NFS 
c. trm ------- FS (OS storage) / SAN / NAS /NFS 
d. incident files ------- FS (OS storage) / SAN / NAS /NFS 
e. core dump ------- FS (OS storage) / SAN / NAS /NFS 
etc...

Regards,
Mallik

No comments:

Post a Comment

We’re thrilled to announce that a New Oracle RAC Batch is starting on 📅 Thursday, 23-Nov-2025!

🚀 Exciting Announcement! We’re thrilled to announce that a New Oracle RAC Batch is starting on 📅 Thursday, 23-Nov-2025! Demo Sessions ar...