Tuesday, February 7, 2023

Oracle Snapshot for standby database on Exadata Cloud@Customer

 Recently Oracle has announced support for snapshot standby databases on Autonomous Database on Dedicated Exadata Infrastructure and Exadata Cloud@Customer. As per Oracle, A snapshot standby database is a fully updateable standby database created by converting a standby Autonomous Container Database (ACD) to a snapshot standby ACD. A snapshot standby database receives and archives redo data from the primary database but does not apply it.

Oracle Exadata Cloud@Customer is the simplest way to move an organization’s business-critical Oracle Database workloads to the cloud. It simultaneously runs Oracle Exadata Database Service and the fully managed Oracle Autonomous Database Service inside customers’ data centers and behind their firewalls to help meet strict data residency and security requirements. This feature of snapshot standby databases on Autonomous Database on Exadata Cloud@Customer is going to be an instant hit due to the value it provides. 

Oracle Database workloads are automatically analyzed, tuned, and scaled to optimize performance for OLTP, analytics, and application development workloads without interrupting their operations. Multiple-VM Autonomous Database allows customers to set up isolated operational environments such as DevTest, staging, or production with different configurations, access rules, quotas, and licensing (BYOL and license included) to optimize support for multiple workloads at the same time.

And that is why this snapshot feature is so important. With the Oracle Autonomous Database, you always have the possibility to recover to any point in time during the past 2 months. Oracle documentation says, "Autonomous Data Warehouse automatically backs up your database for you. The retention period for backups is 60 days. You can restore and recover your database to any point-in-time in this retention period."

The Oracle Autonomous Database does not provide all the possibilities available when you manage it yourself so I would highly recommend using Exadata Cloud@Customer or Autonomous Database on Dedicated Exadata Infrastructure. 

No comments: