LiveCache Backup Strategy

[Former Member]

What is the strategy to backup a livecache. I know it can be done through RSLVCBACKUP with variants.

But what is the recommended procedure?

Should I use SM36 or dba planning calendar to automate the livecache backup?

What is the strategy to be adopted for full, incremental backups i.e. daily, weekly etc?

Thx. Points to be rewarded for any kind of small help.

[Former Member · Accepted solution]

Hi Abdul,

Yes, you can backup livecache using RSLVCBACKUP with variants. I think u better use SM36 to automate the livecache backup.

Strategy, i cannot tell u the statndard strategy, but can give u the strategy used in our proj.

We do Online backup (incremental) every 8 hours, whcih might not be required for every proj (depends on changing the data volume). Anyways you will have redo logs available so any time u can restore if something happens to sytemduring these 8 hours.and we do offline backup weekly once at database level.

This might be helpful.

Regards,

Jagadeesh.

Pls reward points if it is helpful.

This

[Former Member · Accepted solution]

Thanks for the info. I have few queries.

1- How is a database structure check and consistency check performed?.

2- Should this be performed before backup or after backup?

3- I read in one OSS# 385808, which talks about checkpoints before backup with report /sapapo/om_checkpoint_write.

4- Can anybody provide the steps to be performed in a structured way?

(I mean checkpoint, then db check, then backup, then post-backup steps etc).

I need a step by step procedure.

Thanks a ton, in advance.

[former_member229109 · Accepted solution]

Hello Abdul,

If you have any questions about liveCache database please post the question at MAXDB/liveCache forum

1)

Please review the SAP note:

990602 FAQ: CCMS for MaxDB/SAP liveCache technology

2)

Please review the documentation at

http://maxdb.sap.com/currentdoc/default.htm -> Basic Information -> Concepts of the Database System -> Administration -> Backing Up and Restoring

&&

https://www.sdn.sap.com/irj/sdn/maxdb

< MaxDB Knowledge Center -> Key Topics -> 'Backup and Restore' >

****

You have the following options for performing-scheduling liveCache backups:

=> Backing Up liveCache: DBA Planning Calendar

=> Backing Up liveCache: Background Processing

&& you could also use the DBMGUI tool or dbmcli tool to run the liveCche data

and log backups.

Please see SAP note : 455154 liveCache backups with report RSLVCBACKUP

Questions:

-> What is the SAP Basis SP you have?

-> What is the SCM/APO version of your system?

-> What is the version < build > of the liveCache on your system?

3)

How you can use the central DBA Planning Calendar to back up the liveCache please see the SAP liveCache documentation in English < See the SAP note 767598 >:

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

< Database Administration in CCMS: SAP liveCache -> Central DBA Planning Calendar -> Backing Up liveCache: DBA Planning Calendar >

4)

You can use automate the liveCache backups (complete or incremental data backup, log backup) using the SAP background processing.

Please review the SAP documents at:

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

< Database Administration in CCMS: SAP liveCache ->

Terms and Procedures -> Backing Up liveCache: Background Processing >

****

5) !!!!

Please review the document:

"Backup and Recovery for SAP APO (3.x) / mySAP SCM (4.x)"

at service.sap.com/liveCache -> Release Information ->

Best Practices for Solution Management: mySAP SCM

***

6)

Please review the SAP note ::

521870 Database structure check (Verify/Check Data) of a liveCache

7)

"The SAP note : 385808 APO liveCache Backup

This note is valid for liveCache version less as 7.4 in APO 3.0. And the liveCache

version 7.2.5 and also APO 3.0 are out of maintenance < SAP note 610316 LiveCache maintenance strategy for APO 3.0 >.

Please review the release information at

service.sap.com/liveCache -> Release Information -> Go to corresponding Release Dependent section

As of liveCache version 7.4 the note 385808 is NOT valid any more !!!

Please read the document at

service.sap.com/scm -> SAP SCM Technology ->

Information on SCM 4.1 and prior releases

Information on SCM 4.1 and prior releases you will find <here>.

-> click on <here> -> Backup and Recovery ->

"SAP liveCache 7.4 : Backup and Recovery & Administration News (E) "

Thank you and best regards, Natalia Khlopina

[Former Member · Accepted solution]

Thanks Natalia for the OSS notes and the links.