Methods and systems for protecting multitenant databases in networked storage systems

A method executed by one or more processors for backing up a multitenant database instance having a plurality of tenant databases, the method comprising:

• during a first phase of a discovery operation, retrieving, by a first plugin, configuration information regarding the multitenant database instance and the plurality of tenant database from a database application managing the multitenant database instance, and authenticating a unique user key associated with the multitenant database instance to access the tenant databases and, information regarding data files corresponding to each of the plurality of tenant databases;
• mapping, by the plugin, each tenant database to a corresponding data file with a file path indicating a storage location where each data file is stored;
• during a second phase of the discovery operation, utilizing, by the first plugin, the mapping of each tenant database to the corresponding data file to retrieve a storage layout of each tenant database from a storage system storing data for each tenant database;
• generating, by the database application, an internal file to capture a state of the multitenant database instance and a state of each tenant database, in response to receiving a command from the first plugin to prevent modification of the multitenant database instance and the plurality of tenant databases;
• mapping, by the first plugin, a storage location of each internal file to a corresponding tenant database;
• generating, by the storage system, a backup of the multitenant database instance and the plurality of tenant databases;
• and storing the storage location of each internal file with backup metadata.

A system, comprising:

• a memory containing machine readable medium comprising machine executable code having stored thereon instructions for a plugin interfacing with a database application of a multitenant database instance having a plurality of tenant databases, the multitenant database instance configured as a logical container to present the plurality tenant databases;
• and a processor coupled to the memory, the processor configured to execute the machine executable code to:
• verify, by the plugin, for a restore operation to restore a first tenant database that the first tenant database is present in the multitenant database instance with a same identifier when a backup of the first tenant database was taken during a backup operation;
• select, by the plugin, a restore method for the restore operation based on using a storage area network (“SAN”) or a non-SAN based storage system type for storing the first tenant database;
• provide, by the plugin, a storage location of an internal file associated with the first tenant database to the database plugin for the restore operation, the internal file generated by the database application to capture a state of the multitenant database instance and a state of the first tenant database when the backup was taken, and the storage location of the internal file is stored with metadata of the backup by a storage system;
• and
• restore, by the database application, the first tenant database utilizing the internal file associated with the first tenant database, while processing requests for other tenant databases of the plurality of tenant databases.