比亚迪精密制造比亚迪SAP系统备份策略.docVIP

附件3 比亚迪SAP系统备份策略 一、Backup Strategy for Development System (DEV): Weekly SAP Database online backup + redo logs backup, issued by SAP DB13 Daily SAP archive log files backup, issued by SAP DB13 Fortnightly SAP SAP Database Offline Backup, issued by SAP DB13 Backup Contents Start Time Frequency Date Shutdown SAP Tape driver Backup Method Sap Database On-line Backup+redo logs backup 23:00 weekly Not a fixed day NO 3581 DB13 or sapdba Redolog backup 23:00 daily Not a fixed day NO 4mm DB13 or sapdba SAP Database Offline Backup 23:00 Fortnightly Not a fixed date No 3581 DB13 sapdba Everyday when you want to do the database online backup , the SAP system administrator should schedule an “whole online backup + redo log backup ”in SAP transaction DB13. This kind of backup can be used for DB restore and recovery. If shutting down the SAP system is not acceptable, it is O.K. to perform an online DB backup with redo log archive. All backup tapes will be kept aside for 4 weeks before being recycled. The tapes will be used for backup are as follows: Backup Contents Tapes Life Cycle Tapes needed Redo Logs backup 1 4mm tape 4 Weeks 24 Database online + redo log backup 1 3581 tape 4 Weeks 4 Database offline backup 1 3581 tape 4 Weeks 2 According to this strategy, if there is any failure about SAP database, we can first recovery the database by using the weekly database offline backup, if needed, we can roll-forward the database to any time point by applying the offline archive logs. 二、Backup Strategy for Production System (PRD): Daily SAP Database online backup + redo logs backup, issued by SAP DB13 Daily SAP archive log files backup, issued by SAP DB13 Fortnightly SAP SAP Database Offline Backup, issued by SAP DB13 Backup Contents Start Time Frequency Date Shutdown SAP Tape driver Backup Method SAP Database On-line Backup+ Redo Logs backup 23:00 Daily Every day No 3581 DB13 sapdba Redo logs backup 23:00 daily Everyday NO 4mm DB13 SAP Database Offline