SEARCH
Disclaimer: Authors have full rights over their works. Reproduction of any part of the content is prohibited without prior authorization.
BOOK OCP ORACLE DATABASE 11G ADMINISTRATOR CERTIFIED PROFESSIONAL STUDY GUIDE EXAM 1Z0-053
SUMMARY
-
Items Found: 364
- Chapter 1 Using Oracle ASM 1
- Chapter 2 Performing Oracle User-Managed Backups 55
- Chapter 3 Performing Oracle User-Managed Database Recoveries 103
- Chapter 4 Configuring and Backing Up Using RMAN 153
- Chapter 5 Using the RMAN Recovery Catalog 209
- Chapter 6 Recovering Databases with RMAN 229
- Chapter 7 Reporting, Monitoring, and Tuning with RMAN 279
- Chapter 8 Performing Oracle Advanced Recovery 313
- Chapter 9 Understanding Flashback Technology 349
- Chapter 10 Diagnosing the Database and Managing Performance 399
- Chapter 11 Managing Database Resources 455
- Chapter 12 Using the Scheduler to Automate Tasks 561
- Chapter 13 Implementing Globalization Support 617
- Appendix A Lab Exercises 679
- Appendix B About the Companion CD 783
- Chapter 1 Using Oracle ASM 1
- What Is ASM? 2
- Working with the ASM Instance 3
- Creating the ASM Instance 4
- Managing the ASM Instance 9
- Overview of ASM Data Dictionary Views 29
- Using ASM Storage 31
- What Are ASM Files? 31
- Defining ASM as the Default Destination for
- Database Files 34
- Creating a Tablespace Using an ASM Disk Group as
- the Destination 35
- Creating a Database Using ASM Disk Group Locations 37
- Using RMAN with ASM 43
- Copying Database Datafiles to an ASM Disk with RMAN 43
- Creating RMAN Backups on ASM 43
- Summary 44
- Exam Essentials 45
- Review Questions 46
- Answers to Review Questions 53
- Chapter 2 Performing Oracle User-Managed Backups 55
- Understanding the Oracle Database as It Relates to Backup
- and Recovery 56
- Oracle Processes Related to Backup and Recovery 57
- Oracle Memory Structures Related to Backup
- and Recovery 58
- The Oracle Data Dictionary 58
- Oracle Datafiles and Tablespaces 61
- Redo Logs 62
- Control Files 64
- Parameter Files 64
- NOARCHIVELOG and ARCHIVELOG Modes 66
- The Oracle Instance and the Oracle Database 67
- Configuring the Database for Backup and Recovery 72
- Configuring for ARCHIVELOG Mode 73
- Putting the Database in ARCHIVELOG Mode 75
- Using ARCHIVELOG Mode Data Dictionary Views 79
- Performing Oracle Offline Backups 81
- Performing Oracle Online Backups 85
- The Mechanics of Online Backups 85
- Backing Up the Control File 91
- Creating a Backup Control File 91
- Creating a Trace File with the Create Control File
- Command in It 92
- Summary 94
- Exam Essentials 94
- Review Questions 95
- Answers to Review Questions 100
- Chapter 3 Performing Oracle User-Managed
- Database Recoveries 103
- Performing a Recovery in NOARCHIVELOG Mode 104
- Performing a Full Database Recovery in
- ARCHIVELOG Mode 108
- Preparing for the Recovery 108
- Recovering the Database 110
- Performing Incomplete Recoveries 122
- Requirements for and Mechanics of an
- Incomplete Recovery 122
- Preparing for an Incomplete Recovery 123
- Performing an Incomplete Recovery 124
- Performing Other Types of Recoveries 130
- Recovering from the Loss of a Tempfile 131
- Recovering from the Loss of an Online Redo Log Group 131
- Recovering from the Loss of a Control File 135
- Recovering from the Loss of the Password File 139
- Recovering from the Loss of Everything 139
- Summary 140
- Exam Essentials 140
- Review Questions 142
- Answers to Review Questions 150
- Chapter 4 Configuring and Backing Up Using RMAN 153
- Why Use RMAN? 154
- Exploring the RMAN Architecture 155
- Connecting to RMAN 157
- Configuring RMAN for Use 159
- The Flash Recovery Area 159
- RMAN Persistent Configuration Settings 163
- Unique RMAN Configuration Settings 164
- Preparing RMAN for Use 165
- Backing Up Your Database with RMAN 179
- Using the RMAN Command Line 180
- Types of RMAN Backups 184
- RMAN Offline Backups 186
- RMAN Online Backups 187
- RMAN Incremental Backups 193
- RMAN Incrementally Updated Backups 196
- RMAN Multisection Backups 196
- RMAN Backup of Archived Redo Logs 197
- RMAN Backup of the Spfile and Control Files 198
- Backing Up RMAN Backup Sets 199
- Summary 199
- Exam Essentials 200
- Review Questions 201
- Answers to Review Questions 206
- Chapter 5 Using the RMAN Recovery Catalog 209
- Introducing the Recovery Catalog 210
- Creating the Recovery Catalog User and Schema Objects 211
- Using a Recovery Catalog 214
- Connecting to the Recovery Catalog from RMAN 214
- Registering the Target Database with the
- Recovery Catalog 215
- Unregistering a Database 216
- Using Scripts in the RMAN Recovery Catalog 216
- Executing External Scripts 217
- Creating Stored Scripts 217
- Replacing Stored Scripts 218
- Removing Stored Scripts 218
- Executing Stored Scripts 218
- Printing Stored Scripts 218
- Using Script Substitution Variables 218
- Maintaining the Recovery Catalog 219
- Synchronizing the Recovery Catalog 219
- Backing Up the Recovery Catalog 219
- Using the RMAN Virtual Private Catalog 220
- Creating the RMAN Virtual Private Catalog 220
- Administering the RMAN Virtual Private Catalog 221
- Summary 222
- Exam Essentials 222
- Review Questions 223
- Answers to Review Questions 227
- Chapter 6 Recovering Databases with RMAN 229
- RMAN Database-Recovery Basics 231
- Recovering a Database in NOARCHIVELOG Mode 232
- Recovering a Database in ARCHIVELOG Mode 234
- Complete Database Recovery in ARCHIVELOG Mode 235
- Datafile or Tablespace Recovery in ARCHIVELOG Mode 240
- Recovering a Database Using Incomplete Recovery 248
- Types of Point-in-Time Recovery 249
- Point-in-Time Recovery Mechanics 254
- Using Image Copies to Recover Your Database 256
- Other Basic Recovery Topics 257
- Block Media Recovery 257
- Recovering the Control File 258
- Recovering the Spfile 264
- Summary 268
- Exam Essentials 268
- Review Questions 270
- Answers to Review Questions 276
- Chapter 7 Reporting, Monitoring, and Tuning with RMAN 279
- Overview of the RMAN Report and List Commands 280
- Using the RMAN report Command 280
- Using the RMAN list Command 287
- Monitoring, Administering, and Tuning RMAN 296
- Monitoring RMAN Operations 297
- Administering RMAN Operations 300
- Tuning RMAN Operations 304
- Summary 304
- Exam Essentials 305
- Review Questions 306
- Answers to Review Questions 311
- Chapter 8 Performing Oracle Advanced Recovery 313
- Switching Between RMAN Incarnations 314
- Overview of RMAN Database Duplication 316
- RMAN Database Duplication Basics 316
- Performing an RMAN Database Duplication 317
- Performing an RMAN Tablespace Point-in-Time Recovery 327
- TSPITR Overview 328
- Checking the Transport Set 330
- Lost Objects 331
- Rules, Rules, and More Rules 332
- TSPITR Aftereffects 332
- Performing a Database Disaster Recovery 336
- Summary 337
- Exam Essentials 338
- Review Questions 339
- Answers to Review Questions 346
- Chapter 9 Understanding Flashback Technology 349
- Overview of Flashback Technology 351
- Using Automatic Undo Management 352
- Uncovering Undo 352
- Working with Automatic Undo Management 354
- Understanding Undo Retention 355
- Using Flashback Technologies 357
- Using Flashback Drop and the Recycle Bin 357
- Using Flashback Query 367
- Using Flashback Versions Query 372
- Using Flashback Transaction Query 376
- Using Additional Flashback Operations 378
- Using Flashback Table 378
- Configuring and Monitoring Flashback Database
- and Performing Flashback Database Operations 382
- Setting Up and Using a Flashback Data Archive 387
- Summary 390
- Exam Essentials 391
- Review Questions 392
- Answers to Review Questions 397
- Chapter 10 Diagnosing the Database and
- Managing Performance 399
- Diagnosing the Database 400
- Setting Up the Automatic Diagnostic Repository 400
- Using the Support Workbench 403
- Performing Block Media Recovery 410
- Managing Database Performance 413
- Using the SQL Tuning Advisor 413
- Using the SQL Access Advisor to Tune a Workload 422
- Understanding Database Replay 428
- Summary 445
- Exam Essentials 446
- Review Questions 447
- Answers to Review Questions 452
- Chapter 11 Managing Database Resources 455
- Managing Memory 457
- Implementing Automatic Memory Management 457
- Manually Configuring SGA Parameters 467
- Configuring Automatic PGA Memory Management 470
- Managing Space 475
- Managing Resumable Space Allocation 475
- Managing Transportable Tablespaces 484
- Managing Transportable Databases 496
- Using Shrinking Segments 502
- Managing Resources 510
- Working with the Pending Area 512
- Resource Consumer Groups 515
- Resource Plans 525
- Resource-Plan Directives 533
- I/O Calibration with DRM 550
- Resource Manager Statistics in AWR 551
- Summary 551
- Exam Essentials 552
- Review Questions 553
- Answers to Review Questions 559
- Chapter 12 Using the Scheduler to Automate Tasks 561
- Automating Tasks with the Scheduler 563
- Exploring the Scheduler Architecture 564
- The Job Table 564
- The Job Coordinator 565
- The Job-Slave Processes 565
- RAC Considerations 566
- Data Guard Considerations 566
- Exploring Common Administration Tools 567
- Using the ENABLE Procedure 567
- Using the DISABLE Procedure 568
- Setting Attributes 570
- Using Scheduler Jobs 572
- Creating Jobs 572
- Copying Jobs 576
- Running Jobs 577
- Stopping Jobs 578
- Dropping Jobs 578
- Using Scheduler Programs 580
- Program Attributes 580
- Creating Programs 581
- Dropping Programs 583
- Using Schedules 583
- Schedule Attributes 584
- Creating Schedules 584
- Setting Repeat Intervals 585
- Testing Repeat Intervals 587
- Creating Lightweight Jobs 589
- Using Job Chains 591
- Creating a Chain 592
- Defining Chain Steps 592
- Adding Rules to a Chain 593
- Enabling a Chain 595
- Creating Jobs for Chains 595
- Using Scheduler Windows 597
- Creating Windows 598
- Opening and Closing Windows 599
- Window Logging 600
- Purging Logs 601
- Creating and Using Job Classes 602
- Job Class Parameters 602
- Creating Job Classes 603
- Dropping Job Classes 604
- Using Advanced Scheduler Concepts to Prioritize Jobs 604
- Prioritizing Jobs within a Job Class 605
- Using Scheduler Views 605
- Summary 607
- Exam Essentials 609
- Review Questions 610
- Answers to Review Questions 615
- Chapter 13 Implementing Globalization Support 617
- An Overview of Globalization Support 618
- Globalization Support Features 619
- Globalization Support Architecture 620
- Supporting Multilingual Applications 622
- Using Unicode in a Multilingual Database 625
- Using NLS Parameters 626
- Setting NLS Parameters 627
- Prioritizing NLS Parameters 640
- Using NLS Views 643
- Using Datetime Datatypes 646
- Using the DATE Datatype 647
- Using the TIMESTAMP Datatype 652
- Using the TIMESTAMP WITH TIME ZONE Datatype 653
- Using the TIMESTAMP WITH LOCAL TIME
- ZONE Datatype 654
- Using Linguistic Sorts and Searches 657
- An Overview of Text Sorting 657
- Using Linguistic Sort Parameters 660
- Linguistic Sort Types 666
- Searching Linguistic Strings 669
- Summary 671
- Exam Essentials 672
- Review Questions 673
- Answers to Review Questions 677
- Appendix A Lab Exercises 679
- Lab 1.1: Creating an ASM Instance 680
- Lab 1.2: Creating ASM Disk Groups 682
- Lab 1.3: Using ASM Disk Groups from a Database 685
- Lab 2.1: Executing a Manual Offline (Cold) Backup 688
- Lab 2.2: Putting the Database in ARCHIVELOG Mode 691
- Lab 2.3: Executing a Manual Online (Hot) Backup 693
- Lab 3.1: Executing a Time-Based Point-in-Time Recovery 697
- Lab 3.2: Recovering from Control-File Loss with a
- Backup Control File 700
- Lab 3.3: Recovering from Loss of the Current Online
- Redo Log 704
- Lab 4.1: Creating an RMAN Offline Backup 707
- Lab 4.2: Creating an RMAN Incremental Backup 709
- Lab 4.3: Creating an Image-Copy Backup 711
- Lab 5.1: Implementing RVPC 713
- Lab 6.1: Restoring a Datafile Online 714
- Lab 6.2: Performing a Change-Based Recovery with RMAN 718
- Lab 6.3: Restoring a Control File from an Autobackup 720
- Lab 7.1: Monitoring RMAN Backups 723
- Lab 7.2: One of My Backups Is Missing! 725
- Lab 8.1: Duplicating a Database Using Active Database
- Duplication 727
- Lab 8.2: Duplicating a Database Using Backup-Based
- Duplication to a Different Point in Time 731
- Lab 9.1: Using the Recycle Bin 737
- Lab 9.2: Performing a More Complex Flashback
- Query Analysis 738
- Lab 9.3: Using Flashback Data Archive 744
- Lab 10.1: Using Support Workbench to Report a Problem
- to Oracle Support 747
- Lab 10.2: Performing Block Media Recovery 748
- Lab 11.1: Exporting a Transportable Tablespace 757
- Lab 11.2: Testing Resumable Space Allocation 759
- Lab 11.3: Manually Configuring the SGA 761
- Lab 12.1: Creating a Local External Job 763
- Lab 12.2: Creating a Job Window 765
- Lab 13.1: Using the Locale Builder to Create a
- New Linguistic Sort 767
- Lab 13.2: Setting NLS Parameters 769
- Lab 13.3: Performing Linguistic Sorts 776
- Appendix B About the Companion CD 783
- What You’ll Find on the CD 784
- Sybex Test Engine 784
- PDF of the Book 784
- Adobe Reader 784
- Electronic Flashcards 785
- System Requirements 785
- Using the CD 785
- Troubleshooting 786
- Customer Care 786
- Glossary 787
- Index 801
