Restore backup of a Non Unicode to a Unicode Live Cache

[Former Member]

Hi Experts,

How can I restore backup of a Non Unicode to a Unicode Live Cache, and the reverse?

Is there any parameter settings I need to do?

Thanks,

Naren

[former_member229109 · Accepted solution]

Hello Naren,

If you would like to do the Homogenous liveCache copy using backup/restore

Procedure please review the SAP notes::

457425 Homogenous liveCache copy using backup/restore

877203 Post steps after the Homogenous liveCache copy usi...

"How can I restore backup of a Non Unicode to a Unicode Live Cache, and the reverse? "

-> You need to create the target liveCache instance with initialization for the restore & change the liveCache parameter _UNICODE to the same value as in source liveCache in the 'Param Init' step.

"param_getexplain _UNICODE":

_UNICODE = 'YES' or 'NO'

'YES': Identifiers of database objects are stored in UNICODE

'NO' : Identifiers of database objects are stored in ASCII

Thank you & best regards, Natalia Khlopina

[Former Member]

Hi Natalie,

I tried to change the parameter _UNICODE during the Initialize Databse Intance, but there was Error saying that it's a read only parameter.

The description :-

" This parameter cannot be modified after the installation of the

SERVERDB. _UNICODE = 'YES' or 'NO' "

Thanks,

Naren

[former_member229109]

Hello Naren,

The answer on the above your reply is 'NO'.

-> Could you please explain in more details what you are going to do.

For SAP liveCache documentation in English < See the SAP note 767598 >:

http://help.sap.com/saphelp_nw04/helpdata/en/f2/0271f49770f0498d32844fc0283645/frameset.htm

&&

http://maxdb.sap.com/currentdoc/default.htm

1)

You have to initialize the liveCache, or you want to convert your system to Unicode, please see the recommended steps in the note::

632357 Backing up liveCache data for SCM 4.0 or higher < !! >

And you could use this note for the migration of the non-unicode liveCache data

to the unicode liveCache.

2) You can use transaction LC10, the DBM GUI or the dbmcli command when the liveCche is offline:

dbmcli -d <SID> -u control,<control> param_directput DEFAULT_CODE Unicode

Check if the _UNICODE parameter is set to YES. You can use transaction LC10,

the DBM GUI or the dbmcli command to carry out this adjustment:

dbmcli -d <SID> -u control,<control> param_directget _UNICODE

dbmcli -d <SID> -u control,<control> param_directput _UNICODE YES

-> run in DBMGUI 7.6

=> Connect to the (A) database -> Instance < Top menu > -> Initialize ->

... Adjust Parameters :

search _UNICODE in Extended folder & check that it set to 'YES' -> ...

-> Creation Mode: select 'Create instance for Recovery' if you need -> ...

-> "Next" to Recovery Wizard & Restore a medium. Create the medium pointed

to the databackup of the UNICODE liveCache instance transferred to the source server. Finish the steps & when the Recovery will be finished successfully,

check if the liveCche is restartable.

Thank you & best regards, Natalia Khlopina

[Former Member]

Hi Natalie,

I plan to restore Live Cache from instance (B) to (A), but I plan to change the instance (B) later to Unicode (_UNICODE to Yes).

I would like to keep LiveCache of instance (A) as unicode as it is, since rest of the system in the landscape is unicode.

I'm using DBM Gui 7.6

Looks like I need to re-initialize instance (B) to change (_UNICODE to Yes) ...

Thanks,

Naren

[Former Member]

Hi Natalie,

I have a Live Cache same version running on Unicode (A), for this how can I take a backup of a Non-Unicode (B) running Live cache and do a recovery on (A).

Thanks

Naren

[former_member229109]

Hello Naren,

If you would like to do the Homogenous liveCache copy using backup/restore

Procedure of the a Non-Unicode (B) running Livecache to a LiveCache same

version running on Unicode (A) => You can NOT do so.

Please review the SAP notes::

457425 Homogenous liveCache copy using backup/restore

886103 System Landscape Copy for SAP SCM

-> Please check "Reason and Prerequisites" of the SAP note 457425 first.

Please update with the output of the following commands on the (A) & (B)

servers:

dbmcli -d <SID> -u control,<control> show version

dbmcli -d <SID> -u control,<control> param_directget _UNICODE

-> After you checked "Reason and Prerequisites" of the SAP note 457425 & it

could be applied, please let me know if you run the complete SCM system copy

or only liveCache. What is the reason to create the liveCache copy?

Answers on your last questions are, for example, using DBMGUI tool:

-> You could create the complete databackup using the DBMGUI tool for

the liveCache instance (B), Non-Unicode & the liveCache parameter _UNICODE value is NO.

-> Recreate the target liveCache instance (A) with initialization for the restore

using the DBMGUI &

change the liveCache parameter _UNICODE to NO as in source liveCache

in the 'Param Init' step.

What version of the DBMGUI you have?

If the liveCache instance (A) was already created, & you run in DBMGUI 7.6

=> Connect to the (A) database -> Instance < Top menu > -> Initialize ->

... Adjust Parameters :

search _UNICODE in Extended folder & change to 'NO' -> ...

-> Creation Mode: select 'Create instance for Recovery' -> ...

-> "Next" to Recovery Wizard & Restore a medium. Create the medium pointed

to the databackup of the liveCche instance (B) transferred to the server

(A). Finish the steps & when the Recovery will be finished successfully,

check if the liveCche is restartable.

Thank you & best regards, Natalia Khlopina