Oracle 9i. Backup and Recovery Concepts

Ashdown L.

This manual is intended for database administrators who perform backup and recovery of an Oracle database server.To use this document, you need to know the following:■ Relational database concepts and basic database administration as described in Oracle9i Database Concepts and Oracle9i Database Administrator’s Guide■ The operating system environment under which you are running Oracle”

---

Table of contents :
Contents……Page 3
Send Us Your Comments……Page 7
Preface……Page 9
1 Backup and Recovery Overview……Page 15
Oracle Recovery: Basic Concepts……Page 16
Media Failure……Page 18
User Error……Page 20
Database Instance Failure……Page 21
Process Failure……Page 22
Redo Logs……Page 23
Rollback and Undo Segments……Page 24
NOARCHIVELOG Mode……Page 25
ARCHIVELOG Mode……Page 26
Oracle’s Backup and Recovery Solutions……Page 29
Feature Comparison of Backup Methods……Page 30
2 Backup Principles……Page 33
Logical Backups……Page 34
Whole Database Backups……Page 35
Tablespace Backups……Page 36
Control File Backups……Page 38
Archived Redo Log Backups……Page 39
Consistent Backups……Page 40
Inconsistent Backups……Page 41
Backups of Online Tablespaces and Datafiles……Page 43
RMAN Backups……Page 44
User-Managed Backups……Page 45
3 Recovery Principles……Page 47
Instance and Crash Recovery……Page 48
Media Recovery……Page 49
Redo Application During Recovery……Page 50
Cache Recovery……Page 51
Transaction Recovery……Page 52
Complete Recovery……Page 53
Incomplete Recovery……Page 54
RMAN Restore and Recovery……Page 55
User-Managed Restore and Recovery……Page 56
4 Backup and Recovery Strategies……Page 59
Obeying the Golden Rule of Backup and Recovery……Page 60
Choosing the Database Archiving Mode……Page 62
Performing Backups Frequently and Regularly……Page 64
Backing Up Often-Used Tablespaces……Page 65
Performing Whole Database Backups After Opening with the RESETLOGS Option……Page 66
Knowing the Constraints for Distributed Database Backups……Page 67
Avoiding the Backup of Online Redo Logs……Page 68
Keeping Records of the Hardware and Software Configuration of the Server……Page 70
Testing Backup and Recovery Strategies……Page 71
Planning a Response to Media Failures……Page 72
Planning a Response to Datafile Block Corruption……Page 74
Planning the Response to Non-Media Failures……Page 75
Glossary……Page 77
Index……Page 119