OCP: Oracle 10g administration II study guide (1Z0-043)

Doug Stuns, Tim Buterbaugh, Bob Bryla9780782143683, 0-7821-4368-7

Here’s the book you need to prepare for the Oracle Database 10g Administration II exam, 1Z0-043. This Study Guide was developed to meet the exacting requirements of today’s Oracle certification candidates. In addition to the consistent and accessible instructional approach that has earned Sybex the “Best Study Guide” selection in CertCities Readers’ Choice Awards for two consecutive years, this book provides: Clear and concise information on advanced database administration with Oracle 10g Practical examples and insights drawn from the authors’ real-world experiences Leading-edge exam preparation software, including a test engine and electronic flashcards
You’ll also find authoritative coverage of key exam topics, including: Configuring Recovery Manager Understanding the Flashback Database Recovering from User Errors Working with Globalization Support Using the Scheduler to Automate Tasks Monitoring and Managing Storage Securing the Oracle Listener
Look to Sybex for the knowledge and skills needed to succeed in today’s competitive IT marketplace.

---

Table of contents :
Cover……Page 4
Contents at a Glance……Page 10
Contents……Page 12
Introduction……Page 20
Assessment Test……Page 32
Answers to Assessment Test……Page 45
Configuring Recovery Manager……Page 50
Components of RMAN……Page 51
RMAN Usage Considerations……Page 53
RMAN Repository and Control Files……Page 55
RMAN Using the Recovery Catalog……Page 56
Starting and Connecting to RMAN……Page 62
Describing Channel Allocation……Page 66
Settings for RMAN……Page 69
Enterprise Manager……Page 73
Describing Retention Policies……Page 76
Configuring the Control File Autobackup……Page 78
Exam Essentials……Page 79
Review Questions……Page 80
Answers to Review Questions……Page 84
Using Recovery Manager……Page 86
RMAN Commands……Page 87
Creating Backup Sets……Page 94
Creating Image Copies……Page 96
Compressed Backups……Page 99
Full and Incremental Backups……Page 101
Parallelization of Backup Sets……Page 104
Backup Options……Page 110
Change Tracking……Page 113
Enterprise Manager……Page 115
Monitoring RMAN Backups……Page 118
Using LIST Commands……Page 120
Using REPORT Commands……Page 122
Enabling ARCHIVELOG Mode……Page 124
Scheduling a Backup Job……Page 125
Summary……Page 126
Exam Essentials……Page 127
Review Questions……Page 128
Answers to Review Questions……Page 132
Recovering From Non-Critical Losses……Page 134
An Overview of Non-Critical Files……Page 135
Creating a New Temporary Tablespace……Page 136
Starting the Database with a Missing Tempfile……Page 138
Re-creating Redo Log Files……Page 139
Recovering an Index Tablespace……Page 141
Re-creating Indexes……Page 142
Recovering Read-Only Tablespaces……Page 143
Re-creating the Password File……Page 146
Exam Essentials……Page 148
Review Questions……Page 150
Answers to Review Questions……Page 154
Database Recovery……Page 156
Recovery Process……Page 157
Server-Managed Recovery……Page 158
User-Managed Recovery……Page 161
Recovering Control Files……Page 163
Recovering a Control File Autobackup……Page 164
Re-creating a Control File……Page 169
Performing an Incomplete Recovery……Page 178
RMAN Incomplete Recovery……Page 179
Performing User-Managed Incomplete Recovery……Page 184
Enterprise Manager……Page 188
Performing a Recovery after a……Page 195
Summary……Page 203
Exam Essentials……Page 204
Review Questions……Page 205
Answers to Review Questions……Page 209
Understanding the Flashback Database……Page 212
An Overview of Flashback Technologies……Page 213
An Overview of the Flashback Database……Page 214
Recovery Manager……Page 216
Using the Flash Recovery Area……Page 217
Backing Up the Flash Recovery Area……Page 220
Configuring the Flashback Database……Page 221
Using the Flashback Database with RMAN……Page 222
Monitoring the Flashback Database……Page 224
Configuring the Flashback Database with EM……Page 226
Using the Flashback Database with EM……Page 228
Monitoring the Flashback Database with EM……Page 235
Exam Essentials……Page 236
Review Questions……Page 237
Answers to Review Questions……Page 241
Recovering from User Errors……Page 244
An Overview of Flashback Technologies……Page 245
Using Flashback Drop……Page 246
Understanding the Recycle Bin……Page 247
Limitations on Flashback Drop and the Recycle Bin……Page 252
Dropped Tables……Page 253
Using Flashback Versions Query……Page 258
Using Flashback Transaction Query……Page 262
Using Flashback Table……Page 264
Summary……Page 266
Exam Essentials……Page 267
Review Questions……Page 268
Answers to Review Questions……Page 272
Handling Block Corruption……Page 274
Block Corruption Symptoms……Page 275
and Resolve Corruption……Page 277
Using the DBVERIFY Utility……Page 278
Using DB_BLOCK_CHECKING……Page 281
Using the DBMS_REPAIR Package……Page 282
Block Media Recovery……Page 292
Exam Essentials……Page 294
Review Questions……Page 295
Answers to Review Questions……Page 302
Understanding Automatic Database Management……Page 306
AWR Statistics Collection Facility……Page 308
Workload Repository……Page 311
Active Session History……Page 313
AWR Snapshots……Page 315
AWR Baselines……Page 318
Using AWR Views……Page 319
Using AWR Reports……Page 321
Managing Server-Generated Alerts……Page 323
An Overview of the Alert Process……Page 324
Using Enterprise Manager to Configure Thresholds……Page 325
Setting Thresholds through PL/SQL……Page 328
Administration Tasks……Page 330
Automatic Statistics Collection……Page 331
Understanding the Advisory Framework……Page 343
An Overview of the Advisors……Page 344
Automatic Database Diagnostic Monitor (ADDM)……Page 349
SQL Tuning Advisor……Page 353
Summary……Page 368
Exam Essentials……Page 369
Review Questions……Page 370
Answers to Review Questions……Page 374
Understanding Automatic Storage Management……Page 376
Introducing the ASM Architecture……Page 377
Creating an ASM Instance……Page 379
Connecting to an ASM Instance……Page 381
Starting Up and Shutting Down an ASM Instance……Page 382
Defining ASM Initialization Parameters……Page 383
Performance Views……Page 384
Fully Qualified Names……Page 385
Alias with Template Names……Page 386
and Templates……Page 387
Understanding Failure Groups and Disk Group Mirroring……Page 390
Creating and Deleting Disk Groups……Page 391
Altering Disk Groups……Page 395
Using EM Database Control with ASM Disk Groups……Page 404
Summary……Page 406
Exam Essentials……Page 407
Review Questions……Page 409
Answers to Review Questions……Page 414
Understanding Globalization Support……Page 416
An Overview of Globalization Support……Page 417
Globalization Support Features……Page 418
Globalization Support Architecture……Page 419
Supporting Multilingual Applications……Page 421
Using Unicode in a Multilingual Database……Page 423
Setting NLS Parameters……Page 425
Prioritizing NLS Parameters……Page 437
Using NLS Views……Page 440
Using Datetime Datatypes……Page 444
An Overview of Text Sorting……Page 452
Using Linguistic Sort Parameters……Page 455
Linguistic Sort Types……Page 461
Searching Linguistic Strings……Page 465
Summary……Page 466
Exam Essentials……Page 467
Review Questions……Page 468
Answers to Review Questions……Page 473
Managing Resources……Page 476
Working with the Pending Area……Page 478
Validating Changes……Page 479
Submitting the Pending Area……Page 480
Resource Consumer Groups……Page 481
Managing Resource Consumer Groups……Page 482
Resource Plans……Page 492
Creating Simple Resource Plans……Page 493
Creating Complex Resource Plans……Page 496
Creating Resource Sub-Plans……Page 497
Modifying Resource Plans……Page 498
Resource Plan Directives……Page 499
Creating Resource Plan Directives……Page 500
Creating the Elements……Page 509
Summary……Page 518
Exam Essentials……Page 519
Review Questions……Page 520
Answers to Review Questions……Page 524
Using the Scheduler to Automate Tasks……Page 526
Scheduler Overview……Page 527
Scheduler Architecture……Page 528
The Job Slave Processes……Page 529
Common Administration Tools……Page 530
Using the ENABLE Procedure……Page 531
Using the DISABLE Procedure……Page 532
Setting Attributes……Page 534
Creating Jobs……Page 536
Copying Jobs……Page 541
Running Jobs……Page 542
Dropping Jobs……Page 543
Job Class Parameters……Page 544
Creating Job Classes……Page 545
Program Attributes……Page 546
Creating Programs……Page 547
Using Schedules……Page 549
Creating Schedules……Page 550
Setting Repeat Intervals……Page 551
Testing Repeat Intervals……Page 553
Creating Windows……Page 556
Opening and Closing Windows……Page 557
Window Logging……Page 558
Using Scheduler Views……Page 560
Summary……Page 562
Exam Essentials……Page 563
Review Questions……Page 565
Answers to Review Questions……Page 570
Monitoring and Managing Storage……Page 572
Space Usage Monitoring……Page 574
Manager Database Control……Page 575
Using DBMS_SERVER_ALERT……Page 581
Segment Shrink……Page 585
Segment Advisor……Page 591
Index Space Monitoring……Page 605
Index-Organized Tables……Page 608
Clustered Tables……Page 612
Controlling Undo Space……Page 619
Controlling Redo Log File Space……Page 621
An Overview of Resumable Space Allocation……Page 632
Using Resumable Space Allocation……Page 633
Resumable Space Allocation Data Dictionary Views……Page 635
Summary……Page 636
Exam Essentials……Page 637
Review Questions……Page 638
Answers to Review Questions……Page 643
Securing the Oracle Listener, Diagnostic Sources, and Memory……Page 646
Securing the Oracle Listener……Page 647
An Overview of the TNS Listener……Page 648
Managing the Listener Remotely……Page 649
Setting the Listener Password……Page 650
Controlling Database Access……Page 653
Using Listener Logging……Page 655
Removing Unneeded External Procedure Services……Page 657
Creating a Separate Listener for External Procedures……Page 660
Diagnostic Sources……Page 664
Using the Oracle Alert Log……Page 665
Using Server-Generated Alerts……Page 674
Using Oracle Trace Files……Page 677
Automatic Memory Management……Page 679
Oracle Memory Usage……Page 680
Summary……Page 688
Exam Essentials……Page 689
Review Questions……Page 691
Answers to Review Questions……Page 696
Glossary……Page 698
Index……Page 718