1 Introduction Copyright 2006 Oracle All rights reserved

1 Introduction Copyright © 2006, Oracle. All rights reserved.

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 10 g architecture 1 -2 Copyright © 2006, Oracle. All rights reserved.

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 1 -3 Copyright © 2006, Oracle. All rights reserved.

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

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

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

Oracle Database 10 g: The Database for the Grid • • 1 -7 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 10 g new self-management features Copyright © 2006, Oracle. All rights reserved.

Database Architecture: Review Memory structures Instance System Global Area (SGA) Process structures Background processes Storage structures 1 -8 Database files Copyright © 2006, Oracle. All rights reserved.

Oracle Memory Structures Server process 1 PGA Server process 2 Background process PGA SGA 1 -9 Shared pool Streams pool Large pool Java pool Database buffer cache Redo log buffer Copyright © 2006, Oracle. All rights reserved. PGA

Oracle Processes Server process System Global Area (SGA) System Monitor (SMON) Process Monitor (PMON) Database Writer (DBWn) Checkpoint (CKPT) Log. Writer (LGWR) Background processes 1 -11 Copyright © 2006, Oracle. All rights reserved. Archiver (ARCn)

Reviewing Oracle Instance Management Example: Starting a database instance Establishing a connection System Monitor (SMON) Process Monitor (PMON) 1 Instance SGA Database buffer cache Redo log buffer Database Writer (DBWn) Log. Writer (LGWR) Server 3 process 2 User process Data files 1 -12 Copyright © 2006, Oracle. All rights reserved. Redo log files

Reviewing Oracle Instance Management Instance Example: Processing a SQL statement 10 SGA 5 Server process 7 Database buffer cache Database Checkpoint Log. Writer Archiver Writer (CKPT) (LGWR) (ARCn) (DBWn) 9 User process 8 6 4 The user updates a row. 1 -13 Redo log buffer Data files Control file Copyright © 2006, Oracle. All rights reserved. Redo log files Archive logs

Physical Database Structure Control files Data files Parameter file Backup files Password file 1 -14 Online redo log files Archive log files Alert and trace log files Copyright © 2006, Oracle. All rights reserved.

Oracle Managed Files (OMF) Specify file operations in terms of database objects rather than file names. Parameter Description DB_CREATE_FILE_DEST Defines the location of the default file system directory for data files and temporary files DB_CREATE_ONLINE_LOG_DEST_n Defines the location for redo log files and control file creation DB_RECOVERY_FILE_DEST Defines the location for RMAN backups Example: SQL> ALTER SYSTEM SET DB_CREATE_FILE_DEST = '/u 01/oradata'; SQL> CREATE TABLESPACE tbs_1; 1 -16 Copyright © 2006, Oracle. All rights reserved.

Logical and Physical Database Structures Logical Physical Database Schema Tablespace Data file Segment Extent Oracle data block 1 -17 Copyright © 2006, Oracle. All rights reserved. OS block

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 1 -19 Copyright © 2006, Oracle. All rights reserved.

Summary In this lesson, you should have learned how to: • List the course objectives • Review the Oracle Database 10 g architecture 1 -20 Copyright © 2006, Oracle. All rights reserved.