Backup & Recovery: Inexpensive Backup Solutions for Open Systems

Backup & Recovery......Page 0
Table of Contents......Page 1
Copyright......Page 7
Preface......Page 8
Part 1:  Introduction......Page 25
1.  The Philosophy of Backup......Page 26
Section 1.1.  Champagne Backup on a Beer Budget......Page 27
Section 1.2.  Why Should I Read This Book?......Page 28
Section 1.3.  Why Back Up?......Page 32
Section 1.4.  Wax On, Wax Off: Finding a Balance......Page 35
2.  Backing It All Up......Page 39
Section 2.1.  Don\'t Skip This Chapter!......Page 40
Section 2.2.  Deciding Why You Are Backing Up......Page 43
Section 2.3.  Deciding What to Back Up......Page 44
Section 2.4.  Deciding When to Back Up......Page 52
Section 2.5.  Deciding How to Back Up......Page 59
Section 2.6.  Storing Your Backups......Page 68
Section 2.7.  Testing Your Backups......Page 72
Section 2.8.  Monitoring Your Backups......Page 73
Section 2.9.  Following Proper Development Procedures......Page 75
Section 2.10.  Unrelated Miscellanea......Page 76
Section 2.11.  Good Luck......Page 80
Part 2:  Open-Source Backup Utilities......Page 81
3.  Basic Backup and Recovery Utilities......Page 82
Section 3.1.  An Overview......Page 83
Section 3.2.  Backing Up and Restoring with ntbackup......Page 88
Section 3.3.  Using System Restore in Windows......Page 91
Section 3.4.  Backing Up with the dump Utility......Page 94
Section 3.5.  Restoring with the restore Utility......Page 109
Section 3.6.  Limitations of dump and restore......Page 119
Section 3.7.  Features to Check For......Page 120
Section 3.8.  Backing Up and Restoring with the cpio Utility......Page 122
Section 3.9.  Backing Up and Restoring with the tar Utility......Page 136
Section 3.10.  Backing Up and Restoring with the dd Utility......Page 145
Section 3.11.  Using rsync......Page 149
Section 3.12.  Backing Up and Restoring with the ditto Utility......Page 154
Section 3.13.  Comparing tar, cpio, and dump......Page 159
Section 3.14.  Using ssh or rsh as a Conduit Between Systems......Page 162
4.  Amanda......Page 164
Section 4.1.  Summary of Important Features......Page 169
Section 4.2.  Configuring Amanda......Page 177
Section 4.3.  Backing Up Clients via NFS or Samba......Page 182
Section 4.4.  Amanda Recovery......Page 185
Section 4.5.  Community and Support Options......Page 187
Section 4.6.  Future Plans......Page 188
5.  BackupPC......Page 189
Section 5.1.  BackupPC Features......Page 190
Section 5.2.  How BackupPC Works......Page 191
Section 5.3.  Installation How-To......Page 194
Section 5.4.  Starting BackupPC......Page 199
Section 5.5.  Per-Client Configuration......Page 201
Section 5.6.  The BackupPC Community......Page 202
Section 5.7.  The Future of BackupPC......Page 203
6.  Bacula......Page 204
Section 6.1.  Bacula Architecture......Page 205
Section 6.2.  Bacula Features......Page 210
Section 6.3.  An Example Configuration......Page 213
Section 6.4.  Advanced Features......Page 221
Section 6.5.  Future Directions......Page 225
7.  Open-Source Near-CDP......Page 227
Section 7.1.  rsync with Snapshots......Page 228
Section 7.2.  rsnapshot......Page 241
Section 7.3.  rdiff-backup......Page 245
Part 3:  Commercial Backup......Page 249
8.  Commercial Backup Utilities......Page 250
Section 8.1.  What to Look For......Page 252
Section 8.2.  Full Support of Your Platforms......Page 253
Section 8.3.  Backup of Raw Partitions......Page 255
Section 8.4.  Backup of Very Large Filesystems and Files......Page 256
Section 8.5.  Aggressive Requirements......Page 257
Section 8.6.  Simultaneous Backup of Many Clients to One Drive......Page 267
Section 8.7.  Disk-to-Disk-to-Tape Backup......Page 269
Section 8.8.  Simultaneous Backup of One Client to Many Drives......Page 270
Section 8.9.  Data Requiring Special Treatment......Page 272
Section 8.10.  Storage Management Features......Page 274
Section 8.11.  Reduction in Network Traffic......Page 280
Section 8.12.  Support of a Standard or Custom Backup Format......Page 283
Section 8.13.  Ease of Administration......Page 286
Section 8.14.  Security......Page 289
Section 8.15.  Ease of Recovery......Page 291
Section 8.16.  Protection of the Backup Index......Page 293
Section 8.17.  Robustness......Page 296
Section 8.18.  Automation......Page 297
Section 8.19.  Volume Verification......Page 298
Section 8.20.  Cost......Page 300
Section 8.21.  Vendor......Page 301
Section 8.22.  Final Thoughts......Page 302
9.  Backup Hardware......Page 303
Section 9.1.  Decision Factors......Page 304
Section 9.2.  Using Backup Hardware......Page 312
Section 9.3.  Tape Drives......Page 315
Section 9.4.  Optical Drives......Page 328
Section 9.5.  Automated Backup Hardware......Page 333
Section 9.6.  Disk Targets......Page 335
Part 4:  Bare-Metal Recovery......Page 347
10.  Solaris Bare-Metal Recovery......Page 348
Section 10.1.  Using Flash Archive......Page 349
Section 10.2.  Preparing for an Interactive Restore......Page 353
Section 10.3.  Setup of a Noninteractive Restore......Page 361
Section 10.4.  Final Thoughts......Page 369
11.  Linux and Windows......Page 370
Section 11.1.  How It Works......Page 371
Section 11.2.  The Steps in Theory......Page 377
Section 11.3.  Assumptions......Page 382
Section 11.4.  Alt-Boot Full Image Method......Page 383
Section 11.5.  Alt-Boot Partition Image Method......Page 386
Section 11.6.  Live Method......Page 390
Section 11.7.  Alt-Boot Filesystem Method......Page 393
Section 11.8.  Automate Bare-Metal Recovery with G4L......Page 397
Section 11.9.  Commercial Solutions......Page 400
12.  HP-UX Bare-Metal Recovery......Page 401
Section 12.1.  System Recovery with Ignite-UX......Page 402
Section 12.2.  Planning for Ignite-UX Archive Storage and Recovery......Page 409
Section 12.3.  Implementation Example......Page 414
Section 12.4.  System Cloning......Page 422
Section 12.5.  Security......Page 423
Section 12.6.  System Recovery and Disk Mirroring......Page 424
13.  AIX Bare-Metal Recovery......Page 425
Section 13.1.  IBM\'s mksysb and savevg Utilities......Page 426
Section 13.2.  Backing Up with mksysb......Page 431
Section 13.3.  Setting Up NIM......Page 441
Section 13.4.  savevg Operations......Page 444
Section 13.5.  Verifying a mksysb or savevg Backup......Page 445
Section 13.6.  Restoring an AIX System with mksysb......Page 446
Section 13.7.  System Cloning......Page 449
14.  Mac OS X Bare-Metal Recovery......Page 450
Section 14.1.  How It Works......Page 451
Section 14.2.  A Sample Bare-Metal Recovery......Page 454
Part 5:  Database Backup......Page 460
15.  Backing Up Databases......Page 461
Section 15.1.  Can It Be Done?......Page 462
Section 15.2.  Confusion: The Mysteries of Database Architecture......Page 464
Section 15.3.  The Muck Stops Here: Databases in Plain English......Page 465
Section 15.4.  What\'s the Big Deal?......Page 466
Section 15.5.  Database Structure......Page 467
Section 15.6.  An Overview of a Page Change......Page 477
Section 15.7.  ACID Compliance......Page 480
Section 15.8.  What Can Happen to an RDBMS?......Page 481
Section 15.9.  Backing Up an RDBMS......Page 483
Section 15.10.  Restoring an RDBMS......Page 489
Section 15.11.  Documentation and Testing......Page 493
Section 15.12.  Unique Database Requirements......Page 494
16.  Oracle Backup and Recovery......Page 495
Section 16.1.  Two Backup Methods......Page 496
Section 16.2.  Oracle Architecture......Page 499
Section 16.3.  Physical Backups Without rman......Page 510
Section 16.4.  Physical Backups with rman......Page 518
Section 16.5.  Flashback......Page 526
Section 16.6.  Managing the Archived Redo Logs......Page 528
Section 16.7.  Recovering Oracle......Page 530
Section 16.8.  Logical Backups......Page 569
Section 16.9.  A Broken Record......Page 571
17.  Sybase Backup and Recovery......Page 572
Section 17.1.  Sybase Architecture......Page 573
Section 17.2.  The Power User\'s View......Page 577
Section 17.3.  The DBA\'s View......Page 581
Section 17.4.  Protecting Your Database......Page 587
Section 17.5.  Backup Automation Through Scripting......Page 595
Section 17.6.  Physical Backups with a Storage Manager......Page 599
Section 17.7.  Recovering Your Database......Page 600
Section 17.8.  Common Sybase Procedures......Page 604
Section 17.9.  Sybase Recovery Procedure......Page 609
18.  IBM DB2 Backup and Recovery......Page 617
Section 18.1.  DB2 Architecture......Page 618
Section 18.2.  The backup, restore, rollforward, and recover Commands......Page 627
Section 18.3.  Recovering Your Database......Page 640
19.  SQL Server......Page 649
Section 19.1.  Overview of SQL Server......Page 650
Section 19.2.  The Power User\'s View......Page 652
Section 19.3.  The DBA\'s View......Page 656
Section 19.4.  Backups......Page 661
Section 19.5.  Logical (Table-Level) Backups......Page 677
Section 19.6.  Restore and Recovery......Page 678
20.  Exchange......Page 686
Section 20.1.  Exchange Architecture......Page 687
Section 20.2.  Storage Groups......Page 691
Section 20.3.  Backup......Page 697
Section 20.4.  Using ntbackup to Back Up......Page 703
Section 20.5.  Restore......Page 711
Section 20.6.  Exchange Restore......Page 714
21.  PostgreSQL......Page 729
Section 21.1.  PostgreSQL Architecture......Page 730
Section 21.2.  Backup and Recovery......Page 734
Section 21.3.  Point-in-Time Recovery......Page 739
22.  MySQL......Page 743
Section 22.1.  MySQL Architecture......Page 744
Section 22.2.  MySQL Backup and Recovery Methodologies......Page 750
Part 6:  Potpourri......Page 762
23.  VMware and Miscellanea......Page 763
Section 23.1.  Backing Up VMware Servers......Page 764
Section 23.2.  Volatile Filesystems......Page 769
Section 23.3.  Demystifying dump......Page 773
Section 23.4.  How Do I Read This Volume?......Page 782
Section 23.5.  Gigabit Ethernet......Page 791
Section 23.6.  Disk Recovery Companies......Page 792
Section 23.7.  Yesterday......Page 793
Section 23.8.  Trust Me About the Backups......Page 794
24.  It\'s All About Data Protection......Page 797
Section 24.1.  Business Reasons for Data Protection......Page 798
Section 24.2.  Technical Reasons for Data Protection......Page 801
Section 24.3.  Backup and Archive......Page 804
Section 24.4.  What Needs to Be Backed Up?......Page 806
Section 24.5.  What Needs to Be Archived?......Page 807
Section 24.6.  Examples of Backup and Archive......Page 809
Section 24.7.  Can Open-Source Backup Do the Job?......Page 810
Section 24.8.  Disaster Recovery......Page 813
Section 24.9.  Everything Starts with the Business......Page 814
Section 24.10.  Storage Security......Page 819
Section 24.11.  Conclusion......Page 822
Colophon......Page 823
Index......Page 825
SYMBOL......Page 826
A......Page 827
B......Page 829
C......Page 835
D......Page 838
E......Page 844
F......Page 846
G......Page 848
H......Page 849
I......Page 850
J......Page 852
K......Page 853
L......Page 854
M......Page 855
N......Page 858
O......Page 859
P......Page 861
R......Page 863
S......Page 865
T......Page 870
U......Page 872
V......Page 873
W......Page 875
X......Page 876
Z......Page 877