![Page 1: 1 Copyright © 2006, Oracle. All rights reserved. Introduction](https://reader036.vdocuments.us/reader036/viewer/2022082713/56649ef65503460f94c0940e/html5/thumbnails/1.jpg)
1Copyright © 2006, Oracle. All rights reserved.
Introduction
![Page 2: 1 Copyright © 2006, Oracle. All rights reserved. Introduction](https://reader036.vdocuments.us/reader036/viewer/2022082713/56649ef65503460f94c0940e/html5/thumbnails/2.jpg)
Copyright © 2006, Oracle. All rights reserved.1-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
![Page 3: 1 Copyright © 2006, Oracle. All rights reserved. Introduction](https://reader036.vdocuments.us/reader036/viewer/2022082713/56649ef65503460f94c0940e/html5/thumbnails/3.jpg)
Copyright © 2006, Oracle. All rights reserved.1-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
![Page 4: 1 Copyright © 2006, Oracle. All rights reserved. Introduction](https://reader036.vdocuments.us/reader036/viewer/2022082713/56649ef65503460f94c0940e/html5/thumbnails/4.jpg)
Copyright © 2006, Oracle. All rights reserved.1-4
Suggested Schedule
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
![Page 5: 1 Copyright © 2006, Oracle. All rights reserved. Introduction](https://reader036.vdocuments.us/reader036/viewer/2022082713/56649ef65503460f94c0940e/html5/thumbnails/5.jpg)
Copyright © 2006, Oracle. All rights reserved.1-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. Recovery17. Flashback18. Moving Data
![Page 6: 1 Copyright © 2006, Oracle. All rights reserved. Introduction](https://reader036.vdocuments.us/reader036/viewer/2022082713/56649ef65503460f94c0940e/html5/thumbnails/6.jpg)
Copyright © 2006, Oracle. All rights reserved.1-6
Course Examples: The HR Schema
REGIONSREGION_ID (PK)REGION_NAME
COUNTRIESCOUNTRY_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_SALARY
EMPLOYEESEMPLOYEE_ID (PK)FIRST_NAMELAST_NAMEEMAILPHONE_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)
REGIONS
COUNTRIES
LOCATIONS
DEPARTMENTS
JOBS
EMPLOYEES
JOB_HISTORY
![Page 7: 1 Copyright © 2006, Oracle. All rights reserved. Introduction](https://reader036.vdocuments.us/reader036/viewer/2022082713/56649ef65503460f94c0940e/html5/thumbnails/7.jpg)
Copyright © 2006, Oracle. All rights reserved.1-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
![Page 8: 1 Copyright © 2006, Oracle. All rights reserved. Introduction](https://reader036.vdocuments.us/reader036/viewer/2022082713/56649ef65503460f94c0940e/html5/thumbnails/8.jpg)
Copyright © 2006, Oracle. All rights reserved.1-8
Database Architecture: Review
Storage structures
Memory structures
Process structures
Instance
System Global Area (SGA)
Background processes
Database files
![Page 9: 1 Copyright © 2006, Oracle. All rights reserved. Introduction](https://reader036.vdocuments.us/reader036/viewer/2022082713/56649ef65503460f94c0940e/html5/thumbnails/9.jpg)
Copyright © 2006, Oracle. All rights reserved.1-9
Oracle Memory Structures
Java poolDatabase
buffer cacheRedo log
buffer
Shared pool Large pool
SGA
Streams pool
Serverprocess
1PGA
Serverprocess
2PGA
Backgroundprocess
PGA
![Page 10: 1 Copyright © 2006, Oracle. All rights reserved. Introduction](https://reader036.vdocuments.us/reader036/viewer/2022082713/56649ef65503460f94c0940e/html5/thumbnails/10.jpg)
Copyright © 2006, Oracle. All rights reserved.1-11
Oracle Processes
SystemMonitor(SMON)
DatabaseWriter
(DBWn)
Check-point
(CKPT)
LogWriter(LGWR)
ProcessMonitor(PMON)
Archiver(ARCn)
Serverprocess
Serverprocess
Serverprocess
Serverprocess
System Global Area(SGA)
Background processes
![Page 11: 1 Copyright © 2006, Oracle. All rights reserved. Introduction](https://reader036.vdocuments.us/reader036/viewer/2022082713/56649ef65503460f94c0940e/html5/thumbnails/11.jpg)
Copyright © 2006, Oracle. All rights reserved.1-12
Reviewing Oracle Instance Management
SGA
DatabaseWriter
(DBWn)
LogWriter(LGWR)
Databasebuffer cache
Redo log buffer
1
User process
2
Example:
Starting a database instance
Establishing a connection
SystemMonitor(SMON)
ProcessMonitor(PMON)
Data files Redo log files
Instance
Serverprocess
3
![Page 12: 1 Copyright © 2006, Oracle. All rights reserved. Introduction](https://reader036.vdocuments.us/reader036/viewer/2022082713/56649ef65503460f94c0940e/html5/thumbnails/12.jpg)
Copyright © 2006, Oracle. All rights reserved.1-13
The user updates a row.Redo log
files
Reviewing Oracle Instance Management
Instance
SGA
DatabaseWriter
(DBWn)
Databasebuffer cache
Redo log buffer
Serverprocess
User process
4
10
7
6
5
8
Example:
Processing a
SQL statement
Archiver(ARCn)
9
Checkpoint(CKPT)
Data files Archive logs
Control file
LogWriter(LGWR)
![Page 13: 1 Copyright © 2006, Oracle. All rights reserved. Introduction](https://reader036.vdocuments.us/reader036/viewer/2022082713/56649ef65503460f94c0940e/html5/thumbnails/13.jpg)
Copyright © 2006, Oracle. All rights reserved.1-14
Physical Database Structure
Online redo log files
Password file
Parameter file Archive log files
Control files Data files
Alert and trace log files
Backup files
![Page 14: 1 Copyright © 2006, Oracle. All rights reserved. Introduction](https://reader036.vdocuments.us/reader036/viewer/2022082713/56649ef65503460f94c0940e/html5/thumbnails/14.jpg)
Copyright © 2006, Oracle. All rights reserved.1-16
Example:SQL> ALTER SYSTEM SET DB_CREATE_FILE_DEST = '/u01/oradata'; SQL> CREATE TABLESPACE tbs_1;
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
![Page 15: 1 Copyright © 2006, Oracle. All rights reserved. Introduction](https://reader036.vdocuments.us/reader036/viewer/2022082713/56649ef65503460f94c0940e/html5/thumbnails/15.jpg)
Copyright © 2006, Oracle. All rights reserved.1-17
Logical and Physical Database Structures
Database
Logical Physical
Tablespace Data file
OS block
Segment
Extent
Oracle datablock
Schema
![Page 16: 1 Copyright © 2006, Oracle. All rights reserved. Introduction](https://reader036.vdocuments.us/reader036/viewer/2022082713/56649ef65503460f94c0940e/html5/thumbnails/16.jpg)
Copyright © 2006, Oracle. All rights reserved.1-19
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
![Page 17: 1 Copyright © 2006, Oracle. All rights reserved. Introduction](https://reader036.vdocuments.us/reader036/viewer/2022082713/56649ef65503460f94c0940e/html5/thumbnails/17.jpg)
Copyright © 2006, Oracle. All rights reserved.1-20
Summary
In this lesson, you should have learned how to:
• List the course objectives
• Review the Oracle Database 10g architecture