US 12,242,359 B2
Tenant-level database recovery
Uwe Hahn, Walldorf (DE); Eunsang Kim, Seoul (KR); Mihnea Andrei, Issy les Moulineaux (FR); Werner Thesing, Lautertal (DE); Patrick Voelker, Mannheim (DE); Ruediger Karl, Waibstadt (DE); Yong Sik Kwon, Seoul (KR); Jaeyoung Choi, Seoul (KR); Jian Luo, Shanghai (CN); Hyunjun Kim, Seoul (KR); Andre Schefe, Berlin (DE); Urs Klingsporn, Walldorf (DE); and Norman May, Karlsruhe (DE)
Assigned to SAP SE, Walldorf (DE)
Filed by SAP SE, Walldorf (DE)
Filed on Mar. 17, 2023, as Appl. No. 18/185,872.
Claims priority of application No. 202310134723.X (CN), filed on Feb. 17, 2023.
Prior Publication US 2024/0281344 A1, Aug. 22, 2024
Int. Cl. G06F 11/00 (2006.01); G06F 11/14 (2006.01)
CPC G06F 11/1469 (2013.01) [G06F 11/1451 (2013.01); G06F 11/1464 (2013.01)] 9 Claims
OG exemplary drawing
 
1. A computer-implemented method comprising:
receiving an instruction to recover a first database tenant of a first database instance to a first point in time, the first database tenant associated with first database artifacts of the first database instance, and the first database instance including two or more database tenants; and
in response to the instruction:
creating a second database instance;
selecting backup data of the first database instance based on the first point in time;
executing a recovery of the backup data on the second database instance;
exporting second database artifacts of the first database tenant from the second database instance to a storage;
copying the first database artifacts from the first database instance to the storage;
truncating the first database artifacts from the first database instance;
importing the second database artifacts from the storage to the first database instance;
determining whether the imported second database artifacts are valid;
if it is determined that the imported second database artifacts are not valid, restoring the copy of the first database artifacts from the storage to the first database instance; and
deleting the second database instance.