on 03-25-2014 11:51 AM
Hi all,
I have been tasked with sorting out the backups for our SAP Content Server 6.40 running MaxDB 7.6.
I have since discovered that there is no backup of redo logs occurring.
Having read the MaxDB 7.6 documentation about backups, it doesn't seem to suggest a backup strategy although it does give an example SAP Library - Basic Information
However I am considering the following strategy.
1) Full online backup (already happens - I recently got this working properly with Omniback 6.11, by setting DBM_KTO_SUCCESS = 1800)
2) Automatic log backups every 30mins (currently not set to time interval)
3) Archiving log backups every ?
As it stands there is no back up of the redo logs to tape and they are only written to the logs when log segment reaches 3.33GB (1/3) the size of the database is reached. Which doesn't happen often as we are only storing word documents in the Content Server.
So to minimize a disk failure during the day, I want to override the log backups hence setting it to every 30mins.
Anyone got any suggestions or comments to my thinking here?
Thanks
Craig
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Craig,
please check the following expert session / recording and Slides) where we discuss the Backup/Recovery issues especially in Content Server environment.
Alll sessions can be found here:
SAP MaxDB: The SAP Database - Training
You will find the slides:
http://maxdb.sap.com/training/expert_sessions/SAP_MaxDB_Content_Server_Housekeeping.pdf
and the recording: http://maxdb.sap.com/training/expert_sessions/SAP_MaxDB_Content_Server_Housekeeping.mp4
hope this answers your questions.
Regards, Christiane
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Craig,
From my experience I would suggest the following
1) Full DB backup : online everyday post business hours
2) Log backup : Configure Auto log backup to disk. Then take disk backup to tape once in a day post business hours
3) Suggestion is to configure one offline backup once every month.
4) File system backup after every OS or DB patch.
Hope this helps.
Regards,
Deepak Kori
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Craig,
Problem with only taking a archive log backup once a day is if the disks fail storing the logs during the day then you have lost the ability to restore changes from that day.
You need to keep disks storing the logs with disks configured on RAID 1+0 ( mirrored disks).
So if one disk fails you still have another disk storing the information and which can be retained.
Hope this helps.
Regards,
Deepak Kori
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.