Overview
Migrating your existing Oracle AI Database(s) to Oracle AI Database@AWS allows you to use high-performance Oracle AI Database services, such as Exadata Database Services and Autonomous AI Database(s) which are running on Oracle-managed infrastructure within AWS data centers. This migration provides low-latency access to AWS applications and smooth integration with AWS services.
A successful migration requires careful planning, selecting the right tools and methodologies based on the source environment, database characteristics, and business requirements by ensuring acceptable downtime and maintaining data integrity.
Key Objectives
- Modernization: Transition from legacy or on-premises systems to high-performance, cloud-based Oracle infrastructure.
- Performance & Scalability: Utilize Exadata-grade performance and elastic scalability for diverse workloads.
- Operational Efficiency: Simplify database management with automation, integrated security, and optimized resource utilization.
- Business Continuity: Minimize downtime and data loss through resilient and proven migration methodologies.
Key Migration Considerations
- Downtime Tolerance (RTO/RPO): Define acceptable downtime and data loss to decide between online or offline migration.
- Database Size & Network Bandwidth: Larger databases and limited bandwidth can impact migration time; hybrid approaches like AWS Snowball or data staging can help.
- Compatibility: Validate source and target database versions, operating systems, and endian formats.
- Complexity: Account for schema dependencies, advanced features, and security configurations.
- Cost & Resources: Consider licensing, temporary infrastructure, and available DBA expertise.
Migration Tools & Approaches
Oracle provides several tools and technologies to simplify and automate migration:
- Zero Downtime Migration (ZDM): Orchestrates both online and offline migrations using RMAN, Data Guard, or Data Pump.
- Oracle Database Migration Service (DMS): A fully managed cloud service that simplifies migration setup, automates validation, and integrates with Data Pump and GoldenGate for secure, low-downtime migrations.
- Data Guard: Enables real-time synchronization for low-downtime cut-overs.
- Data Pump: Supports logical migrations, version upgrades, and selective schema transfers.
- GoldenGate: Delivers real-time replication for near-zero downtime migrations.
- RMAN: Enables physical migrations and cross-platform transfers through backup and restore.