What feature allows Oracle Autonomous Database to do self-repair?

The feature that enables Oracle Autonomous Database to perform self-repair is the automated fault detection and self-healing capabilities. This functionality is integral to the architecture of the Autonomous Database, which leverages machine learning and automation to identify and rectify issues without human intervention.

This self-healing characteristic is essential as it enhances the reliability and availability of databases by ensuring that common failures can be fixed in real-time. When a fault is detected—such as hardware failures or issues that may affect performance—the system automatically takes corrective actions to restore service. This proactive approach significantly reduces downtime and improves overall system resilience.

In contrast, automated health checks focus on monitoring the system's status and performance but do not actively engage in repair processes. Although scheduled maintenance windows are important for planned updates and optimizations, they do not contribute to real-time self-repair. Lastly, requiring manual intervention for repairs is contrary to the concept of the Autonomous Database, which aims to minimize human involvement in routine database management tasks. Thus, it is the automated fault detection and self-healing capabilities that truly define the self-repair feature of Oracle Autonomous Database.