Oracle Database@AWS Architect Professional study materials
Oracle Database@AWS Architect Professional study resources

Oracle Database@AWS Architect Professional key terms

Oracle Database@AWS Architect Professional · Get comfortable with the vocabulary.

Oracle Database@AWS

A managed offering that places Oracle Exadata infrastructure inside AWS data centers, letting you run Oracle databases close to AWS workloads while Oracle operates and manages the database platform.

Related: Exadata Infrastructure Resource, ODB Network
Exadata Infrastructure Resource

The provisioned hardware and control-plane object that hosts one or more Oracle Exadata VM Clusters; it defines shape, storage, and placement, and is the parent object for databases.

Related: Exadata VM Cluster, Autonomous VM Cluster
Exadata VM Cluster

A group of compute nodes and shared storage created inside an Exadata Infrastructure resource that runs Oracle Grid Infrastructure and hosts Oracle databases with RAC or single-instance layouts.

Related: Exadata Infrastructure Resource, Grid Infrastructure
Autonomous VM Cluster

A VM cluster variant provisioned for Oracle Autonomous Database workloads, where Oracle automates patching, tuning, and scaling of the databases running on the underlying Exadata system.

Related: Exadata VM Cluster, Autonomous Database
ODB Network

A dedicated, isolated network construct created during provisioning that connects Oracle Database@AWS resources to your AWS VPC and to on-premises networks through standard AWS routing and gateways.

Related: Client Subnet, Backup Subnet
Client Subnet

The subnet within an ODB network used for application and client connectivity to the database endpoints; it carries the traffic that applications and database clients actually use.

Related: ODB Network, Backup Subnet
Backup Subnet

A subnet reserved for backup and recovery traffic between the database system and backup destinations, kept separate from client traffic to simplify routing and security controls.

Related: Client Subnet, ODB Network
VPC Peering

An AWS connection between two VPCs that routes traffic privately using private IP addresses, commonly used to reach Oracle Database@AWS endpoints from application VPCs in the same or another account.

Related: Transit Gateway, Private Endpoint
AWS Transit Gateway

A regional hub that connects VPCs, VPNs, and on-premises networks through a single attachment point, often used to centralize and scale routing to Oracle Database@AWS networks.

Related: VPC Peering, ODB Network
Private Endpoint

An endpoint that exposes a service to a VPC using private IP addresses only, so database traffic never traverses the public internet and stays within the AWS network.

Related: VPC Peering, Security Group
Security Group

A stateful virtual firewall attached to resources that permits or denies inbound and outbound traffic by protocol, port, and source or destination, controlling access to database listeners.

Related: Network ACL, Private Endpoint
Network ACL

A stateless subnet-level filter that evaluates ordered allow and deny rules for traffic entering or leaving a subnet, providing a coarse layer beneath security groups.

Related: Security Group, Client Subnet
AWS IAM Role

An AWS identity with permission policies that trusted principals such as users or services can assume temporarily, used to delegate access to AWS resources involved in provisioning and operations.

Related: Resource Policy, Service-Linked Role
Service-Linked Role

A predefined IAM role that an AWS service assumes to perform actions on your behalf, created automatically during onboarding and required for the service to manage resources.

Related: AWS IAM Role, Resource Policy
Resource Policy

A JSON policy attached directly to a resource such as a KMS key or secret that specifies which principals may perform which actions, independent of identity-based policies.

Related: AWS IAM Role, KMS Key Policy
KMS Key Policy

The resource policy governing an AWS KMS key; it must grant the required principals access before encrypted volumes, backups, or secrets can be used by the database service.

Related: Resource Policy, Encryption at Rest
Encryption at Rest

Protection of stored data, including database files, backups, and redo, using keys managed in AWS KMS or Oracle key management so that underlying storage media never holds plaintext.

Related: KMS Key Policy, Transparent Data Encryption
Transparent Data Encryption

An Oracle Database feature that encrypts data files and sensitive columns at rest with keys stored in a wallet or external key store, transparent to applications issuing SQL.

