Real time database backup status indication and restore
A computer-implemented method at a data management system comprises; retrieving start and end times of a backup of a database; retrieving time stamps of log backups of the database; retrieving sequence numbers of the log backups; generating a graphical user interface illustrating a timeline of availability of database restoration and unavailability; making a second backup of the database; illustrating, on the graphical user interface during the making, pending availability of the second database backup; receiving a command to restore the database at an available time as illustrated by the graphical user interface; and restoring the database.
1. A system, comprising:
one or more processors in communication with a database, the one or more processors configured to perform operations including:
retrieving start and end times of a backup of the database;
retrieving time stamps of log backups of the database;
retrieving sequence numbers of the log backups;
generating a graphical user interface illustrating a timeline of backup availability and unavailability based on the sequence numbers retrieved from the log backups of the database, wherein consecutive sequence numbers indicate backup availability and non-consecutive sequence numbers indicate backup unavailability;
receiving a command to restore the database to an available time as illustrated by the graphical user interface; and
restoring the database to the available time in accordance with the command.
2. The system of claim 1 , wherein the unavailability starts at a time indicated by a time stamp of a first log backup having a non-consecutive sequence number.
3. The system of claim 1 , wherein the operations further include determining a cause of the backup unavailability and displaying the determined cause on the graphical user interface.
4. The system of claim 1 , further comprising making a second backup of the database in response to determining there is a non-consecutive retrieved sequence number and illustrating, on the graphical user interface during the making, pending availability of the second backup.
5. The system of claim 4 , wherein the operations further include:
receiving a log backup having a sequence number preceding a non-consecutive number; and
updating the graphical user interface to indicate availability based on the received log backup.
6. The system of claim 1 , wherein the operations further comprise:
receiving a log file with a sequence number that restores consecutiveness to the retrieved sequence numbers; and
updating the graphical user interface to illustrate availability based on the received log file.
7. A method at a system, the method comprising:
retrieving start and end times of a backup of a database;
retrieving time stamps of log backups of the database;
retrieving sequence numbers of the log backups;
generating a graphical user interface illustrating a timeline of backup availability and unavailability based on the sequence numbers retrieved from the log backups of the database, wherein consecutive sequence numbers indicate backup availability and non-consecutive sequence numbers indicate backup unavailability;
receiving a command to restore the database to an available time as illustrated by the graphical user interface; and
restoring the database to the available time in accordance with the command.
8. The method of claim 7 , further comprising illustrating the timeline with different colors to indicate availability, unavailability, and pending availability.
9. The method of claim 7 , further comprising determining a cause of the cause of unavailability and displaying the determined cause on the graphical user interface.
10. The method of claim 7 , further comprising making a second backup of the database in response to determining there are non-consecutive retrieved sequence numbers and illustrating, on the graphical user interface during the making, pending availability of the second backup.
11. The method of claim 10 , further comprising making additional log backups after making the second backup.
12. The method of claim 7 , further comprising receiving a log file with a sequence number that restores consecutiveness to the retrieved sequence numbers and updating the graphical user interface to illustrate availability based on the received log file.
13. A non-transitory machine-readable medium storing instructions which, when read by a system, cause the system to perform operations comprising, at least:
retrieving start and end times of a backup of a database;
retrieving time stamps of log backups of the database;
retrieving sequence numbers of the log backups;
generating a graphical user interface illustrating a timeline of backup availability and unavailability based on the sequence numbers retrieved from the lot backups of the database, wherein consecutive sequence numbers indicate backup availability and non-consecutive sequence numbers indicate backup unavailability;
receiving a command to restore the database to an available time as illustrated by the graphical user interface; and
restoring the database to the available time in accordance with the command.
14. The non-transitory machine-readable medium of claim 13 , wherein the operations further comprise illustrating the timeline with different colors to indicate availability, unavailability, and pending availability.
15. The non-transitory machine-readable medium of claim 13 , wherein the operations further comprise determining a cause of the backup unavailability and displaying the determined cause on the graphical user interface.
16. The non-transitory machine-readable medium of claim 13 , wherein the operations further comprise making a second backup of the database is in response to determining there are non-consecutive retrieved sequence numbers and illustrating, on the graphical user interface during the making, pending availability of the second backup.
17. The non-transitory machine-readable medium of claim 16 , wherein the operations further comprise:
receiving a log backup having a sequence number preceding a non-consecutive number; and
updating the graphical user interface to indicate availability based on the received log backup.
18. The non-transitory machine-readable medium of claim 16 , wherein the operations further comprise making additional log backups after making the second backup.
19. The non-transitory machine-readable medium of claim 13 , wherein the operations further comprise receiving a log file with a sequence number that restores consecutiveness to the retrieved sequence numbers and updating the graphical user interface to illustrate availability based on the received log file.
20. The non-transitory machine-readable medium of claim 13 , wherein the unavailability starts at a time indicated by a time stamp of a first log backup having a non-consecutive sequence number.