The solution can be used for many things, including:
No database installation, configuration, or maintenance is needed.
The autonomous database provides several benefits and unmatched performance. It is self-driving, self-securing, and self-repairing.
Self-driving implies that all routine administration tasks including provisioning, performing backups and recovery, making fault-tolerant fail-overs, applying patches, performing upgrades, optimizing and tuning for performance, and scaling are all fully automated.
Self-securing implies that all data is encrypted and security updates and patches are applied automatically both periodically and off-cycle. The option for encryption keys to be managed by a user is provided.
Self-repairing implies that the database detects and recovers from failure of any sort, such as a single node failure, without user intervention.
The product is available on Oracle Cloud.
It guarantees 99.995% up-time.
There is no installation, configuration, or maintenance needed.
It integrates easily with other cloud services.
The product is self-driving. All routine administration tasks including provisioning, performing backups and recovery, making fault-tolerant fail-overs, applying patches, performing upgrades, optimizing and tuning for performance, and scaling are all fully automated.
The solution is self-securing. All data is encrypted and security updates and patches are applied automatically both periodically and off-cycle.
The service could be improved by:
- Providing Access to SYS schema
- Allowing access to SYSTEM schema
- Provisioning to apply user patches, and not just automated patches
- Having provisions to administer the database by a DBA as an add-on to autonomous management
- Getting provisions for fine-grained configuration
- Allowing for migration tools from other cloud services, including migration from Amazon Redshift, RDS, and Aurora
- Data Pump integration
- Simplified Integration with other Oracle cloud services such as the Autonomous Container Database
- Simplified migration from a local database
I've used the solution for more than three years.
The product is highly stable. Oracle Autonomous Database is a next-generation, first-of-a-kind, revolutionary, mission-critical data management in the cloud service. The autonomous database eliminates the need for data management by a database administrator (DBA) which is error-prone.
Stability implies that the database is reliable with guaranteed 99.9% Availability. The database recovers from failures automatically.
The solution has automated scaling based on need and usage.
The product offers excellent support.
We previously used AWS RDS and switched to Oracle Autonomous Database due to its ease of provisioning and access.
No setup is required as the service is fully automated, and runs on Oracle Cloud. Only an account registration is needed.
We did not use a third-party vendor.
We've seen an ROI of +90%.
Setup cost is not an issue as the service is on Oracle's Cloud. The Oracle Cloud Free Tier is an always free cloud service, with limited resource capacity.
We evaluated Amazon RDS and Amazon EC2.