on 2022 Mar 30 6:04 PM
I am trying to evaluate how or even if UJBR should be used on a production BPC 10.1 Standard (HANA) environment.
There is a backup strategy for the companies HANA database which takes a backup every 10 minutes.
When we first went live on BPC we were using UJBR to take daily backups which we were keeping for about 90 days. However the backups stopped working recently.
It looks like I need to activate the option to split the backups over multiple files. In tests this was producing about 80 files.
My questions:
1. What value add does UJBR really provide. I can't imagine that it would ever be needed in a disaster recovery
2. How is it possible to handle so many files stored to the NetWeaver sever so that the different backups could be kept together and retained for a defined period of time
Thanks in advance for your advice,
Request clarification before answering.
I have found that UJBR backup was helpful in a case where the BPC admin had deleted some part of a data category , not noticed until about 3 months afterwards that he had done this and then had no way to recover it. In that case I restored an old UJBR backup to a new BPC environment , found the deleted data, exported it to csv file and then loaded back up into the production system.
In most cases the idea of restoring the whole production environment from UJBR is an unlikely scenario as you say
The way I have handled the files in the past has been
Create separate file locations for each backup e.g. 7 daily backups Mon Tue Wed etc then schedule 7 variants of the UJT_BACKUP_RESTORE_UI program. Schedule the monday job to write to Mon etc
Do the same thing for a weekly backup and schedule 4 jobs to each starting a week apart from each other and repeating every 4 weeks - writing to folders Week1 Week2 etc
Add a similar process for Monthly backups writing to folder Month 1 2 3 etc
For simpler data protection I usually set up a series of export to file data manager packages to copy out the current plan data category to daily files - again schedule Monday to write to a file called Monday.csv etc
A more programatic variation is described in the link below
Create Dynamic Prompt Files for BPC Data Manager (biconsultancysolutions.com)
hope this helps
Peter
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
13 | |
2 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.