Oracle RMAN 11g : backup and recovery

Contents......Page 14
Acknowledgments......Page 28
Introduction......Page 30
Part I: Getting Started with RMAN in Oracle Database 11g......Page 34
1 Oracle Database 11g Backup and Recovery Architecture Tour......Page 36
Backup and Recovery Essentials......Page 38
A Few Oracle Terms to Know......Page 40
Controlling the Database Software......Page 43
Oracle Architecture......Page 44
Oracle Memory and RMAN......Page 46
More About the Oracle Redo Logs......Page 49
The Combined Picture......Page 54
Oracle Backup and Recovery Primer......Page 59
Summary......Page 65
2 Introduction to the RMAN Architecture......Page 66
The RMAN Utility......Page 67
The Network Topology of RMAN Backups......Page 69
The Database Control File......Page 72
The RMAN Server Processes......Page 75
The SYS Packages Used by RMAN......Page 76
Backing Up the Data Block......Page 77
RMAN in Memory......Page 80
The Recovery Catalog......Page 83
The Auxiliary Database......Page 84
Compatibility Issues......Page 86
The RMAN Process: From Start to Finish......Page 87
The Flash Recovery Area......Page 89
Summary......Page 90
Part II: Setup Principles and Practices......Page 92
3 RMAN Setup and Configuration......Page 94
Configuring Your Database to Run in ARCHIVELOG Mode......Page 95
The Oracle Database 11g Fault Diagnosability Infrastructure......Page 106
The RMAN Command Line......Page 109
Configuring the Database for RMAN Operations......Page 113
Configuring RMAN Default Settings......Page 116
Summary of RMAN Configuration Tasks......Page 131
Summary......Page 132
4 Media Management Considerations......Page 134
Tape Backups in a Disk Backup World......Page 135
RMAN and the Media Manager: An Overview......Page 136
The SBT API......Page 140
Back Up to Tape: From Start to Finish......Page 141
Using sbttest and loadsbt.exe......Page 142
Media Management Errors......Page 143
Summary......Page 144
5 Oracle Secure Backup......Page 146
Features of Oracle Secure Backup......Page 147
Oracle Secure Backup Interfaces......Page 149
Oracle Secure Backup Components......Page 150
Installing and Configuring Oracle Secure Backup......Page 155
Oracle Database and File System Data Backup Using Oracle Secure Backup......Page 166
Oracle Database Backup Using Oracle Secure Backup Cloud Module......Page 171
Summary......Page 174
6 Backing Up to Amazon Web Services Using the Oracle Secure Backup Cloud Module......Page 176
What Is Cloud Computing?......Page 177
Oracle and the Amazon Cloud......Page 178
Oracle Cloud Backup Advantages......Page 179
Performing Backups by Using the OSB Cloud Module......Page 181
Summary......Page 185
7 Enhancing RMAN with VERITAS NetBackup™ for Oracle......Page 186
Key Features......Page 187
NetBackup Installation......Page 188
How to Link Oracle to NetBackup Media Manager......Page 190
Architecture......Page 192
Configuring NetBackup Policies......Page 193
Managing Expired Backup Images......Page 200
RMAN Sample Scripts......Page 201
Troubleshooting......Page 202
Security Best Practices......Page 203
Summary......Page 204
8 Configuring HP Data Protector for Oracle......Page 206
Integration of Oracle and Data Protector......Page 207
RMAN Backup Configuration on Data Protector......Page 212
RMAN Backup......Page 217
Restoring Oracle Using the Data Protector GUI......Page 218
Summary......Page 220
9 RMAN and Tivoli Storage Manager......Page 222
Overview of Tivoli Storage Manager......Page 223
Performing an RMAN Backup Using TDPO......Page 232
Troubleshooting Common Backup Scenarios......Page 237
Summary......Page 239
10 Using the Recovery Catalog......Page 240
What Is the Recovery Catalog?......Page 241
Recovery Catalog Maintenance......Page 247
Backing Up the Recovery Catalog......Page 249
Recovery Catalog Views......Page 250
11 RMAN Backups......Page 258
Benefits of RMAN Backups vs. Scripted Backups......Page 259
RMAN Compatibility Issues......Page 260
Monitoring RMAN Backup Status......Page 261
Offline RMAN Database Backups......Page 262
Backup Command Options......Page 269
Introducing the set Command......Page 279
Online RMAN Database Backups......Page 280
Copies......Page 286
Incremental RMAN Backups......Page 288
Getting Started......Page 294
Summary......Page 297
12 RMAN Restore and Recovery......Page 298
RMAN Restore and Recovery Basics......Page 299
Before RMAN Can Get Going......Page 300
The restore and recover Commands......Page 313
Restore and Recover the Database in NOARCHIVELOG Mode......Page 314
Database Recoveries in ARCHIVELOG Mode......Page 320
Recovering from Online Redo Log Loss......Page 326
The Data Recovery Advisor......Page 330
Summary......Page 336
Part III: Using RMAN Effectively......Page 338
13 Using Oracle Enterprise Manager for Backup and Recovery......Page 340
Oracle Enterprise Manager: The New Paradigm......Page 341
Grid Control......Page 344
Database Control......Page 346
Configuring Backup Settings in Enterprise Manager......Page 351
Configuring Recovery Settings......Page 355
Configuring Recovery Catalogs in OEM......Page 358
Database Backups from Enterprise Manager......Page 360
Performing Recovery in Enterprise Manager......Page 367
Backup Management and Reporting......Page 374
Database Cloning from Enterprise Manager......Page 376
Summary......Page 377
14 RMAN Advanced Recovery Topics......Page 378
Incomplete Recoveries......Page 379
Other RMAN Recovery Topics......Page 383
Tablespace Point-In-Time Recovery......Page 389
Verifying Your Backups Are Recoverable......Page 399
Call the Movers! Cross-Platform Database Movement and RMAN......Page 404
We Like to Move It! Move It!......Page 406
Sometimes Things Just Go Wrong......Page 407
Summary......Page 409
15 Surviving User Errors: Flashback Technologies......Page 410
Prepared for the Inevitable: Flashback Technology......Page 411
Flashback Query......Page 412
Flashback Table......Page 417
Flashback Transaction......Page 420
Flashback Drop......Page 422
Flashback Database......Page 426
Flashback Data Archive (Total Recall)......Page 430
Summary......Page 431
16 Maintaining RMAN......Page 432
RMAN Maintenance......Page 433
RMAN Stored Scripts......Page 451
Summary......Page 454
17 Monitoring and Reporting on RMAN......Page 456
The RMAN list Command......Page 457
The RMAN report Command......Page 471
Data Dictionary Views for Reporting......Page 474
Summary......Page 476
18 Performance Tuning RMAN Backup and Recovery Operations......Page 478
Before You Tune RMAN......Page 479
Tuning RMAN......Page 484
Tracing RMAN Sessions......Page 493
Summary......Page 495
Part IV: RMAN in the Oracle Ecosystem......Page 496
19 Duplication: Cloning the Target Database......Page 498
RMAN Duplication: A Primer......Page 499
Duplication: Location Considerations......Page 507
Duplication to the Same Server......Page 514
Duplication to a Remote Server......Page 517
Target-Less Duplication in 11g......Page 520
Summary......Page 522
20 RMAN and Data Guard......Page 524
RMAN and the Standby Database......Page 525
Taking Backups from the Standby Database......Page 531
Summary......Page 533
21 RMAN and Real Application Clusters......Page 534
Real Application Clusters: Unique Backup Challenges......Page 535
RAC Recovery Challenges......Page 540
Advanced RMAN/RAC Topics......Page 542
Summary......Page 549
22 RMAN in Sync and Split Technology......Page 550
Sync and Split: Broken Mirror Backups......Page 551
Oracle Databases on Sync and Split Volumes......Page 553
Benefits of the Split Mirror Backup......Page 556
RMAN and Sync and Split......Page 557
Summary......Page 562
23 RMAN in the Workplace: Case Studies......Page 564
Before the Recovery......Page 565
Recovery Case Studies......Page 566
Summary......Page 588
Part V: Appendixes......Page 590
A: RMAN Syntax Reference Guide......Page 592
RMAN Reserved Words......Page 593
RMAN Command List......Page 595
RMAN Command List Syntax Details......Page 596
RMAN Subclauses Syntax Details......Page 645
B: RMAN Scripting Examples......Page 654
RMAN Scripts for Windows......Page 655
RMAN Scripts for Unix......Page 656
C: Setting Up an RMAN Test Environment......Page 658
The Test Box......Page 660
The Oracle Configuration......Page 661
The RMAN Configuration......Page 663
A......Page 666
B......Page 668
C......Page 669
D......Page 672
F......Page 674
H......Page 675
L......Page 676
M......Page 677
N......Page 678
O......Page 679
P......Page 680
R......Page 681
S......Page 685
T......Page 687
U......Page 688
W......Page 689