oracleocp培训Less01_DB_Architecture_MB3学习课件.pptx

Introduction

CourseObjectivesAftercompletingthiscourse,youshouldbeabletodothefollowing:Install,create,andadministerOracleDatabase10gConfigurethedatabaseforanapplicationEmploybasicmonitoringproceduresImplementabackupandrecoverystrategyMovedatabetweendatabasesandfiles

SuggestedSchedule1. Introduction2. Installation3. DBCreation4. Instance5. Storage6. Users7. Schema8. DataConcurrency9. Undo10. Security11. Network12. ProactiveMaintenance13. Performance14. BackupRecoveryConcepts15. Backup16. Recovery17. Flashback18. MovingData

LessonObjectivesAftercompletingthislesson,youshouldbeabletodothefollowing:DescribethecourseobjectivesExplaintheOracleDatabase10garchitecture

OracleProductsandServicesOracledatabasesOracleApplicationServerOracleapplicationsOracleCollaborationSuiteOracleDeveloperSuiteOracleservices

OracleDatabase10g:

“g”StandsforGridGlobalGridForum(GGF)Oracle’sgridinfrastructure:LowcostHighqualityofserviceEasytomanageAutomaticStorageManagementRealApplicationClustersOracleStreamsEnterpriseManager

GridControlStorage

gridDatabase

gridApplication

gridGrid

control

Grid

FullNotesPage

OracleDatabaseArchitectureAnOracleserver:Isadatabasemanagementsystemthatprovidesanopen,comprehensive,integratedapproachtoinformationmanagementConsistsofanOracleinstanceandanOracledatabase

DatabaseStructuresStoragestructuresMemorystructuresProcessstructuresInstanceSystemGlobalArea(SGA)BackgroundprocessesDatabasefilesDBstructures-Memory-Process-Storage

OracleMemoryStructures.JavapoolDatabasebuffercacheRedologbufferSharedpoolLargepoolSGAStreamspoolServerprocess1PGAServerprocess2PGABackgroundprocessPGADBstructures Memory Process Storage

OracleMemoryStructures

FullNotesPage

ProcessStructuresUserprocess:IsstartedatthetimeadatabaseuserrequestsaconnectiontotheOracleserverServerprocess:ConnectstotheOracleinstanceandiss