Upgrade of MAXDB 7.5 to 7.6

[Former Member]

Hi all,

we've installed an Content Server 6.40 with MAXDB 7.6, and then we need to restore an backup from an MAXDB 7.5 where we have an SAP Content Server 7.5

After we try an Restore it gave us an error that the backup is not an valid incremental backup ... What can I do in this situation ?!?

I hope someone can help me...

Thanks, and best Regards,

Pedro Rodrigues

[Former Member · Accepted solution]

Hi Pedro,

you cannot restore a 7.5 backup into a 7.6 instance. Before restoring the incremental backup, did you restore a successful data backup?

Thanks,

Ashwath

[Former Member · Accepted solution]

Hi Ashwath,

thanks for your quick answer, and you're right. Thanks,

But when upgrade from an 7.3 to an 7.5 in phase load systab I've this error

-24909: ERR_DBAUNKNOWN - SYSDBA unknown

and I've tried command user_dba superdba,pass and it gaves me OK but then load_systab fails again with the same issue...

i'm completly sutck in here. I'm going to open a new message!!

[Former Member]

I think, you have next situation:

backup with internal SYSDBA user old_sysdba/old_sysdba_password and

new installation with SYSDBA user new_sysdba/new_sysdba_password

After restore SYSDBA user is wrong. You need perform load systab.

Solve:

Login as DBM or SYSDBA user, for example

<b>$> dbmcli -d <sid> -u <new_sysdba>,<new_sysdba_password></b>

load systab as old SYSDBA user:

<b>dbmcli> load_systab –u <old_sysdba_user>,<old_sysdba_password></b>

[Former Member]

The other thing to consider trying is the line from SAP Note 129352

that shows how to change the database users.

Here is the command used to change the owner of the

SAP database:

dbmcli -d <newsid> -u control,control -uSQL superdba,admin sql_execute

rename user SAP<SID> to SAP<NEWSID>

Hope that helps,

Joe Haynes

Helena, Montana