OCP: Oracle 10g Administration II Study Guide Exam 1Z0-043

by Stuns, Doug; Buterbaugh, Tim; Bryla, Bob

• ISBN13: 9780782143683
• ISBN10: 0782143687
• Edition: 1st
• Format: Paperback
• Copyright: 2005-02-22
• Publisher: Sybex

Summary

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.

Author Biography

Doug Stuns is an OCP with over 14 years of experience as an Oracle DBA, developer, and trainer.

Tim Buterbaugh, OCP, is a DBA with over 17 years? experience. He currently works as a consultant with EDS.

Bob Bryla OCP, has worked with Oracle databases for over 12 years.

Table of Contents

Introduction	xix
Assessment Test	xxxi
Configuring Recovery Manager	1	(36)
Exploring the Features and Components of RMAN	2	(2)
RMAN Usage Considerations	4	(2)
RMAN Repository and Control Files	6	(7)
RMAN Using the Recovery Catalog	7	(6)
Starting and Connecting to RMAN	13	(4)
Describing Media Management Layer	17	(1)
Describing Channel Allocation	17	(3)
Parameters and Persistent Settings for RMAN	20	(4)
Configuring RMAN Settings with Enterprise Manager	24	(3)
Describing Retention Policies	27	(2)
Configuring the Control File Autobackup	29	(1)
Summary	30	(1)
Exam Essentials	30	(1)
Review Questions	31	(4)
Answers to Review Questions	35	(2)
Using Recovery Manager	37	(48)
RMAN Commands	38	(7)
Backup Sets and Image Copies	45	(19)
Creating Backup Sets	45	(2)
Creating Image Copies	47	(3)
Compressed Backups	50	(2)
Full and Incremental Backups	52	(3)
Parallelization of Backup Sets	55	(6)
Backup Options	61	(3)
Enabling and Disabling Block Change Tracking	64	(2)
Managing Backups with Enterprise Manager	66	(3)
Monitoring RMAN Backups	69	(2)
Using LIST Commands	71	(2)
Using REPORT Commands	73	(2)
Working Examples Using RMAN	75	(2)
Enabling ARCHIVELOG Mode	75	(1)
Using RMAN to Back Up Archived Redo Logs	76	(1)
Scheduling a Backup Job	76	(1)
Summary	77	(1)
Exam Essentials	78	(1)
Review Questions	79	(4)
Answers to Review Questions	83	(2)
Recovering From Non-Critical Losses	85	(22)
An Overview of Non-Critical Files	86	(1)
Creating a New Temporary Tablespace	87	(3)
Starting the Database with a Missing Tempfile	89	(1)
Altering the Default Temporary Tablespace for a Database	90	(1)
Re-creating Redo Log Files	90	(2)
Recovering an Index Tablespace	92	(2)
Re-creating Indexes	93	(1)
Recovering Read-Only Tablespaces	94	(3)
Re-creating the Password File	97	(2)
Summary	99	(1)
Exam Essentials	99	(2)
Review Questions	101	(4)
Answers to Review Questions	105	(2)
Database Recovery	107	(56)
Understanding the Restore and Recovery Process	108	(1)
Server-Managed Recovery	109	(3)
User-Managed Recovery	112	(2)
Recovering Control Files	114	(15)
Recovering a Control File Autobackup	115	(5)
Re-creating a Control File	120	(9)
Performing an Incomplete Recovery	129	(10)
RMAN Incomplete Recovery	130	(5)
Performing User-Managed Incomplete Recovery	135	(4)
Database Recovery Using Enterprise Manager	139	(7)
Performing a Recovery after a RESETLOGS Operation	146	(8)
Summary	154	(1)
Exam Essentials	155	(1)
Review Questions	156	(4)
Answers to Review Questions	160	(3)
Understanding the Flashback Database	163	(32)
An Overview of Flashback Technologies	164	(1)
An Overview of the Flashback Database	165	(2)
Managing the Flash Recovery Area with Recovery Manager	167	(10)
Configuring the Flash Recovery Area	168	(1)
Using the Flash Recovery Area	168	(3)
Backing Up the Flash Recovery Area	171	(1)
Configuring the Flashback Database	172	(1)
Using the Flashback Database with RMAN	173	(2)
Monitoring the Flashback Database	175	(2)
Using the Flashback Database with Enterprise Manager	177	(10)
Configuring the Flashback Database with EM	177	(2)
Using the Flashback Database with EM	179	(7)
Monitoring the Flashback Database with EM	186	(1)
Summary	187	(1)
Exam Essentials	187	(1)
Review Questions	188	(4)
Answers to Review Questions	192	(3)
Recovering from User Errors	195	(30)
An Overview of Flashback Technologies	196	(1)
Using Flashback Drop	197	(7)
Understanding the Recycle Bin	198	(5)
Limitations on Flashback Drop and the Recycle Bin	203	(1)
Using EM to Perform Flashback Dropped Tables	204	(5)
Using Flashback Versions Query	209	(4)
Using Flashback Transaction Query	213	(2)
Using Flashback Table	215	(2)
Summary	217	(1)
Exam Essentials	218	(1)
Review Questions	219	(4)
Answers to Review Questions	223	(2)
Handling Block Corruption	225	(32)
An Overview of Block Corruption	226	(1)
Block Corruption Symptoms	226	(2)
Using Various Methods to Detect and Resolve Corruption	228	(15)
Using the Analyze Utility	229	(1)
Using the Dbverify Utility	229	(3)
Using DB_Block_Checking	232	(1)
Using the DBMS_Repair Package	233	(10)
Block Media Recovery	243	(2)
Summary	245	(1)
Exam Essentials	245	(1)
Review Questions	246	(7)
Answers to Review Questions	253	(4)
Understanding Automatic Database Management	257	(70)
Using the Automatic Workload Repository (AWR)	259	(15)
AWR Statistics Collection Facility	259	(3)
Workload Repository	262	(2)
Active Session History	264	(2)
AWR Snapshots	266	(3)
AWR Baselines	269	(1)
Using AWR Views	270	(2)
Using AWR Reports	272	(2)
Managing Server-Generated Alerts	274	(7)
Threshold and Non-Threshold Alerts	275	(1)
Default Alerts	275	(1)
An Overview of the Alert Process	275	(1)
Using Enterprise Manager to Configure Thresholds	276	(3)
Setting Thresholds through PL/SQL	279	(2)
Viewing Server Alerts	281	(1)
Using Automatic Routine
Administration Tasks	281	(1)
Automatic Statistics Collection	282	(12)
Understanding the Advisory Framework	294	(25)
An Overview of the Advisors	295	(5)
Automatic Database Diagnostic Monitor (ADDM)	300	(4)
SQL Tuning Advisor	304	(15)
Summary	319	(1)
Exam Essentials	320	(1)
Review Questions	321	(4)
Answers to Review Questions	325	(2)
Understanding Automatic Storage Management	327	(40)
Introducing the ASM Architecture	328	(2)
Understanding an ASM Instance	330	(4)
Creating an ASM Instance	330	(2)
Connecting to an ASM Instance	332	(1)
Starting Up and Shutting Down an ASM Instance	333	(1)
Defining ASM Initialization Parameters	334	(1)
Categorizing ASM Dynamic Performance Views	335	(1)
Using ASM Filenames	336	(2)
Fully Qualified Names	336	(1)
Numeric Names	337	(1)
Alias Names	337	(1)
Alias with Template Names	337	(1)
Incomplete Names	338	(1)
Incomplete Names with Template	338	(1)
Understanding ASM File Types and Templates	338	(3)
Administering ASM Disk Groups	341	(16)
Understanding Disk Group Architecture	341	(1)
Understanding Failure Groups and Disk Group Mirroring	341	(1)
Understanding Disk Group Dynamic Rebalancing	342	(1)
Creating and Deleting Disk Groups	342	(4)
Altering Disk Groups	346	(9)
Using EM Database Control with ASM Disk Groups	355	(2)
Using RMAN to Perform Database Migration to ASM	357	(1)
Summary	357	(1)
Exam Essentials	358	(2)
Review Questions	360	(5)
Answers to Review Questions	365	(2)
Understanding Globalization Support	367	(60)
An Overview of Globalization Support	368	(8)
Globalization Support Features	369	(1)
Globalization Support Architecture	370	(2)
Supporting Multilingual Applications	372	(2)
Using Unicode in a Multilingual Database	374	(2)
Using NLS Parameters	376	(19)
Setting NLS Parameters	376	(12)
Prioritizing NLS Parameters	388	(3)
Using NLS Views	391	(4)
Using Datetime Datatypes	395	(8)
Date Datatype	395	(5)
Timestamp Datatype	400	(1)
Timestamp With Time Zone Datatype	401	(1)
Timestamp With Local Time Zone Datatype	402	(1)
Using Linguistic Sorts and Searches	403	(14)
An Overview of Text Sorting	403	(3)
Using Linguistic Sort Parameters	406	(6)
Linguistic Sort Types	412	(4)
Searching Linguistic Strings	416	(1)
Summary	417	(1)
Exam Essentials	418	(1)
Review Questions	419	(5)
Answers to Review Questions	424	(3)
Managing Resources	427	(50)
An Overview of the Database Resource Manager	429	(1)
Working with the Pending Area	429	(3)
Creating a Pending Area	430	(1)
Validating Changes	430	(1)
Submitting the Pending Area	431	(1)
Clearing the Pending Area	432	(1)
Resource Consumer Groups	432	(11)
Managing Resource Consumer Groups	433	(10)
Resource Plans	443	(7)
Creating Simple Resource Plans	444	(3)
Creating Complex Resource Plans	447	(1)
Creating Resource Sub-Plans	448	(1)
Modifying Resource Plans	449	(1)
Deleting Resource Plans	450	(1)
Resource Plan Directives	450	(10)
Creating Resource Plan Directives	451	(9)
Putting the Pieces Together	460	(9)
Creating the Elements	460	(9)
Summary	469	(1)
Exam Essentials	470	(1)
Review Questions	471	(4)
Answers to Review Questions	475	(2)
Using the Scheduler to Automate Tasks	477	(46)
Scheduler Overview	478	(1)
Scheduler Architecture	479	(2)
The Job Table	480	(1)
The Job Coordinator	480	(1)
The Job Slave Processes	480	(1)
RAC Considerations	481	(1)
Common Administration Tools	481	(6)
Using the Enable Procedure	482	(1)
Using the Disable Procedure	483	(2)
Setting Attributes	485	(2)
Using Scheduler Jobs	487	(8)
Creating Jobs	487	(5)
Copying Jobs	492	(1)
Running Jobs	493	(1)
Stopping Jobs	494	(1)
Dropping Jobs	494	(1)
Using Job Classes	495	(2)
Job Class Parameters	495	(1)
Creating Job Classes	496	(1)
Dropping Job Classes	497	(1)
Using Scheduler Programs	497	(3)
Program Attributes	497	(1)
Creating Programs	498	(2)
Dropping Programs	500	(1)
Using Schedules	500	(7)
Schedule Attributes	501	(1)
Creating Schedules	501	(1)
Setting Repeat Intervals	502	(2)
Testing Repeat Intervals	504	(3)
Using Scheduler Windows	507	(4)
Creating Windows	507	(1)
Opening and Closing Windows	508	(1)
Window Logging	509	(2)
Purging Logs	511	(1)
Using Scheduler Views	511	(2)
Summary	513	(1)
Exam Essentials	514	(2)
Review Questions	516	(5)
Answers to Review Questions	521	(2)
Monitoring and Managing Storage	523	(74)
Monitoring Tablespace Storage	525	(11)
Space Usage Monitoring	525	(1)
Editing Thresholds with Enterprise Manager Database Control	526	(6)
Using DBMS_Server_Alert	532	(4)
Using Segment Management Tools	536	(23)
Segment Shrink	536	(6)
Segment Advisor	542	(14)
Index Space Monitoring	556	(3)
Understanding Special Table Types	559	(11)
Index-Organized Tables	559	(4)
Clustered Tables	563	(7)
Using Miscellaneous Space Management Tools	570	(13)
Controlling Undo Space	570	(2)
Controlling Redo Log File Space	572	(11)
Leveraging Resumable Space Allocation	583	(4)
An Overview of Resumable Space Allocation	583	(1)
Using Resumable Space Allocation	584	(1)
DBMS_Resumable Package	585	(1)
Using the After Suspend System Event	586	(1)
Resumable Space Allocation Data Dictionary Views	586	(1)
Summary	587	(1)
Exam Essentials	588	(1)
Review Questions	589	(5)
Answers to Review Questions	594	(3)
Securing the Oracle Listener, Diagnostic Sources, and Memory	597	(52)
Securing the Oracle Listener	598	(1)
An Overview of the TNS Listener	599	(16)
Managing the Listener Remotely	600	(1)
Setting the Listener Password	601	(3)
Controlling Database Access	604	(2)
Using Listener Logging	606	(2)
Removing Unneeded External Procedure Services	608	(3)
Creating a Separate Listener for External Procedures	611	(4)
Diagnostic Sources	615	(15)
Using the Oracle Alert Log	616	(9)
Using Server-Generated Alerts	625	(3)
Using Oracle Trace Files	628	(2)
Automatic Memory Management	630	(9)
Oracle Memory Usage	631	(8)
Summary	639	(1)
Exam Essentials	640	(2)
Review Questions	642	(5)
Answers to Review Questions	647	(2)
Glossary	649	(20)
Index	669