Learn how Oracle reconstructs your data using a hotbackup, by reading his careful discussion on the topic. For instance during an Oracle hotbackup, did you know that changes to datafiles are *NOT* frozen. So I read the chapters on Oracle and MySQL very carefully. I have worked on Unix for years and years, but my sweet spot is working with databases. ![]() Preston doesn't let anything through the cracks. And lastly, don't forget testing and verifying your backups. What are you backing up and why? How often, and using what method? Roll-your-own solution scripting with unix utils like dd, cpio, or tar, go with an open source solution such as Amanda, Bacula, or BackupPC, or consider various commercial solutions. He starts the book with the basics, what backing up is all about, why you do it, and what to consider. Each of the different databases alone do things differently, and have a lot of different concepts, and vernacular to describe it. What I was struck by most of all, after reading it, is his clear breadth of knowledge in the subject of backups. Preston though, succeeds, and succeeds with flying colors. In addition he also covers OS backups on Solaris, Linux, AIX, HP-UX, and Mac OS X. With individual chapters on every database from DB2, Oracle and Sybase to MySQL, Postgres and SQL Server. ![]() When I picked up this text, I kind of expected it to be a bit sparse in some areas.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |