Introduction
When instances crashes for any reason (e.g. Power failure) Oracle automatically recovers when database starts next time.
The most important decision you need to take for backup is to decide whether the database will run in archive or no archive log mode. Usually production databases always run in archive log mode.
Ideally, each member of archive log groups should reside in different physical disks so that if one disk gets corrupt, identical copies can be retrieved from another disk.
Backup can be either user managed (copying files with OS commands) or server managed (RMAN – Recovery Manager based). If you use RMAN, you can have incremental backups (i.e. backing up only changed blocks since last backup).
The most important decision you need to take for backup is to decide whether the database will run in archive or no archive log mode. Usually production databases always run in archive log mode.
Ideally, each member of archive log groups should reside in different physical disks so that if one disk gets corrupt, identical copies can be retrieved from another disk.
Backup can be either user managed (copying files with OS commands) or server managed (RMAN – Recovery Manager based). If you use RMAN, you can have incremental backups (i.e. backing up only changed blocks since last backup).
RMAN is not discussed in this book.
No comments:
Post a Comment