1 / 17

Introduction

Gain experience in using RMAN, database monitoring, job schedules, security, and globalization issues in Oracle Database 10g architecture. Learn logical and physical structures, memory, and storage management.

russellanderson
Download Presentation

Introduction

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Introduction

  2. Lesson Objectives • After completing this lesson, you should be able to do the following: • List the course objectives and explain the class structure • Review the Oracle Database 10g architecture

  3. Course Objectives • In this course, you gain experience in: • Using Recovery Manager (RMAN) for advanced backup and recovery • Employing database monitoring practices for memory, performance, and storage • Managing resources, job schedules, security, and globalization issues

  4. 1: Introduction 2: Configuring RMAN 3: Using RMAN 4: Non-Critical Recovery 5: Recovery 6: Flashback 7: Corruption 8: Memory 9: Performance 10: Schema 11: Storage 12: ASM 13: Resources 14: Scheduler 15: Security 16: Globalization 17: Workshop Appendixes Suggested Schedule

  5. What Is Covered in the DBAI Course • 1. Introduction • 2. Installation • 3. DB Creation • 4. Instance • 5. Storage • 6. Users • 7. Schema • 8. Data & Concurrency • 9. Undo • 10. Security • 11. Network • 12. Proactive Maintenance • 13. Performance • 14. Backup & Recovery Concepts • 15. Backup • 16. Recovery • 17. Flashback • 18. Moving Data

  6. Course Examples: The HR Schema REGIONS REGION_ID (PK) REGION_NAME REGIONS JOBS JOB_ID (PK) JOB_TITLE MIN_SALARY MAX_SALARY JOBS COUNTRIES COUNTRY_ID (PK) COUNTRY_NAME REGION_ID (FK) COUNTRIES JOB_HISTORY EMPLOYEE_ID (PK) START_DATE (PK) END_DATE JOB_ID (FK) DEPARTMENT_ID (FK) JOB_HISTORY LOCATIONS LOCATION_ID (PK) STREET_ADDRESS POSTAL_CODE CITY STATE_PROVINCE COUNTRY_ID (FK) EMPLOYEES EMPLOYEE_ID (PK) FIRST_NAME LAST_NAME EMAIL PHONE_NUMBER HIRE_DATE JOB_ID (FK) SALARY COMMISION_PCT MANAGER_ID (FK) DEPARTMENT_ID (FK) LOCATIONS EMPLOYEES DEPARTMENTS DEPARTMENT_ID (PK) DEPARTMENT_NAME MANAGER_ID LOCATION_ID (FK) DEPARTMENTS

  7. Oracle Database 10g: The Database for the Grid • Automatic Storage Management • Portable clusterware • Real Application Clusters and automatic workload management • Resource Manager • Oracle Streams • Centralized management with Enterprise Manager Grid Control • Oracle Database 10g new self-management features

  8. System Global Area (SGA) Database Architecture: Review Memory structures Instance Process structures Background processes Database files Storage structures

  9. Oracle Memory Structures Server process 1 Server process 2 Background process PGA PGA PGA SGA Streams pool Large pool Shared pool Database buffer cache Redo log buffer Java pool

  10. Oracle Processes Server process Server process Server process Server process System Global Area (SGA) System Monitor (SMON) Process Monitor (PMON) Database Writer (DBWn) Check-point (CKPT) LogWriter (LGWR) Archiver (ARCn) Background processes

  11. Reviewing Oracle Instance Management Example: Starting a database instance Establishing a connection 1 Instance SGA Database buffer cache Redo log buffer System Monitor (SMON) Process Monitor (PMON) Server process Database Writer (DBWn) LogWriter (LGWR) 3 2 User process Redo log files Data files

  12. Reviewing Oracle Instance Management Instance Example: Processing a SQL statement SGA Database buffer cache Redo log buffer 5 7 Database Writer (DBWn) Checkpoint (CKPT) Server process LogWriter (LGWR) Archiver (ARCn) 10 9 User process 8 6 Archive logs Redo log files Control file Data files 4 The user updates a row.

  13. Physical Database Structure • Data files • Online redo log files Control files • Parameter file • Backup files • Archive log files • Alert and trace log files • Password file

  14. Oracle Managed Files (OMF) • Specify file operations in terms of database objects rather than file names. Example: SQL> ALTER SYSTEM SET DB_CREATE_FILE_DEST = '/u01/oradata'; SQL> CREATE TABLESPACE tbs_1;

  15. Logical and Physical Database Structures Logical Physical Database Data file Schema Tablespace Segment Extent OS block Oracle datablock

  16. Database Architecture:Summary of Structural Components • Memory structures • System Global Area (SGA): Database buffer cache, redo buffer, and various pools • Program Global Area (PGA) • Process structures • User process and server process • Background processes: SMON, PMON, DBWn, CKPT, LGWR, ARCn, and so on • Storage structures • Logical: Database, schema, tablespace, segment, extent, and Oracle block • Physical: Files for data, parameters, redo, and OS block

  17. Summary • In this lesson, you should have learned how to: • List the course objectives • Review the Oracle Database 10g architecture

More Related