Integrating SAP DB/MaxDB and Data Protector

Restoring an SAP DB/MaxDB Database

If you select a Trans or a Diff backup session, you are given a possibility to:

•Perform a full restore of the database (the Full restore of database option). In this case, the integration automatically determines the chain of needed full, differential or transactional backup sessions when performing a restore. After the restore has finished, the database is, if the Recovery option is selected, switched to the Online mode.

•Restore only the selected backup session (the Restore only this backup option). If a database becomes consistent after such a restore and if the Recovery option is selected, it is switched to the Online mode. Otherwise, the database is left in the Admin mode.

Restoring only the selected trans or diff backup session is useful if the database remains offline or in the Admin mode after a restore from full backup session, which is then followed by a restore from diff or trans backup session.

Click OK to close the Properties for Data dialog box.

4.Click the Options tab to set the restore and recovery options. See “SAP DB/MaxDB Restore and Recovery Options” on page 304 for more information on SAP DB/MaxDB restore and recovery options.

5.Click Restore to start the restore session.

When the session starts, messages are displayed in the Results Area. Upon successful completion, a message is issued in the Session Information dialog box.

Restoring Using the Data Protector CLI

When performing an SAP DB/MaxDB migration, some additional tasks must first be done in order to prepare the SAP DB/MaxDB Server or instance. These tasks are described in the“SAP DB/MaxDB Migration Prerequisites” on page 294.

Finding Information Needed for a Restore

To find the information needed for a restore, follow the steps below:

Execute the following commands:

•omnidb -sapdb

Chapter 3

297