+612 9045 4394
 
CHECKOUT
Oracle Backup and Recovery 101 : Oracle Press Series - Kenny Smith

Oracle Backup and Recovery 101

Oracle Press Series

Paperback

Published: 1st March 2002
Ships: 7 to 10 business days
7 to 10 business days
RRP $98.00
$75.50
23%
OFF

This text introduces various methods for Oracle database backup and recovery. It includes backup and recovery exercises that can be practised at home which allows the reader to test their skills. Hands-on troubleshooting exercises show common issues that can occur during the backup and recovery process and chapter review questions and answers test reader's knowledge and comprehension.

Acknowledgmentsp. ix
Introductionp. xix
Backup and Recovery Overview
Protect the Datap. 3
Introducing the House of Sidp. 5
Sid's Housep. 6
Debbie's Choresp. 6
Logan's Choresp. 7
Archie's Choresp. 8
Chuck's Choresp. 9
The Control Notebookp. 9
The Alert Logp. 10
Morning Routinep. 10
Bedtime Routinep. 11
Sid's Problemsp. 11
The Oracle Serverp. 12
Database Contentsp. 13
Memory Structuresp. 13
Database Structuresp. 14
Oracle Database Filesp. 16
Datafilesp. 16
Online Redo Log Filesp. 17
Archived Redo Logs Filesp. 18
Control Filesp. 19
Initialization Parameter Filep. 19
Alert Log File and Trace Filesp. 19
Password Filep. 20
Oracle Database Processesp. 21
Processes Definedp. 21
Oracle Database Operationsp. 24
Transactionp. 24
Startupp. 26
Log Switchp. 27
Checkpointp. 27
Shutdownp. 28
Summaryp. 29
Chapter Questionsp. 29
Answers to Chapter Questionsp. 31
Backup and Recovery Optionsp. 33
User-Managed Backup and Recoveryp. 34
Physical Backup Optionsp. 35
Physical Recovery Methodsp. 37
Duplicate Databasep. 41
Standby Databasep. 42
Logical Operationsp. 42
Server-Managed Backup and Recoveryp. 43
Recovery Manager Featuresp. 43
Recovery Manager Capabilitiesp. 46
Oracle Backup and Recovery (Other Options)p. 47
Oracle 9i Enhancementsp. 47
Oracle Enterprise Managerp. 47
Vendor Solutionsp. 48
Summaryp. 50
Chapter Questionsp. 50
Answers to Chapter Questionsp. 52
Hands-on Practicep. 53
Exposure Therapyp. 54
Machines for Activitiesp. 57
Environment Variables and Oracle Softwarep. 57
Oracle Server on Linuxp. 58
Oracle Server on Windows NTp. 58
Oracle Server on Unixp. 59
Oracle Software Installationp. 59
Load the Oracle Softwarep. 59
Databases for Practicep. 61
Create PRACTICE Databasep. 62
Tour the PRACTICE Databasep. 67
Modify PRACTICE Databasep. 74
Create RCAT Databasep. 78
Troubleshootingp. 78
Connect Commandp. 78
Select Commandp. 79
Shutdown Commandp. 79
Summaryp. 80
Chapter Questionsp. 80
Answers to Chapter Questionsp. 82
User Managed Recovery
Closed Backup and Recoveryp. 85
Closed Backup and Complete Restorep. 87
Back Up a Closed Databasep. 88
Restore the Whole Databasep. 90
Complete and Incomplete Recoveryp. 94
Complete Database Recoveryp. 94
Incomplete Database Recoveryp. 102
Troubleshootingp. 108
Alter Database Openp. 108
Startup Mountp. 109
Alter System Switch Log Filep. 109
Summaryp. 109
Chapter Questionsp. 109
Answers to Chapter Questionsp. 111
Recovery from Open Backupp. 113
Whole Open Backupp. 115
Backup an Open Databasep. 117
Backup Archive Log Filesp. 124
Complete and Incomplete Recoveryp. 127
Complete Recovery from an Open Backupp. 128
Incomplete Recovery from an Open Backupp. 132
Troubleshootingp. 137
Archive Commandsp. 137
Startup or Shutdown Commandsp. 138
Summaryp. 138
Chapter Questionsp. 139
Answers to Chapter Questionsp. 141
Duplicate Databasep. 143
Database Duplicationp. 147
Clone Open Practice Databasep. 148
Duplicate Database Scenariosp. 156
Clone to a Different Machinep. 156
Clone from a Tape Backupp. 157
Copy a Database to a Different Machinep. 158
Duplicate Part of a Databasep. 159
Troubleshootingp. 160
Command Connectp. 160
Command CREATE CONTROLFIEp. 160
Command RECOVER DATABASEp. 161
Command ALTER DATABASE OPEN RESETLOGSp. 161
Summaryp. 162
Chapter Questionsp. 162
Answers to Chapter Questionsp. 164
Standby Databasep. 165
Oracle's Standby Databasep. 168
Initiate a Standby Databasep. 169
Recover Standby Databasep. 172
Open the Standby Database in Read-Onlyp. 177
Activate the Standby Databasep. 179
Recommendationsp. 181
Troubleshootingp. 181
Summaryp. 182
Chapter Questionsp. 183
Answers to Chapter Questionsp. 184
Export and Importp. 185
Database Mode Export and Importp. 191
Export the Full Databasep. 191
User Mode Export and Importp. 197
Replace and Clone User SCOTTp. 197
Table Mode Export and Importp. 200
Export a Database Tablep. 201
9i New Featuresp. 203
Troubleshootingp. 204
Summaryp. 204
Chapter Questionsp. 204
Answers to Chapter Questionsp. 206
Tablespace Point In Time Recoveryp. 207
Tablespace Recovery Investigationp. 210
Research and Resolve Tablespace Recoveryp. 211
Tablespace Recovery on an Auxiliary Databasep. 216
Restore and Recover USERS Tablespacep. 216
Transportable Tablespacep. 220
Transport the USERS Tablespacep. 221
Transportable Tablespace Tipsp. 225
Troubleshootingp. 225
Summaryp. 226
Chapter Questionsp. 226
Answers to Chapter Questionsp. 228
LogMinerp. 229
Analyzing Redo Using LogMinerp. 232
Analyze the Redo Filesp. 233
Oracle 9i Enhancementsp. 245
Troubleshootingp. 246
Summaryp. 246
Chapter Questionsp. 247
Answers to Chapter Questionsp. 249
Server Managed Recovery
RMAN Configurationp. 253
RMAN Architecturep. 254
Key Features of RMANp. 256
Recovery Manager Catalogp. 258
Create a Recovery Manager Catalogp. 260
Media Management Layerp. 267
Configure the Media Management Layerp. 268
Consult Your Tape Management Vendorp. 269
Oracle 9i New Featuresp. 270
Troubleshootingp. 271
RMAN Messagesp. 272
Media Management Layerp. 272
Summaryp. 273
Chapter Questionsp. 273
Answers to Chapter Questionsp. 275
RMAN Backupp. 277
Recovery Manager Backup Optionsp. 278
Backupsp. 279
RMAN Backup Compressionp. 283
Image Copiesp. 289
Proxy Copiesp. 290
Backup Types Comparedp. 291
Create Recovery Manager Image Copiesp. 293
Create Recovery Manager Whole Backupp. 296
Create Recovery Manager Incremental Backupsp. 303
Create Recovery Manager Archive Log Backupp. 305
RMAN Backup of Multiple Archive Destinationsp. 307
RMAN Deploymentp. 308
RMAN Backup Performancep. 312
Monitor Backup and Copy Jobsp. 313
Performance Tipsp. 313
Troubleshootingp. 314
Corruption Detectionp. 315
Summaryp. 316
Chapter Questionsp. 317
Answers to Chapter Questionsp. 318
RMAN Catalog Maintenancep. 319
RMAN Commandsp. 322
Listp. 322
Reportp. 322
Changep. 322
Crosscheckp. 323
Validatep. 323
Recovery Manager Scriptsp. 324
Stored Scriptsp. 324
Recovery Manager Backup Confirmationp. 328
Confirm Backupsp. 329
Recovery Catalog Cleanupp. 345
Remove Redundant Backupsp. 345
Troubleshootingp. 350
Summaryp. 351
Chapter Questionsp. 351
Answers to Chapter Questionsp. 353
RMAN Recoveryp. 355
RMAN Restorep. 356
RMAN Recoveryp. 357
RMAN Restore and Recoverp. 361
Restore the Whole Databasep. 361
Restore and Recover a Datafilep. 368
Incomplete Database Recoveryp. 375
Recovery Tipsp. 379
Troubleshootingp. 381
Summaryp. 382
Chapter Questionsp. 383
Answers to Chapter Questionsp. 384
RMAN Duplicate Databasep. 385
Recovery Manager Duplicationp. 390
Duplicate PRACTICE Database with RMANp. 391
Duplicating a Database on a Different Serverp. 400
Troubleshootingp. 400
Summaryp. 402
Chapter Questionsp. 403
Answers to Chapter Questionsp. 404
RMAN Standby Databasep. 405
Recovery Manager Standbyp. 409
Create a Standby Database with RMANp. 412
Recovery Manager Standby Backupp. 418
Back Up a Standby Database with RMANp. 419
Troubleshootingp. 422
Summaryp. 422
Chapter Questionsp. 424
Answers to Chapter Questionsp. 426
RMAN Tablespace Recoveryp. 427
Recovery Manager TSPITRp. 431
Tablespace Point-in-Time Recoveryp. 433
Troubleshootingp. 439
Summaryp. 440
Chapter Questionsp. 441
Answers to Chapter Questionsp. 443
Appendixes
Glossaryp. 447
RMAN in Oracle 9ip. 457
RMAN Configurationp. 458
RMAN Backupp. 460
RMAN Catalog Maintenancep. 462
RMAN Restore and Recoveryp. 463
Summaryp. 464
Indexp. 465
Table of Contents provided by Syndetics. All Rights Reserved.

ISBN: 9780072194616
ISBN-10: 0072194618
Series: Oracle Press Series
Audience: Professional
Format: Paperback
Language: English
Number Of Pages: 516
Published: 1st March 2002
Publisher: McGraw-Hill Education - Europe
Country of Publication: US
Dimensions (cm): 23.5 x 19.0  x 2.6
Weight (kg): 0.88