Database Recovery
Recovery is the process of restoring the database to a fully functional state after one or more nodes in the system has experienced a software- or hardware-related failure. Failures can include:
- Hardware failure of one or more nodes
- Clean database shutdown (initiated)
-
Unclean database shutdown, which can be caused by:
-
A critical node failure, leaving part of the data unavailable.
-
A power failure causing all nodes to reboot.
-
Vertica processes terminating due to a software or hardware failure.
-
A failure can cause a node to lose database objects or to miss DML changes (INSERTs, UPDATEs, and so on) while offline. During recovery, each node retrieves any lost objects and updates any changes by querying the other nodes.
For detailed information about database recovery after specific types of failure, see Recovering the Database in the Administrator's Guide.