Best Practices for Oracle 11g Backup and Recovery using RMAN and Dell EqualLogic Snapshots
ii
Table of Contents
1
Introduction – key database administration challenges ............................................................................ 5
1.1 How this paper can help you meet these challenges ........................................................................ 5
1.2 Audience ..................................................................................................................................................... 6
1.3 The rest of this paper ................................................................................................................................ 6
2 Oracle backup and recovery strategies overview ........................................................................................ 7
3 Backup solution architecture .......................................................................................................................... 9
3.1 Database layout ....................................................................................................................................... 10
4 Test design and results: RMAN ......................................................................................................................13
4.1 RMAN full backup and recovery ............................................................................................................13
4.1.1 Database backup time: RMAN full backup .................................................................................. 15
4.1.2 Performance impact: RMAN full backup ...................................................................................... 15
4.1.3 Database complete recovery time: RMAN full backup............................................................. 16
4.2 RMAN incremental backup and recovery ........................................................................................... 16
4.2.1 Database backup time: RMAN incremental ................................................................................ 16
4.2.2 Performance impact: RMAN incremental backup ..................................................................... 17
4.2.3 Database complete recovery time ................................................................................................ 17
5 Test design and results: RMAN offload using EqualLogic snapshots .................................................... 18
5.1 EqualLogic volume and snapshot collections ................................................................................... 20
5.2 Virtualized backup server ....................................................................................................................... 22
5.3 Backup and recovery procedure using EqualLogic snapshots and RMAN ................................... 22
5.4 Performance impact ............................................................................................................................... 23
5.5 Database complete recovery time ....................................................................................................... 23
6 Test design and results: point-in-time recovery using Oracle FLASHBACK DATABASE vs.
EqualLogic snapshots ............................................................................................................................................. 24
6.1 Point-in-time recovery using Oracle FLASHBACK DATABASE ....................................................... 24
6.2 Point-in-time recovery using EqualLogic snapshots ........................................................................ 25
6.3 Point-in-time recovery using FLASHBACK DATABASE and EqualLogic snapshots – test results
26
7 Conclusions from test results ....................................................................................................................... 27
7.1 Database backup – key observations .................................................................................................. 27
7.2 Database recovery – key observations ............................................................................................... 28