I
Introduction
Copyright © 2007, Oracle. All rights reserved.
Course Objectives
After completing this course, you should be able to:
• • Configure the Oracle Database for optimal recovery
• Back up and recover a database (and its parts) with
Recovery Manager (RMAN)
• Use flashback technology to view past states of data and
to revert objects to a past state
• Identify burdensome database sessions and poorly
performing SQL
• Use an appropriate and flexible memory configuration
• Configure resource allocations among sessions and tasks
• Schedule jobs to run inside or outside the database
• Use compression to optimize database storage and
duplicate a database
I-2 Copyright © 2007, Oracle. All rights reserved.
Suggested Schedule
Day Lessons Day Lessons
1 1. Core Concepts and Tools of the 3 9. Diagnosing the Database
Oracle Database 10. Using Flashback Technology I
2. Configuring for Recoverability 11. Using Flashback technology II
3. Using the RMAN Recovery Catalog 12. Performing Flashback Database
4. Configuring Backup Settings
4 13. Managing Memory
2 5. Creating Backups with RMAN 14. Managing Database Performance
6. Restore and Recovery Tasks 15. Managing Performance by SQL
7. Using RMAN to Perform Recovery Tuning
8. Monitoring and Tuning RMAN 16. Managing Resources
17. Automating Tasks with the
Scheduler
5 18. Managing Space
19. Managing Space for the Database
20. Duplicating a Database
I-3 Copyright © 2007, Oracle. All rights reserved.
Oracle Database 11g:
“g” Stands for Grid
• Global Grid Forum (GGF)
• Oracle’s grid infrastructure:
– Low cost
– High quality of service
– Easy to manage
Storage Database Application Grid
grid grid grid control
Automatic Real Oracle Enterprise
Storage Application Streams Manager
Management Clusters Grid Control
I-4 Copyright © 2007, Oracle. All rights reserved.
Grid Infrastructure for Single-Instance
Grid Infrastructure for Single-Instance is introduced with Oracle
Database 11 g Release 2 (11.2)
• Is installed from the clusterware media, separate from the Oracle
database software
• Contains Oracle Automatic Storage Management (ASM)
• Contains Oracle Restart—a high availability solution for
nonclustered databases
-- Can monitor and restart the following components:
o
— Database instances
— Oracle Net listener
— Database services
— ASM instance
— ASM disk groups
— Oracle Notification Services (ONS/eONS) for Data Guard
I-6 Copyright © 2007, Oracle. All rights reserved.
Oracle Database Innovation
Private DB Cloud
… continuing with Defense in Depth
Oracle Database 12c Information Lifecycle Mgt
Extreme Availability
Flex Clusters
Performance and Ease of Use
Oracle Grid Infrastructure
… with Oracle Database 11g
Real Application Testing
Automatic SQL Tuning
Fault Management
Audit Vault
Database Vault
Secure Enterprise Search
… with Oracle Grid Computing
Database 10gAutomatic Storage Mgmt
Self Managing Database
XML Database, Oracle Data Guard, RAC, Flashback Query, Virtual Private Database
Built-in Java VM , Partitioning Support, Built-in Messaging, Object Relational Support, Multimedia Support
I-7 Copyright © 2007, Oracle. All rights reserved.
Enterprise Cloud Computing
Enterprise Manager
RAC Grids of Managing Cloud Control and
clusters low-cost change database
for hardware and across the consolidation across
availability storage enterprise the enterprise
I-8 Copyright © 2007, Oracle. All rights reserved.
Course Examples: HR Sample Schema
REGIONS
REGION_ID (PK)
REGION_NAME
JOBS
COUNTRIES JOB_ID (PK)
COUNTRY_ID (PK) JOB_TITLE
COUNTRY_NAME MIN_SALARY JOB_HISTORY
REGION_ID (FK) MAX_SALARY EMPLOYEE_ID (PK)
START_DATE (PK)
END_DATE
JOB_ID (FK)
LOCATIONS EMPLOYEES DEPARTMENT_ID (FK)
LOCATION_ID (PK) EMPLOYEE_ID (PK)
STREET_ADDRESS FIRST_NAME
POSTAL_CODE LAST_NAME
CITY EMAIL
STATE_PROVINCE PHONE_NUMBER
COUNTRY_ID (FK) HIRE_DATE
JOB_ID (FK)
SALARY
COMMISION_PCT
DEPARTMENTS MANAGER_ID (FK)
DEPARTMENT_ID (PK) DEPARTMENT_ID (FK)
DEPARTMENT_NAME
MANAGER_ID
LOCATION_ID (FK)
I-9 Copyright © 2007, Oracle. All rights reserved.