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

Automation Script | Archivelog Generation Hourly Monitoring

1. List out all the running databases and pic one database where we want to monitore the archive log generation from last 1 month. [oracle@o...