大型數(shù)據(jù)庫系統(tǒng)分析與設計：Less15-Backups

1、Performing Database BackupsObjectivesAfter completing this lesson, you should be able to do the following:Create consistent database backupsBack up your database without shutting it downCreate incremental backupsAutomate database backupsMonitor the flash recovery areaBackup Solutions OverviewBackups

2、 can be performed by using:Recovery ManagerOracle Secure BackupA user-managed scenarioOracle Secure BackupOracle Secure Backup and RMAN provide an end-to-end backup solution for Oracle environments:Centralized backup management to tape for file system data and the Oracle databaseProvides most well-i

3、ntegrated media management layer for RMAN backupsBackup of any data anywhere on the networkA single technical support resource for the entire backup solution expedites problem resolution.This ensures reliable data protection at lower cost and complexity.User-Managed BackupA user-managed scenario:It

4、is a manual process of tracking backup needs and status.It requires the DBA to write scripts.Database files must be put in the correct mode for backup.Operating system commands are used to make backups of files.TerminologyBackup strategy may include:The entire database (whole)A portion of the databa

5、se (partial)Backup type may be:All information from all data files (full)Only information that has changed since some previous backup (incremental)Backups mode may be:Offline (consistent, cold)Online (inconsistent, hot)TerminologyBackups may be stored as:Image copiesBackup setsData file #2Data file

6、#3Data file #4Data file #5Data file #1Data file #6Image copiesBackup setData file #1Data file #2Data file #3Data file #4Data file #5Data file #6Recovery Manager (RMAN)Enterprise Manager uses Recovery Manager (RMAN) to perform backup and recovery operations. RMAN:Is a command-line client for advanced

7、 functionsHas powerful control and scripting languageHas a published API that enables interface with most popular backup softwareBacks up data, control, archived log, and server parameter filesBacks up files to the disk or tapeConfiguring Backup SettingsConfiguring Backup SettingsScheduling Backups:

8、 StrategySelect whole or partial database backup.Scheduling Backups: OptionsScheduling Backups: SettingsScheduling Backups: ScheduleScheduling Backups: ReviewClick Edit RMAN Script to review RMAN commands.Back Up the Control File to a Trace FileControl files have an additional backup option. Control

9、 file trace backups may be used to recover from loss of all control files. Back Up the Control File to a Trace File Full Notes PageManaging BackupsFlash Recovery AreaMonitor the flash recovery area to:Configure flashback loggingSize the recovery areaView current space consumptionSummaryIn this lesson, you should have learned how to:Create consistent database backupsBack up your database without shutting it downCreate incremental backupsAutomate database backupsMonitor the flash recovery areaPractice Overview:Creating Database BackupsThis practice covers the following topics:Configuring you