oracle ocp培训Less01_DB_Architecture_MB3

1、1Copyright 2005, Oracle. All rights reserved.IntroductionCopyright 2005, Oracle. All rights reserved.1-2Course ObjectivesAfter completing this course, you should be able to do the following:Install, create, and administer Oracle Database 10gConfigure the database for an applicationEmploy basic monit

2、oring proceduresImplement a backup and recovery strategyMove data between databases and filesCopyright 2005, Oracle. All rights reserved.1-3Suggested Schedule1.Introduction2.Installation3.DB Creation4.Instance5.Storage6.Users7.Schema8.Data & Concurrency9.Undo10. Security11. Network12. Proactive

3、Maintenance13. Performance14. Backup & Recovery Concepts15. Backup16. Recovery17. Flashback18. Moving DataCopyright 2005, Oracle. All rights reserved.1-4Lesson ObjectivesAfter completing this lesson, you should be able to do the following:Describe the course objectivesExplain the Oracle Database

4、 10g architectureCopyright 2005, Oracle. All rights reserved.1-5Oracle Products and ServicesOracle databasesOracle Application ServerOracle applicationsOracle Collaboration SuiteOracle Developer SuiteOracle servicesCopyright 2005, Oracle. All rights reserved.1-6Oracle Database 10g:“g” Stands for Gri

5、dGlobal Grid Forum (GGF)Oracles grid infrastructure: Low cost High quality of service Easy to manageAutomaticStorageManagementRealApplicationClustersOracleStreamsEnterpriseManagerGrid ControlStoragegridDatabasegridApplicationgridGridcontrolCopyright 2005, Oracle. All rights reserved.1-7Grid Full Not

6、es PageCopyright 2005, Oracle. All rights reserved.1-8Oracle Database ArchitectureAn Oracle server:Is a database management system that provides an open, comprehensive, integrated approach to information managementConsists of an Oracle instance and an Oracle databaseCopyright 2005, Oracle. All right

7、s reserved.1-9Database StructuresStorage structuresMemory structuresProcess structuresInstanceSystem Global Area (SGA)Background processesDatabase filesDB structures - Memory - Process - StorageCopyright 2005, Oracle. All rights reserved.1-10Oracle Memory Structures .Java poolDatabasebuffer cacheRed

8、o log bufferShared poolLarge poolSGAStreams poolServerprocess1PGAServerprocess2PGABackgroundprocessPGADB structures MemoryProcessStorageCopyright 2005, Oracle. All rights reserved.1-11Oracle Memory StructuresFull Notes PageCopyright 2005, Oracle. All rights reserved.1-12Process StructuresUser proces

9、s: Is started at the time a database user requests a connection to the Oracle serverServer process: Connects to the Oracle instance and is started when a user establishes a sessionBackground processes: Are started when an Oracle instance is startedInstanceSGABackground processesServerprocessPGAUser

10、processDB structuresMemory Process StorageCopyright 2005, Oracle. All rights reserved.1-13Oracle Instance ManagementSystemMonitor(SMON)DatabaseWriter(DBWn)LogWriter(LGWR)ProcessMonitor(PMON)Archiver(ARCn)SGAJava poolShared poolLarge poolStreams poolDatabasebuffer cacheRedo log bufferCheckpoint(CKPT)

11、ControlfilesDatafilesRedo logfilesArchive log filesCopyright 2005, Oracle. All rights reserved.1-14Server Process and Database Buffer CacheBuffers:PinnedCleanFree or unusedDirtyDBWnServerprocessSGADatabasebuffer cacheData filesCopyright 2005, Oracle. All rights reserved.1-15Physical Database Structu

12、re .Online redo log filesPassword fileParameter fileArchive log filesControl filesData filesAlert and trace log filesBackup filesDB structuresMemoryProcess StorageCopyright 2005, Oracle. All rights reserved.1-16Physical Database StructureFull Notes PageCopyright 2005, Oracle. All rights reserved.1-1

13、7Tablespaces and Data FilesTablespaces consist of one or more data files.Data files belong to only one tablespace.USERS tablespaceData file 1Data file 2Copyright 2005, Oracle. All rights reserved.1-18SYSTEM and SYSAUX Tablespaces The SYSTEM and SYSAUX tablespaces are mandatory tablespaces.They are c

14、reated at the time of database creation.They must be online.The SYSTEM tablespace is used for core functionality (for example, data dictionary tables).The auxiliary SYSAUX tablespace is used for additional database components (such as the Enterprise Manager Repository).Copyright 2005, Oracle. All ri

15、ghts reserved.1-19Segments, Extents, and BlocksSegments exist within a tablespace.Segments are made up of a collection of extents.Extents are a collection of data blocks.Data blocks are mapped to disk blocks.SegmentExtentsData blocksDisk blocksCopyright 2005, Oracle. All rights reserved.1-20Logical

16、and Physical Database StructuresDatabaseLogicalPhysicalTablespaceData fileOS blockSegmentExtentOracle datablockSchemaCopyright 2005, Oracle. All rights reserved.1-21Database StructuresFull Notes PageCopyright 2005, Oracle. All rights reserved.1-22Course Examples: The HR SchemaREGIONSREGION_ID (PK)RE

17、GION_NAMECOUNTRIESCOUNTRY_ID (PK)COUNTRY_NAMEREGION_ID (FK)LOCATIONSLOCATION_ID (PK)STREET_ADDRESSPOSTAL_CODECITYSTATE_PROVINCECOUNTRY_ID (FK)DEPARTMENTSDEPARTMENT_ID (PK)DEPARTMENT_NAMEMANAGER_IDLOCATION_ID (FK)JOBSJOB_ID (PK)JOB_TITLEMIN_SALARYMAX_SALARYEMPLOYEESEMPLOYEE_ID (PK)FIRST_NAMELAST_NAME

18、EMAILPHONE_NUMBERHIRE_DATEJOB_ID (FK)SALARYCOMMISION_PCTMANAGER_ID (FK)DEPARTMENT_ID (FK)JOB_HISTORYEMPLOYEE_ID (PK)START_DATE (PK)END_DATEJOB_ID (FK)DEPARTMENT_ID (FK)REGIONSCOUNTRIESLOCATIONSDEPARTMENTSJOBSEMPLOYEESJOB_HISTORYCopyright 2005, Oracle. All rights reserved.1-23Database Architecture:Summary of Structural ComponentsMemory structures: System Global Area (SGA): Database buffer cache, redo buffer, and