Another attention point is lazy loading when you create a DB instance from a DB snapshot you can use the restored DB instance as soon as its status is available. You do need to be mindful that both the snapshot and read replica capabilities require additional licensing for the period of time the snapshot and replica are present. Snapshot restore uses the RDS snapshot capabilities to return the database to a certain point in time. The read replica activation method uses the RDS replica feature and the ability to activate the replica to be a full read/write primary instance.
You can either utilize the snapshot restore method or the read replicas activation method as substitutes for the Oracle flashback database feature. This post describes the alternatives to the Oracle flashback database capability in Amazon RDS for Oracle. By leveraging the agility and flexibility of the AWS Cloud, you can reach for the same level of protection without needing to operate directly on the live database and help avoid the performance overhead and resource consumption associated with the flashback database feature.Īmazon RDS for Oracle supports flashback table, flashback query, flashback transaction, and Oracle flashback features, but does not support flashback database to restore the entire database to a specific point-in-time. On the other hand, performing a flashback operation directly on your production database involves some risks and in case of an unpredictable problem, you may have to run a full restore with the potential for a significant impact on the service availability. This is particularly valuable in an on-premises environment, where normally it’s hard to provision on-demand hardware to host one or more copies of your database for a short time. The recovery is applied directly on the live database and you won’t have to configure additional hardware and wait to complete a full restore. The feature can be used to help recover from user errors, data corruption, other unforeseen disasters, or as a fall-back option for planned activities such as application and database upgrades.
However, there could be workloads that have dependencies on Oracle features that aren’t supported by Amazon RDS for Oracle.įor example, the flashback database is a feature of the Oracle Database that allows you to restore a database to a point in time. Customers may prefer to host their Oracle database workloads in a managed service such as Amazon Relational Database Service (Amazon RDS) for Oracle because of the benefits offered by managed services.
0 kommentar(er)
