product iamge

OCP Oracle Database 11g Administration II Exam Guide: Exam 1Z0-053 (Osborne ORACLE Press Series)

This document was uploaded by one of our users. The uploader already confirmed that they had the permission to publish it. If you are author/publisher or own the copyright of this documents, please report to us by using this DMCA report form.

Download
Search on Amazon

Simply click on the Download Book button.

Yes, Book downloads on Ebookily are 100% Free.

Sometimes the book is free on Amazon As well, so go ahead and hit "Search on Amazon"

A Fully Integrated Study System for OCP Exam 1Z0-053

Prepare for the Oracle Certified Professional Oracle Database 11g: Administration II exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference. Get complete coverage of all OCP objectives for exam 1Z0-053, including:

  • Database structure and Oracle Automatic Storage Management
  • Configuring database recoverability                  
  • Oracle Recovery Manager (RMAN)
  • Oracle Flashback                    
  • Memory management techniques                      
  • Database tuning advisors                   
  • Disk space and resource management              
  • Configuring database diagnostics                      
  • Administering the Oracle Scheduler                 
  • Database globalization

On the CD-ROM:

  • One full practice exam that simulates the actual OCP exam
  • Detailed answers and explanations
  • Score report performance assessment tool
  • Complete electronic book
  • Bonus exam available free with online registration

Author(s): Bob Bryla
Series: Osborne ORACLE Press Series
Edition: 2
Publisher: McGraw-Hill Osborne Media
Year: 2008

Language: English
Pages: 753

1 Database Architecture and ASM......Page 34
Understanding Database Architecture and ASM......Page 35
Oracle Logical Storage Structures......Page 36
Describe ASM......Page 51
2 Configuring Database Recoverability......Page 100
3Creatingand Maintainingan RMAN Catalog......Page 138
Identify Situations that RequireRMAN Recovery Catalog......Page 139
Using a Recovery Catalog for RMAN Metadata......Page 140
Create and Configure a Recovery Catalog......Page 141
Configure the Recovery Catalog Database......Page 142
Create the Recovery Catalog Owner......Page 143
Create the Recovery Catalog......Page 144
Registering a Database......Page 145
Changing the DBID of a Database......Page 146
Unregistering a Database......Page 150
Cataloging Additional Backup Files......Page 151
Manually Resynchronize the Recovery Catalog......Page 153
Executing RMAN Stored Scripts......Page 154
Creating a Parameterized Stored Script......Page 155
Retrieving RMAN Stored Script Metadata......Page 156
Managing RMAN Stored Scripts......Page 157
Backing Up the Recovery Catalog......Page 158
Recovering from a Lost Recovery Catalog......Page 159
Upgrading the Recovery Catalog......Page 161
Exporting and Importing the Recovery Catalog......Page 160
Understanding Virtual Private Catalogs......Page 162
Creating Virtual Private Catalog Owners......Page 163
Creating a Virtual Private Catalog......Page 164
Using a Virtual Private Catalog......Page 165
Types of RMAN Backups......Page 167
4 Creating RMAN Backups......Page 192
some of the major features of RMAN......Page 194
Create Image File Backups......Page 196
Create a Compressed Backupset......Page 197
Creating Image Copies......Page 199
Whole Database Backups......Page 200
Full Backups......Page 201
Incremental Backups......Page 203
Level 0 Incremental Backups......Page 204
Cumulative Incremental Backups......Page 205
Enable Fast Incremental Backup......Page 206
Understanding Block Change Tracking......Page 207
Enabling Fast Incremental Backup......Page 208
Relocate the Block Change Tracking File......Page 209
Create Duplex Backup and Back Up Backupsets......Page 211
Backing Up Read-Only Tablespaces......Page 215
Understanding Archival Backups......Page 216
Performing an Archival Backup......Page 217
Managing Archival Backups......Page 218
Create a Multisection, Compressed,and Encrypted Backup......Page 219
Creating a Multisection Backup......Page 220
Validating a Backup with a Section Size......Page 221
Multisection Data Dictionary Views......Page 222
Encrypting Backups......Page 223
Report On and Maintain Backups......Page 227
Using the LIST Command......Page 228
Using the REPORT Command......Page 229
Using the DELETE Command......Page 232
Using the CROSSCHECK Command......Page 233
5 Recovering Using RMAN Backups......Page 248
6 User-Managed Backup andRecovery......Page 294
7 Miscellaneous RMAN Features......Page 344
8 Monitoring and Tuning RMAN......Page 376
9 Configuring andUsing Flashback......Page 402
10 Memory Management Techniques......Page 460
Implement Automatic Memory Management......Page 461
System Global Area......Page 462
Buffer Caches......Page 463
Redo Log Buffer......Page 464
Software Code Area......Page 465
Configuring Automatic Memory Managemen......Page 466
Enable Automatic Memory Management......Page 468
Monitoring Automatic Memory Management......Page 469
Understanding Automatic Shared Memory Management......Page 472
Switching from Manual Memory Management to ASMM......Page 473
Disabling ASMM......Page 474
Modifying the SGA_TARGET Parameter......Page 475
Understanding PGA Components......Page 476
Configuring PGA Memory Management......Page 477
Managing PGA Memory......Page 478
11Using DatabaseTuning Advisors......Page 490
12Disk Spaceand ResourceManagement......Page 524
13ConfiguringDatabaseDiagnostics......Page 588
14Using theScheduler forTask Automation......Page 626
15DatabaseGlobalization......Page 668