Related: Encryption at Rest, Oracle Wallet
Oracle Wallet

A password-protected container holding credentials such as TDE master keys and database passwords, used by the database to open encrypted data without manual intervention.

Related: Transparent Data Encryption
Grid Infrastructure

The Oracle software stack comprising Clusterware and Automatic Storage Management that enables node clustering, resource failover, and shared storage management for databases on Exadata.

Related: Exadata VM Cluster, Oracle RAC
Oracle RAC

Oracle Real Application Clusters, a configuration in which multiple instances on separate nodes mount one database, providing instance-level high availability and horizontal scalability.

Related: Grid Infrastructure, Fast-Start Failover
Data Guard

Oracle's replication technology that maintains a standby database synchronized with a primary, enabling role transitions for disaster recovery and, with Active Data Guard, read-only offload.

Related: Fast-Start Failover, Switchover
Fast-Start Failover

An Oracle Data Guard observer-driven capability that automatically promotes a standby database when the primary becomes unavailable, reducing recovery time without manual intervention.

Related: Data Guard, Switchover
Switchover

A planned, reversible role reversal between primary and standby databases, typically performed for maintenance, in which the standby becomes primary and the old primary becomes standby.

Related: Data Guard, Fast-Start Failover
Autonomous Database

A fully managed Oracle database service that automates provisioning, patching, backup, and scaling, available within Oracle Database@AWS for workloads suited to hands-off administration.

Related: Autonomous VM Cluster, Exadata VM Cluster
Pluggable Database

A self-contained database within a multitenant container database that has its own metadata and can be opened, cloned, or moved independently of other pluggable databases.

Related: Container Database, Database Consolidation
Container Database

The multitenant root database that hosts one or more pluggable databases, sharing instance memory and background processes to reduce overhead and simplify consolidation.

Related: Pluggable Database, Database Consolidation
Database Consolidation

The practice of combining multiple databases onto shared infrastructure, often using multitenant architecture, to reduce cost and management effort while preserving isolation between workloads.

Related: Pluggable Database, Container Database
Oracle Data Pump

A high-speed Oracle utility for exporting and importing logical database objects and data, frequently used for migrations into Oracle Database@AWS when physical transport is impractical.

Related: GoldenGate, Migration Assessment
Oracle GoldenGate

Oracle's logical replication product that captures changes from a source database and applies them to a target, supporting near-zero-downtime migrations and ongoing data synchronization.

Related: Oracle Data Pump, Cutover
Cutover

The final phase of a migration when applications stop using the source database and begin using the target, usually after replication has caught up and validation has passed.

Related: Oracle GoldenGate, Rollback Plan
Rollback Plan

A documented procedure for reverting to the original environment if a deployment or migration fails, including data reconciliation steps and decision criteria for triggering the reversal.

Related: Cutover, Migration Assessment
Migration Assessment

The pre-migration analysis of source database versions, features, dependencies, sizing, and performance that determines the target shape and the migration method to use.

Related: Oracle Data Pump, Rollback Plan
Backup Retention Policy

The rule set defining how long backups are kept and when they expire, balancing recovery point objectives against storage cost and compliance requirements.

Related: Recovery Point Objective, Backup Subnet
Recovery Point Objective

The maximum acceptable amount of data loss measured in time, which drives backup frequency and redo transport settings such as Data Guard synchronization mode.

Related: Recovery Time Objective, Backup Retention Policy
Recovery Time Objective

The maximum acceptable duration to restore service after an outage, which determines whether standby databases, automatic failover, or restore-from-backup strategies are required.

Related: Recovery Point Objective, Fast-Start Failover
Tagging Strategy

A consistent scheme for assigning key-value metadata to provisioned resources so that cost allocation, ownership, automation, and compliance reporting remain accurate across accounts.

Related: Landing Zone, Cost Allocation
Landing Zone

The baseline multi-account AWS environment with identity, logging, networking, and guardrails established before workloads are deployed, providing the foundation for database provisioning.

Related: Tagging Strategy, ODB Network