Hallo Andrea,
I think I can't show you a definitive way how to upgrade your SAP DB database.
Things are more complicated then they should be, but I dont know how to make it easier.
All SAP DB databases in SAP systems are installed using SDBINST and there is only one
database per database kernel software directory, aka dependent directory. So you can
easily use SDBUPD to update your database from 7.3 to 7.4 or implement patches to the
database software.
There are rpm-based installations available for Linux and you cannot easily update
your database instance while updating your database software when you are using the
rpm based installation. And of cause you can have many databases per database kernel
software directory even if you are using SDBINST. SDBUPD can't help you for the rpm
installation, bacause you can use either rpm or SDBINST. If you would have many
databases, and SDBUPD would update all of them during the software update, and one
database update would fail, all instances could be lost.
A detailed description will be found in the "Installation Manual".
For now a description how to update to SAP DB 7.4.3, if you use SDBUPD:
1.) database version is 7.3.00 Build 25 or higher,
instance type is OLTP
database is in state WARM,
system tables are loaded,
database parameters have not been changed since last restart
2.) stop the database 'dbmcli -d <dbname> -u <usr,pwd> db_offline'
3.) start database in COLD mode 'dbmcli -d <dbname> -u <usr,pwd> db_offline'
4.) make a complete data backup
or alternatively as of SAPDB 7.4.03 Build 012 or higher a incremental backup and a
log backup
'dbmcli -d <dbname> -u <usr,pwd> backup_start <medium>'
5.) run SDBUPD, you must not start the database after the backup
'./SDBUPD -d <dbname> -u <usr,pwd>
6.) Your database is updated to 7.4.3 and ONLINE
Btw: you are right, the guide could be misunderstood, we will change it.
regards,
Christoph Bautz
> Bautz, Christoph wrote:
>> Hallo Andrea,
>>
>...
>>
>> It's really sorry that we cannot take a look at the log files.
>
>Uhm... if I find some spare time I will try again to do an sdbinst and
>tell you what happened.
>
>>> * after a successful upgrade, I tried sdbupd to update a database instance,
>>> and kernel.exe crashed leaving me with an unusable db. The knldiag files
>>> should contain informations about it. (btw, I sent this file also to
>>> Martin Brunzema this morning)
>>
>> You can use either SDBINST or SDBUPD. Both programs are updating the software,
>> but only SDBUPD is updating the database instance too. SDBUPD is doing the
>> preparation
>> of the database for migration, the software update and update of the database
>> instance for you.
>> If you are using SDBINST to update you
>> database software from SAP DB 7.3 to SAP DB 7.4 you have to take care the all data
>> are migrated.
>> If you are using SDBINST you have to follow the steps in
>> http://www.sapdb.org/7.4/pdf/migration73_74eng.pdf.
> Ah, I see. But the guide I read the first time said to do first a sdbinst and then a
> sbdupd,
> as if sdbupd upgraded only the database instances and sdbinst only the software.
> Moreover, in another mail you say that a cold complete backup of data and log is
> needed
> before running sdbupd when upgrading from 7.3 to 7.4, and the instructions on pdf
> doesn't
> say to do it.
> Would you be so kind to post on the ml the complete list of steps needed
> to upgrade a production server from 7.3 to 7.4 without parallel install? A single,
> definitive
> instruction on the matter, instead what we have now (that is, a couple of guides and
> some
> mails that a user has to put togheter and mix to his preference hoping to find the
> right
> way to do an update).
> Best regards
> Andrea Aime
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
