Announcements

Oracle training based on real-time expertise as per industry standards. Upcoming batch details are here.

View batch schedule

Free Oracle mock interview. Register using the link.

Register

#DBAchallenge: submit your questions.

Ask questions
Swipe for more →
Browse by Topic
Latest Posts

    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

    🌟 Proud to be an Oracle ACE Pro! 🚀

    🌟 Proud to be an Oracle ACE Pro! 🚀 I’m excited to share my official Oracle ACE Profile with the Oracle community. 👨‍💻 Mallikarjun ...