太太药业太太药业SAP备份及恢复流程.docVIP

SAP 备份及恢复流程 Author: 陶朝晖 Date: May.23, 2002 Version: 1.0  Content Purpose 3 Backup Strategy 3 Backup Tool 3 Backup Device 3 Backup Contents 3 Backup Scheme 4 Tape Storage 5 There are two ways to check status of backup 5 Recovery Strategy 6 Restore Tool 6 Restore Device 6 Restore Contents 6 Recovery Scheme 6 Complete Recovery 6 Incomplete Recovery 8 Special cases 10 Appendix 13 I. Steps of SAP Archive 13 II. Steps of SAP Online Backup 14 III. Steps of SAP Offline Backup 16 IV. Daily Recorder Report 18 V . Contents in tape 19 VI. Tape management 21 VII. Structure Changes (Control Files ) 23 VIII. ORA-01149 or ORA-01113 for missing end backup 24 Purpose This document defines the backup policy to ensure regular, correct backup procedures are carried out and data integrity is kept. This document describes backup strategy. In the event of loss of data occurring, the system can therefore be restored as quickly and as fully as possible. This document also defines the recovery procedures to ensure system would be up as quickly and as fully as possible in case of system down. Backup Strategy The recommended method is tape backup. Backup Tool Using the DBA Planning Calendar (transaction DB13) Using the SAP database administration tool SAPDBA at operating system level Directly, at the operating system level ( brarchive/brbackup, tar/dump ) Using hp backup tools omni . Backup Device Tape driver: 24GB DLT Backup Contents Data Files Control files Profiles Online redo log files Offline redo log files Operating system files Tape Name Convention and Initialization Tape used for brbackup are always named as follows, SIDB01, SIDB02, SIDB03, SIDB04, SIDB05, SIDB06, Tape used for brarchive are always named as follows, SIDA01, SIDA02, SIDA03, SIDA04 SIDA05, SIDA06, Perform the tape initialization procedure as follows: Set the initSID.sap parameters volume_backup and volume_archive. In this example: volume_backup=(SIDB01, SIDB02, SIDB03, SIDB04) volume_archive=(SIDA01, SIDA