How To Perform Recovery of SYSTEM Database/TENANAT Database in SAP HANA Multitenant database containers

Multitenant database containers Overview

Use SAP HANA Studio or SQL commands to recover the system database.
Caution: The whole system will be shut down, including all tenant databases

  1.  You need the <sid>adm operating system user credentials for recovering the system database
  2. The system database can only be recovered to the latest state
  3. Only the system database will be recovered, the content of the tenant databases is not affected

 Multitenant database containers: Recovering the system database

Caution: The whole system will be shut down, including all tenant databases

  •  You need the <sid>adm operating system user credentials for recovering the system database
  •  The system database can only be recovered to the latest state
  • Only the system database will be recovered, the content of the tenant databases is not affected

saphanasystemdbrecovery

Multitenant database containers: Recovering a tenant database

Tenant databases can be recovered to the latest state, a point in time, or to a specific backup

  • The system database and all other tenant databases are not affected by the recovery of an individual tenant
    database
  • Recovery of a tenant database can only be initiated from the system database

saphanawikitenantdbrecovery

Reference :SAP HANA Backup/Recovery

Tags:, , , , , , , , , , , , , , , , , , , , , , , , ,

Leave a Reply