While still logged in as the <sid>adm user, execute the following query on the SystemDB using the hdbsql utility:
hdbsql -i 00 -n localhost:30013 -u SYSTEM -p <password> "SELECT DATABASE_NAME FROM M_DATABASES WHERE ACTIVE_STATUS = 'NO'"
The results returned are each of the tenant databases which have been invalidated during the recovery process of the SystemDB.
DATABASE_NAME
"SH1"
"SH2"
"SH3"
"SH4"
To recover the tenants execute the following using the hdbsql utility (needs to be run separately for each tenant):
hdbsql -i 00 -n localhost:30013 -u SYSTEM -p <password> "RECOVER DATA FOR <Tenant> USING SNAPSHOT CLEAR LOG"