US 12,007,847 B2
Reporting for database backups
Rachana Murthy, Bangalore (IN); Shelesh Chopra, Bangalore (IN); Ban Wang, Ontario (CA); Hari Palani, Bangalore (IN); and Amith Ramachandran, Bangalore (IN)
Assigned to EMC IP HOLDING COMPANY LLC, Hopkinton, MA (US)
Filed by EMC IP Holding Company LLC, Hopkinton, MA (US)
Filed on Apr. 21, 2021, as Appl. No. 17/236,079.
Prior Publication US 2022/0342768 A1, Oct. 27, 2022
Int. Cl. G06F 11/14 (2006.01); G06F 11/30 (2006.01)
CPC G06F 11/1464 (2013.01) [G06F 11/1451 (2013.01); G06F 11/1461 (2013.01); G06F 11/1469 (2013.01); G06F 11/3072 (2013.01); G06F 2201/80 (2013.01)] 17 Claims
OG exemplary drawing
 
1. A method for reporting database backup information, the method comprising:
making a first determination, by a first child process of a plurality of child processes, that a monitoring process associated with the plurality of child processes has not been started by determining that a flag file for the database has not been created by the plurality of child processes;
starting, by a first library instance of the first child process executing on a data source device, the monitor process, wherein the first child process comprises a first backup channel for performing a first portion of a database backup of a database;
making a second determination, by the first library instance, that the flag file has still not been created by the plurality of child processes, wherein the first child process is first in time of the plurality of child processes to start the monitor process;
generating, by the monitor process, the flag file for the database backup comprising a parent process identifier (PID) of a parent process of the first child process, wherein the flag file:
further comprises child (PIDs) associated with the plurality of child processes and backup job names associated with backup jobs of the database backup, and
specifies backup job start times, backup job end times, backup job successes, backup job failures, and the first child process started the monitoring process and generated the flag file;
associating a second child process of the plurality of child processes with the monitor process by identifying the flag file using the parent PID, wherein the second child process comprises a second backup channel for performing a second portion of the database backup;
receiving, by the monitor process, a first channel close alert corresponding to the second channel from the second child process;
performing, by the monitor process and using a PID of the first child process, a check to confirm that the first child process is still executing;
receiving, by the monitor process and separate from the first channel close alert, a second channel close alert corresponding to the first channel from the first child process;
making a third determination, by the monitor process, that a first plurality of the backup jobs performed in the first channel were successful;
making a fourth determination, by the monitor process, that a second plurality of the backup jobs performed in the second channel were successful; and
transmitting, by the monitor process and based on the first determination and the second determination, a backup success report to a backup coordinator,
wherein the first backup channel and the second backup channel include separate data streams for transferring data from the database to a backup storage device.