Upgrade with Backup and Recovery 

Use

You are using the program SDBUPD to upgrade the database instance. First make a complete data backup for the database instance that you want to update. Then use SDBUPD to switch the software.

You use this upgrade strategy if your database instance is part of an SAP system. This strategy is currently valid only for the instance type liveCache in the SAP APO system, when you are changing the version of the database software without changing the APO release (Selection of the Upgrade Strategy).

It is valid for all supported operating system platforms.

There can not be any remote communication between the database instances and applications during the upgrade, since the V Server software (X Server service) may need to be switched, depending on the source and target version of the upgrade. Therefore, stop all database instances, so that SDBUPD can stop any X Servers that are still running. Alternatively, you can stop the X Server yourself, before the upgrade.

Prerequisites

·        You have stopped all database instances, or, alternatively, the X Server.

·        The database parameters of the database instance you want to upgrade have not changed since the last restart.

·        You have made a complete data backup in the operational state COLD (up to Version 7.3) or ADMIN (from Version 7.4), and have not switched the database instance to the operational state ONLINE.

Procedure

...

       1.      Start SDBUPD with the following command:

UNIX, Linux:	Microsoft Windows:
./SDBUPD –d <database_name> -u <dbm_user>,<password>	sdbupd –d <database_name> -u <dbm_user>,<password>

SDBUPD updates the software. You see a message about the successful installation of the software, and are prompted to recover the database instance from the backup.

       2.      Log on to the Database Manager CLI with the data from the backed up database instance, and start the database instance recovery.

       3.      Exit the Database Manager CLI with the command exit | release | quit | bye.

       4.      Restart SDBUPD with the following command:

UNIX, Linux:	Microsoft Windows:
./SDBUPD –d <database_name> -u <dbm_user>,<password>	sdbupd –d <database_name> -u <dbm_user>,<password>

SDBUPD loads the system tables, and displays a success message if completed successfully. It then flags the installation as complete.

       5.      Now start liveCache, so that the system can update it (Starting liveCache).

Result

The liveCache database instance in the SAP APO system and its software have been upgraded.

liveCache is in the operational state ONLINE.