Backup and Recovery
No database solution—hosted or in-house—would be complete without proper backup and recovery procedures. In fact the importance of getting a system back at any time within the limits of the service level agreements is of paramount importance. Backup and recovery complement the disaster recovery solution, which you read about in Chapters 9 and 10. In many ways you cannot have just the one solution—backups or a DR site—since large databases might take too long to be restored and rolled forward. It is important to keep in mind that the shared hosting platform is indeed shared, including the backup infrastructure. So if there is a separate tape library available to the shared platform, then you can almost certainly assume that there are going to be delays accessing it. Depending on your service level agreement it can be safer to invoke the standby database, and then rebuild the failed primary. For all other cases the restore and recovery are of course sufficient.