The recoverSys.py script is the designated SAP HANA tool for reinitializing the system database (SYSTEMDB) in a multi-tenant environment. This tool is used in a critical recovery scenario where the SYSTEMDB's data and log volumes are lost or corrupted, and a recovery from a backup is not feasible. Executing this script effectively creates a new, clean system database, allowing the administrator to subsequently recover or re-register the tenant databases.

A. hdbrecovercheck: This command-line tool is used exclusively to verify the integrity and usability of existing SAP HANA data backups before attempting a recovery; it does not perform any recovery or reinitialization actions.

C. hdbmdcutil: This utility is used for administrative tasks on tenant databases within a functioning multi-tenant system, such as creating, dropping, or altering tenants. It does not operate on or reinitialize the system database itself.

D. RecoverUtil.py: This is not a recognized or standard SAP HANA command-line tool. The correct and officially documented script for reinitializing the system database is recoverSys.py.

1. SAP HANA Administration Guide for SAP HANA Platform 2.0 SPS07

Section: 11.5.1.3 Recovering the System Database with recoverSys.py. The guide states

"If the data and log areas of the system database are lost and can't be recovered from a backup

you can re-create the system database using the Python script recoverSys.py." This directly confirms its use for a non-recoverable system database.

2. SAP HANA Administration Guide for SAP HANA Platform 2.0 SPS07

Section: 11.5.2.1 Checking Recoverability of Data Backups with hdbrecovercheck. This section details the function of hdbrecovercheck

confirming it is a verification tool: "You can use the tool hdbrecovercheck to check whether a data backup can be used for a recovery."

3. SAP HANA Administration Guide for SAP HANA Platform 2.0 SPS07

Section: 3.3.2.2 Administration of Tenant Databases with hdbmdcutil. This section describes the purpose of hdbmdcutil: "You can use the command line tool hdbmdcutil to perform administrative tasks on tenant databases." This clarifies it is for tenant management

not SYSTEMDB recovery.