Please enable JavaScript.
Coggle requires JavaScript to display documents.
ORACLE - Coggle Diagram
ORACLE
Maximum Availability Architecture (MMA) 23c
- Configuration, and lifecycle best practices for Oracle Databases and applications, enabling high-availability service levels for databases and applications residing in on-premises, cloud, or hybrid configurations
-
Zero Data Loss Recovery Appliance (ZDLRA)
- providing a continuous data protection solution for Oracle databases, ensuring minimal data loss and near-zero downtime in the event of failures
- .
Real-Time Redo Transport
- Continuously captures database changes (redactions) as they occur, allowing for recovery to the exact point of failure.
End-to-End Data Validation: Ensures the integrity and recoverability of backups by performing continuous validation checks.
Incremental-Forever Backup Strategy: Maintains space-efficient backups by only capturing incremental changes since the last full backup.
Space-Efficient Virtual Full Backups: Creates full backups by combining incremental backups, minimizing storage requirements.
Backup Operations Offload: Reduces the burden on production database servers by performing backup and recovery tasks on the appliance.
Database-Level Protection Policies: Enables flexible configuration of backup policies for different databases based on their criticality and recovery needs.
Database-Aware Space Management: Optimizes storage utilization by automatically managing space based on database requirements.
Cloud-Scale Architecture: Leverages a scalable and fault-tolerant hardware platform to handle large-scale database environments.
Efficient Replication: Enables replication of backups to secondary sites or cloud storage for disaster recovery purposes.
Policy-driven Archival: Provides options for archiving backups to cloud storage or tape based on defined policies.
Unified Management & Control: Offers a single pane of glass for managing all aspects of the data protection process through Oracle Enterprise Manager.
Like EXADATAbut with specialized SW that allows faster recovery. Does not imposed loads of
- You can think of it as a dedicated Data Guard destination
Redolog is applied on the recovery appliance
Allows incremental-for-ever backups. CReates a virtual-full backup
Cloid infra OCI DBProtection Service built into recovery Appliance
Autonomous DBs only / not available for onpremises DB
Edition-Based Redefinition
- enables online application upgrades with uninterrupted application availability. Both the current application and upgraded application can run simultaneously, allowing users to be phased over to the new version of the application without interrupting business continuity.
-
-
-
-
-
-
Classic concepts
Connectionls to DB
Services
- It is an abstract name for all of the parameters of a connection, where services are managed centrally from the database side (defined in file tnsnames.ora). It minimizes the need for hardcoding connection parameters onto the client application
- Represents an instance or a group of instances
JDBC
- Details of connection string () must all be known, and reside in the cliente application
-
-
-
-
Driver: Specifies the JDBC driver used to communicate with the database (e.g., jdbc:oracle:thin:).
Oodnet, DCP, Connection Pool
-
Database engine
-
On-Premises DB
19c (2018)
-
Machine Learning (ML) Integration: Enables embedding ML models within the database for real-time insights.
-
23c (2023)
App Development Simplification: Introduces features like Real-time SQL Plan Management and True Cache to improve application performance and simplify development.
JSON Enhancements: Adds Boolean data type support for JSON and simplifies querying and manipulation.
Native Vector Data Type: Provides built-in capabilities for storing and manipulating vector data, enhancing performance for specific workloads.
-
