Lecture on Types of Databases in Oracle

Introduction

• Channel: Malik Jaya 34
• Presenter: Malik Arjun
• Focus: Types of databases in Oracle
  • Standalone
  • Standalone with Oracle Restart Service
  • RAC One Node
  • RAC (Real Application Clusters)

Standalone Database

• Traditional RDBMS
• Storage: Local or remote file systems (NFS, SAN, NAS)
• Database runs on one server
• No ASM (Automatic Storage Management) needed

Standalone with Oracle Restart Service

• Database with ASM as standalone
• Create ASM disk group & install ASM instance
  • Database installed on ASM disk group
• Needs one server
• ASM automatically restarts the database if it goes down

RAC One Node

• Similar to Oracle Restart Service but in a cluster
• Create ASM disk groups on multiple nodes
• Only one instance runs on any one cluster node at a time
• Database and ASM managed on multiple nodes
• Automatic failover if the current instance fails
• Needs multiple servers based on cluster size (2, 3, 4, etc.)

RAC (Real Application Clusters)

• Clustered database with all instances running on all nodes simultaneously
• ASM and database installed on multiple nodes
• Ensures high availability and load balancing
• Automatic failover and restart capabilities
• Requires ASM on all nodes

Differences Between Database Types

• Number of Servers/Instances
  • Standalone: 1 server, 1 instance
  • Oracle Restart: 1 server, 1 instance
  • RAC One Node: Multiple servers, 1 active instance, failover instances
  • RAC: Multiple servers, multiple active instances
• Instance Names
  • Standalone: prod db
  • Oracle Restart: prod db
  • RAC One Node: proddba1, proddba2 (only one running at a time)
  • RAC: prod db1, prod db2 (all running)
• ASM Requirement
  • Standalone: Not needed
  • Others: Needed (ASM1, ASM2, etc.)

Automatic Restart and Failover

• Standalone: Manual restart required
• Oracle Restart / RAC One Node / RAC
  • Automatic restart and failover managed by ASM
  • ASM handles disk groups, data striping, mirroring, failover

High Availability and Load Balancing

• Standalone: No high availability or load balancing
• Oracle Restart: ASM restarts services but no load balancing
• RAC One Node: High availability with automatic failover, limited connections
• RAC: High availability, load balancing, dynamic scaling, more robust

Conclusion

• Each type has advantages and disadvantages
• Best practice recommendation: RAC database for high availability, load balancing, and dynamic scaling

Acknowledgements

• Thanking the audience and encouraging to like, comment, and subscribe if they found the session beneficial.

Next Steps

• Viewers encouraged to watch previous videos for more insights.