Database Design And Recovery {1}

by Ming X
The article I read is called Database Recovery Options, by Lockwood Lyon. The backups of application data are very important and sufficient for any recovery needs. There should be a recovery strategy applied from the beginning, starting with database design. The author mentions that there are two things database designer must know; the recovery time objective (how long can the application data (or portions of the data) be unavailable?) and the recovery point objective (to what point must data be recovered? To a specific date/time? To the end of the most recently completed transaction?). It’s not only the database design that needs to consider recovery needs; applications that access the data must also be designed with recovery in mind. And at last, there should be a the infrastructure team supporting them. The author also mentions several database backup options for recovery; including database unloads, database full image copies, hot standby and Disk mirroring. read more...