《Oracle Database 10g-Administration Workshop II_共690页》pdf电子书免费下载
下载方式一：
百度网盘下载地址：https://pan.baidu.com/s/1EvJVVxIiK-1pcJlbtVXGcA
百度网盘密码：1111
下载方式二：
http://ziliaoshare.cn/Download/ae_123565_pd_OracleDatabase10g-AdministrationWorkshopII_G690Y.zip
|
|
作者：empty 页数：690 出版社：empty |
《Oracle Database 10g-Administration Workshop II_共690页》介绍
This document contains proprietary information and is protected by copyright another intellectual property laws.You may copy and print this document solely forown use in an Oracle training course.The document may not be modified or alteanyway.Except where your use constitutes TT air use under copyright law， yournot use， share， download， upload， copy， print， display， perform， reproduce， publlicense， post， trans mil， or distribute this document in whole or in part without theexpress authorization of Oracle.The information contained in this document is subject to change without notice.find any problems in the document， please report them in writing to：Oracle Unive500 Oracle Parkway， Redwood Shores， Califomnia94065USA.This document iswarranted to be error-free.Restricted Rights NoticeH this documentation is delivered to the United States Gove mn mentor anyone usthe documentation on behalf of the Unl ted States Gove mn ment.the following not iapplicable：U.S.GOVERNMENT RIGHTSThe U.S.Governments rights to use， mod ily， reproduce， release， perform， displadisclose these training materials are restricted by the terms of the applicable Or alicense agreement and/or the applicable U.S.Government contract.Trademark NoticeOracle， JD Edwards， and PeopleSoft are registered trademarks of Oracle Corpoandlor its affliates.Other names maybe trademarks of the irrespective ow mers.
Preface
PrPofileBefore You Begin This CourseBefore you begin this course， you should have the following qualifications：PrerequisitesOracleDatabase10g：AdministrationWorkshopI(D17090GC30)How This Course Is OrganizedWorking experience with SQL and knowledge of basic Unix commandsOracleDatabase10g：SQLTuningWorkshop(D17265GC10)Oracle Enterprise Manager 10gGrid Control(D17244GC 11)OracleDutabase10g：RealApplicationClusters(DI7276GC10)OracleDatabase10g：ImplementStreams(D17333GC10)OracleDatabase10g：DataGuardAdministration(D17316GC11)System release bulletinsInstallation and user guidesread.me filesInte mational Oracle Users Group(IOUG) articlesOracle Magu zineOracleDatabase10g：AdministrationWorkshop/isaninstructor-ledcoursefeaturinglecturcandhands-on exercises， Online demonstrations and written practice sessions reinforce the concepts and skillsintroduced.Suggested Next CoursesRelated PublicationsOracle PublicationsTitlePart NumberOracle Database 2DayDBAl0g Release 2(10.2)B14196-02Oracle Database Administrators Guide l0g Release 2(10.2)B14231-01Oracle Database Application Developer's Guide-Large Objects 10g Release 2(10.2) B 14249-01Oracle Database Backup and Recovery Advanced User'sGuide10g Release 2(10.2) B 14191-02Oracle Database Backup and Recovery Basics 10g Release 2(10.2)B14192-03Oracle Database Concepts l0g Release 2(10.2)B14220-02Oracle Database DataWarehousing Guide 10g Release 2(10.2)B14223-02Oracle Database Globalization Support Guide 10g Release 2(10.2)B14225-01Oracle Database Licensing Information 10g Release 2(10.2)B14199-02Oracle Database Net Services Administrator'Guide 10g Release 2(10.2)B14212-02Oracle Database Net Services Reference 10g Release 2(10.2)B14213-01Oracle Database New Features Guide 10g Release 2(10.2)B14214-02Oracle Database Performance Tuning Guide 10g Release 2(10.2)B14211-01Oracle Database PL/SQL Packages and Types Reference T0g Release 2(10.2)B14258-01Oracle Database PL/SQL Users Guide and Reference 10g Release 2(10.2)B14261-01Oracle Database Recovery Manager QuickStart Guide 10g Release 2(10.2)B14193-03Oracle Database Recovery Manager Reference 10g Release 2(10.2)B14194-03Oracle Database Reference 10g Release 2(10.2)B14237-02Oracle Database Security Guide 10g Release 2(10.2)B14266-01Oracle Database SQL Quick Reference 10g Release 2(10.2)B14195-02Oracle Database SQL Reference 10gRel case 2(10.2)B14200-02Oracle Database Utlties10g Release 2(10.2)B14215-01Oracle Streams Advanced Queuing User's Guide and ReferenceB14257-01Oracle Streams Concepts and AdministrationB14229-01Additional PublicationsPreface -3Preface -4
《Oracle Database 10g-Administration Workshop II_共690页》目录
Contents
Preface
Introduction
Lesson Objectives1-2
Course Objectives 1-3
Suggested Schedule 1-4
What Is Covered in the DBA I Course 1-5
CourseExamples：TheHRSchema1-6
OracleDatabase10g：TheDatabasefortheGrid1-7
DatabaseArchitecture：Review1-8
Oracle Memory Structures 1-9
Oracle Processes 1-11
Reviewing Oracle Instance Management 1-12
Physical Database Structure 1-14
Oracle Managed Files(OMF) 1-16
Logical and Physical Database Structures 1-17
DatabaseArchitecture：SummaryofStructuralComponents1-19
Summary 1-20
Configuring Recovery Manager
Objectives 2-2
BackupandRecovery：Review2-3
Features of Recovery Manager 2-4
Recovery Manager Components 2-6
Steps for Configuring RMAN 2-8
RMANRepositoryDataStorage：ComparisonofOptions2-9
Backup Destinations 2-11
Media Management 2-12
Using a Flash Recovery Area with RMAN 2-14
Monitoring the Flash Recovery Area with EM 2-16
Flash Recovery Area Space Usage 2-17
VS FLASH_RECOVERY_AREA_USAGE 2-18
Backing Up the Flash Recovery Area 2-20
Benefits of Using a Flash Recovery Area 2-21
Seting Parameters That Affect RMAN 2-22
RMAN Usage Considerations 2-24
Connection Types with RMAN 2-25
Starting RMAN 2-26
Additional RMAN Command-Line Arguments 2-27
Configuring Persistent Settings for RMAN 2-28
Configuring RM ANSett ngs by Using EM 2-29
Control File Auto backups 2-30
Retention Policies 2-32
Managing Persistent Settings 2-34
Channel Allocation 2-35
Automatic and Manual Channel Allocation 2-36
Channel Control Options 2-37
Summary 2-39
PracticeOverview：ConfiguringRMAN2-40
Using Recovery Manager
Objectives 3-2
Issuing Recovery Manager Commands 3-3
Types of RMAN Commands 3-5
JobCommands：Example3-6
RMANCommands：Overview3-7
BACKUP Command 3-9
Backup Constraints 3-10
Parallelization of Backup Sets 3-11
Compressed Backups 3-13
ImageCopy 3-14
Tags for Backups and Image Copies 3-16
BACKUP Command Options 3-17
Backing Up Archived Redo Logs 3-19
Whole Database Backup 3-21
RMAN Backup Types 3-22
Differential Versus Cumulative 3-24
Block Change Tracking 3-25
Enabling Block Change Tracking 3-26
Incrementally Updating Backups 3-27
LIST Command 3-28
REPORT Command 3-29
REPORT NEED BAC RUP Command 3-30
REPORTNEEDBACKUP：Examples3-31
REPORT OBSOLETE and DELETE OBSOLETE 3-32
Managing Backups with EM 3-33
RMAN Dynamic Views 3-34
Monitoring RMAN Backups 3-36
Summary 3-38
PracticeOverview：BackingUpYourDatabase3-39
4
Recovering from Noncritical Losses
Objectives 4-2
Causes of File Loss 4-3
Critical Versus Noncritical 4-4
Losing a TEMPFILE 4-5
Recovering from a TEMPFILE Loss 4-6
LogGroupStatus：Review4-7
Losing aRe do Log Group Member 4-8
Re-creating Redo LogFiles 4-9
Re-creating Indexes 4-13
Authentication Methods for Database Administrators 4-15
Re-crea in ga Password Authentication File 4-16
Summary 4-18
PracticeOverview：RecoverfromLostTEMPFILEandRedoLogFile4-19
Database Recovery
Objectives 5-2
Recovery Methods 5-3
User-ManagedRecovery：RECOVERCommand5-4
RMANRecovery：RESTOREandRECOVERCommands5-5
Recovery Using Enterprise Manager 5-6
Complete Versus Incomplete Recovery 5-7
Complete Recovery 5-8
Incomplete Recovery 5-9
Situations Requ ring Incomplete Recovery 5-11
Types of Incomplete Recovery 5-12
Performing User-Managed Incomplete Recovery 5-14
User-ManagedTime-BasedRecovery：Example5-16
User-ManagedCancel-BasedRecovery：Example5-18
Performing Incomplete Recovery by Using RMAN 5-20
Time-BasedRecoveryUsingRMAN：Example5-21
LogSequenceRecoveryUsingRMAN：Example5-23
Incomplete Recovery Using Enterprise Manager 5-24
Incomplete Recovery and the Alert Log 5-25
Restore Points 5-26
IncompleteRecovery：BestPractices5-27
Recovering a Control File Auto backup 5-29
Creating a New Control File 5-31
Recovering Read-Only Tablespaces 5-33
Read-Only Tablespace Recovery l ssues 5-35
Summary 5-37
PracticeOverview：PerformIncompleteRecovery5-38
Flashback
Objectives 6-2
FlashbackTechnology：Review6-3
Flash backDrop and the Recycle Bin 6-4
Recycle Bin 6-5
Restoring Tables from the Recycle Bin 6-7
RecycleBin：AutomaticSpaceReclamation6-8
RecycleBin：ManualSpaceReclamation6-10
Bypassing the Recycle Bin 6-11
Querying the Recycle Bin 6-12
Querying Data from Dropped Tables 6-13
FlashbackDatabase：Review6-14
Flashback Database Architecture 6-15
Configuring Flashback Database 6-16
Configuring Flashback Database Using EM 6-17
FlashbackDatabase：Examples6-19
Performing Flashback Database Using EM 6-20
Excluding Tablespaces from Flashback Database 6-23
Flashback Database Considerations 6-24
Monitoring Flashback Database 6-26
Monitoring Flashback Database with EM 6-28
Guaranteed Restore Points 6-29
Summary 6-30
PracticeOverview：PerformingFlashbackDatabase6-31
Dealing with Database Corruption
Objectives 7-2
What Is Block Corruption ?7-3
BlockCorruptionSymptoms：ORA-15787-4
Howto Handle Corruption 7-5
Corruption-Related Features 7-7
DB VERIFY Utility 7-8
Interpreting DB VERIFY Output 7-9
ANALYZE Command 7-11
VerifyingBlockIntegrityinRealTime：DB_BLOCK_CHECKING7-12
VerifyingBlockIntegrityinRealTime：DB_BLOCK_CHECKSUM7-13
Using EXP to Detect Corruption 7-14
Using Flashback for Logical Corruption 7-15
DBMS REPAIR Package 7-16
Using DBMS_REPAIR 7-17
Block Media Recovery(BMR) 7-21
BLOCK RECOVER Command 7-22
Examples of Using BLOCK RECOVER 7-23
The RMAN BMR Interface 7-25
Alternative Actions to Take 7-26
Summary 7-27
PracticeOverview：PerformBlockMediaRecovery7-28
Monitoring and Managing Memory
Objectives 8-2
MemoryManagement：Overview8-3
Oracle Memory Structures 8-4
Buffer Cache 8-6
Using Multiple Buffer Pools 8-8
Shared Pool 8-10
Large Pool 8-11
Java Pool 8-12
Redo Log Buffer 8-13
AutomaticSharedMemoryManagement：Overview8-14
Benefits of Automatic Shared Memory Management 8-15
vi
.How AS MM Works 8-16
Configuring AS MM by Using Database Control 8-17
Manually Configuring AS MM 8-18
Behavior of Auto tuned SGA Parameters 8-21
Behavior of Manually Tuned SGA Parameters 8-22
Using the VS PARAMETER View 8-23
Modifying the SGA TARGET Parameter 8-24
Disabling AS MM 8-25
Manually Resizing DynamicS GA Parameters 8-26
Program Global Area(PGA) 8-27
Automatic PGA Memory Management 8-29
PGA Management Resources 8-30
Using the Memory Advisor to Size the SGA 8-31
Using the Memory Advisor to Size the PGA 8-32
EfficientMemoryUsage：Guidelines8-33
Memory Tuning Guidelines for the Library Cache 8-35
Summary 8-37
Displaying Session-Related Statistics 9-13
PracticeOverview：UseASMMtoCorrectaMemoryAllocationProblem8-38
Automatic Performance Management
Objectives 9-2
Tuning Activities 9-3
Performance Planning 9-4
Instance Tuning 9-6
Performance Tuning Methodology 9-7
Statistics Collection 9-8
Oracle Wait Events 9-10
System Statistics 9-11
Displaying Service-Related Statistics 9-14
Trouble shooing and Tuning Views 9-15
Dictionary Views 9-16
Diagnosis of Hung or Extremely Slow Databases 9-17
Using Memory Access Mode 9-18
Using the Hang Analysis Page 9-19
Automatic Workload Repository 9-21
AWR Snapshot Baselines 9-23
AdvisoryFramework：Overview9-24
Database Control and Advisors 9-26
Typical Advisor Tuning Session 9-27
Manually Invoking ADD M 9-28
UsingtheSQLTuningAdvisor：Review9-29
SQLAccessAdvisor：Overview9-30
Typical SQL Access Advisor Session 9-31
Workload Source 9-32
Recommendation Options 9-33
Reviewing Recommendations 9-35
A synchron us CoMMIT 9-36
Using Asynchronous COMMIT 9-37
Summary 9-38
PracticeOverview：UseADDMtoDiagnosePerformanceProblems9-39
10 Managing Schema Objects
Objectives 10-2
Table Types 10-3
What Is a Pari tion and Why Use It?10-4
Partitions 10-5
Creating a Partition 10-6
Partitioning Methods 10-7
Partition Maintenance 10-8
Index-Organized Tables 10-9
Index-Organized Tables and Heap Tables 10-10
Creating Index-Organized Tables 10-12
Clusters 10-13
Cluster Types 10-14
Situations Where Clusters Are Useful 10-16
SortedHashCluster：Overview10-17
Sorted Hash Cluster.Example 10-18
SortedHashCluster：BasicArchitecture10-19
Schema Management Tasks 10-20
Estimating Resource Usage 10-21
Analyzing Growth Trends 10-22
Managing Optimizer Statistics 10-23
Reorganizing Schema Objects Online 10-24
ReorganizingObjects：ImpactReport10-26
ReorganizingObjects：Review10-27
Basic Steps for Manual Online Reorganization 10-28
Summary 10-29
PracticeOverview：ManagingSchemaObjects10-30
11 Managing Storage
Objectives 11-2
SpaceManagement：Overview11-3
FreeSpace Management 11-4
Types of Segments 11-5
Allocating Extents 11-6
Block Space Management 11-7
Row Chaining and Migration 11-8
Proactive Tablespace Monitoring 11-9
Thresholds and Resolving Space Problems 11-10
Monitoring Tablespace Space Usage 11-11
Shrinking Segments 11-12
Results of Shrink Operation 11-13
Space Reclamation with ASSM 11-14
SegmentAdvisor：Overview11-15
Segment Advisor 11-16
Implementing Recommendations 11-18
Database Control and Segment Shrink 11-19
Shrinking Segments by Using SQL 11-20
Managing Resum able Space Allocation 11-21
Using Resum able Space Allocation 11-22
Resuming Suspended Statements 11-24
Transporting Tablespaces 11-26
Concept Minimum Compati bi ity Level 11-27
Transportable Tablespace Procedure 11-28
Determining the Endian Format of a Platform 11-29
Transporting Databases 11-30
DatabaseTransportationProcedure：SourceSystemConversion11-31
DatabaseTransportationProcedure：TargetSystemConversion11-32
DatabaseTransportation：Considerations11-33
Summary 11-34
PracticeOverview：ManagingStorage11-35
12 Automatic Storage Management
Objectives 12-2
AutomaticStorageManagement：Review12-3
ASM General Architecture 12-5
ASM Instance Tasks 12-7
Creating an ASM Instance 12-8
ASM Instance Initialization Parameters 12-9
Database Instance Parameter Changes 12-10
Starting Up an ASM Instance 12-11
Accessing an ASM Instance 12-12
ASM HomePage 12-14
ASM Performance Page 12-15
ASM Configuration Page 12-16
Shutting Down an ASM Instance 12-17
DBC A and Storage Options 12-18
ASMStorage：Concepts12-19
ASM Disk Groups 12-20
Failure Group 12-21
Disk Group Mirroring 12-22
Disk Group Dynamic Rebalancing 12-23
Managing Disk Groups 12-24
ASM Administration Page 12-25
Create Disk Group Page 12-26
Creating and Dropping Disk Groups 12-27
Adding Disks to Disk Groups 12-28
Miscellaneous ALTER Commands 12-30
ASM Files 12-32
AS MCM DUt lity 12-33
Migrating Your Database to ASM Storage 12-34
Summary 12-36
PracticeOverview：UsingAutomaticStorageManagement12-37
13 Managing Resources
Objectives 13-2
DatabaseResourceManager：Overview13-3
Database ResourceManager Concepts 13-4
Why Use ResourceManager 13-5
Accessing Resource Plans 13-7
Example：SYSTEMPLAN13-8
Creating a New Resource Plan 13-9
Creating Consumer Groups 13-10
Assigning Users to Consumer Groups 13-11
Specifying Resource Plan Directives 13-12
Resource Allocation Methods for Resource Plans 13-13
Comparison of EMPHASIS and RATIO 13-14
Active Session Pool Mechanism 13-16
Setting the Active Session Pool 13-17
Maximum Estimated Execution Time 13-18
Consumer Group Switching 13-19
Switching Back to the Initial Consumer Group at the End of Call 13-20
Setting Idle Timeouts 13-22
Resource Consumer Group Mapping 13-23
Activa in ga Resource Plan for an Instance 13-25
Database ResourceManager Information 13-26
Monitoring the ResourceManager 13-27
Summary 13-30
PracticeOverview：UsingtheResourceManager13-31
14 Automating Tasks with the Scheduler
Objectives 14-2
Simplifying Management Tasks 14-3
A Simple Job 14-4
Key Components and Steps 14-5
1.Creating a Program 14-6
2.Creating and Using Schedules 14-7
3.Creating and Running a Job 14-8
4.Monitoring a Job 14-9
Using a Time-Based or Event-Based Schedule 14-10
Creating a Time-Based Job 14-11
Creating an Event-Based Schedule 14-13
Creating Event-Based Schedules with Enterprise Manager 14-14
ix
.Creating an Event Based Job 14-15
Event-Based Scheduling 14-16
Creating Complex Schedules 14-18
Creating Job Chains 14-19
Example of a Chain 14-21
1.Creating a Chain Object 14-22
2.Defining Chain Steps 14-23
3.Defining Chain Rules 14-24
4.Starting the Chain 14-25
Monitoring Job Chains 14-26
Advanced Scheduler Concepts 14-27
Creating a Job Class 14-28
Creating a Window 14-29
Prioritizing Jobs Within a Window 14-30
Summary 14-31
PracticeOverview：AutomatingTaskswiththeScheduler14-32
15 Database Security
Objectives 15-2
Oracle Transparent Data Encryption(TDE) ：Overview 15-3
TDE Process 15-5
Implemen ing Transparent Data Encryption 15-6
Existing Tables and TDE 15-9
TransparentDataEncryption：Considerations15-10
Wallet Support for Use mames and Passwords 15-11
Data Pump and Transparent Data Encryption 15-12
RMANEncryptedBackups：Overview15-13
Transparent Mode Setup 15-14
Password Mode Setup 15-15
Dual Mode Setup 15-16
RMAN-EncryptedBackups：Considerations15-17
Need for Data Privacy 15-18
Definition and Usage of Terms 15-19
VirtualPrivateDatabase：Overview15-20
VirtualPrivateDatabase：Features15-21
Column-LevelVPD：Example15-22
Creating a Column-Level Policy 15-23
Summary 15-24
PracticeOverview：UsingOracleDatabaseSecurity15-25
16 Using Globalization Support
Objectives 16-2
What Every DBA Needs to Know 16-3
What Is a Character Set?16-4
Understanding Unicode 16-6
How Are Character Sets Used ?16-8
Problems to Avoid 16-9
Another Sample Problem 16-10
Choosing Your Character Set 16-11
Database Character Sets and National Character Sets 16-12
Obtaining Character Set Information 16-13
Specifying Language-Dependent Behavior 16-14
Specifying Language-Dependent Behavior for the Session 16-15
Language-and Territory-Dependent Parameters 16-16
Specifying Language-Dependent Behavior 16-18
Linguistic Searching and Sorting 16-19
Using Linguistic Searching and Sorting 16-21
Case-and Accent-Insensitive Search and Sort 16-23
Support in SQL and Functions 16-24
Linguistic Index Support 16-25
Customizing Linguistic Searching and Sorting 16-26
Implicit Conversion Between CLOB and NC LOB 16-27
NLS Data Conversion with Oracle Utilities 16-28
NLS Data Conversion with Data Pump 16-30