Oracle DBA Avanzado
RMAN

Duración: 40hs

Temario:

1 Introduction
Lesson Objectives 1-2
Course Objectives 1-3
Suggested Schedule 1-4
What Is Covered in the DBAI Course 1-5
Course Examples: The HR Schema 1-6
Oracle Database 10g: The Database for the Grid 1-7
Database Architecture: Review 1-8
Oracle Memory Structures 1-9
Oracle Processes 1-11
Reviewing Oracle Instance Management 1-12
Physical Database Structure 1-14
Oracle Managed Files (OMF) 1-16
Logical and Physical Database Structures 1-17
Database Architecture: Summary of Structural Components 1-19
Summary 1-20

2 Configuring Recovery Manager
Objectives 2-2
Backup and Recovery: Review 2-3
Features of Recovery Manager 2-4
Recovery Manager Components 2-6
Steps for Configuring RMAN 2-8
RMAN Repository Data Storage: Comparison of Options 2-9
Backup Destinations 2-11
Media Management 2-12
Using a Flash Recovery Area with RMAN 2-14
Monitoring the Flash Recovery Area with EM 2-16
Flash Recovery Area Space Usage 2-17
V$FLASH_RECOVERY_AREA_USAGE 2-18
Backing Up the Flash Recovery Area 2-20
Benefits of Using a Flash Recovery Area 2-21
Setting Parameters That Affect RMAN 2-22
RMAN Usage Considerations 2-24
Connection Types with RMAN 2-25
Starting RMAN 2-26
Additional RMAN Command-Line Arguments 2-27
Configuring Persistent Settings for RMAN 2-28
Configuring RMAN Settings by Using EM 2-29
Control File Autobackups 2-30
Retention Policies 2-32
Managing Persistent Settings 2-34
Channel Allocation 2-35
Automatic and Manual Channel Allocation 2-36
Channel Control Options 2-37
Summary 2-39
Practice Overview: Configuring RMAN 2-40

3 Using Recovery Manager
Objectives 3-2
Issuing Recovery Manager Commands 3-3
Types of RMAN Commands 3-5
Job Commands: Example 3-6
RMAN Commands: Overview 3-7
BACKUP Command 3-9
Backup Constraints 3-10
Parallelization of Backup Sets 3-11
Compressed Backups 3-13
Image Copy 3-14
Tags for Backups and Image Copies 3-16
BACKUP Command Options 3-17
Backing Up Archived Redo Logs 3-19
Whole Database Backup 3-21
RMAN Backup Types 3-22
Differential Versus Cumulative 3-24
Block Change Tracking 3-25
Enabling Block Change Tracking 3-26
Incrementally Updating Backups 3-27
LIST Command 3-28
REPORT Command 3-29
REPORT NEED BACKUP Command 3-30
REPORT NEED BACKUP: Examples 3-31
REPORT OBSOLETE and DELETE OBSOLETE 3-32
Managing Backups with EM 3-33
RMAN Dynamic Views 3-34
Monitoring RMAN Backups 3-36
Summary 3-38
Practice Overview: Backing Up Your Database 3-39

4 Recovering from Noncritical Losses
Objectives 4-2
Causes of File Loss 4-3
Critical Versus Noncritical 4-4
Losing a TEMPFILE 4-5
Recovering from a TEMPFILE Loss 4-6
Log Group Status: Review 4-7
Losing a Redo Log Group Member 4-8
Re-creating Redo Log Files 4-9
Re-creating Indexes 4-13
Authentication Methods for Database Administrators 4-15
Re-creating a Password Authentication File 4-16
Summary 4-18
Practice Overview: Recover from Lost TEMPFILE and Redo Log File 4-19

5 Database Recovery
Objectives 5-2
Recovery Methods 5-3
User-Managed Recovery: RECOVER Command 5-4
RMAN Recovery: RESTORE and RECOVER Commands 5-5
Recovery Using Enterprise Manager 5-6
Complete Versus Incomplete Recovery 5-7
Complete Recovery 5-8
Incomplete Recovery 5-9
Situations Requiring Incomplete Recovery 5-11
Types of Incomplete Recovery 5-12
Performing User-Managed Incomplete Recovery 5-14
User-Managed Time-Based Recovery: Example 5-16
User-Managed Cancel-Based Recovery: Example 5-18
Performing Incomplete Recovery by Using RMAN 5-20
Time-Based Recovery Using RMAN: Example 5-21
Log Sequence Recovery Using RMAN: Example 5-23
Incomplete Recovery Using Enterprise Manager 5-24
Incomplete Recovery and the Alert Log 5-25
Restore Points 5-26
Incomplete Recovery: Best Practices 5-27
Recovering a Control File Autobackup 5-29
Creating a New Control File 5-31
Recovering Read-Only Tablespaces 5-33
Read-Only Tablespace Recovery Issues 5-35
Summary 5-37
Practice Overview: Perform Incomplete Recovery 5-38

6 Flashback
Objectives 6-2
Flashback Technology: Review 6-3
Flashback Drop and the Recycle Bin 6-4
Recycle Bin 6-5
Restoring Tables from the Recycle Bin 6-7
Recycle Bin: Automatic Space Reclamation 6-8
Recycle Bin: Manual Space Reclamation 6-10
Bypassing the Recycle Bin 6-11
Querying the Recycle Bin 6-12
Querying Data from Dropped Tables 6-13
Flashback Database: Review 6-14
Flashback Database Architecture 6-15
Configuring Flashback Database 6-16
Configuring Flashback Database Using EM 6-17
Flashback Database: Examples 6-19
Performing Flashback Database Using EM 6-20
Excluding Tablespaces from Flashback Database 6-23
Flashback Database Considerations 6-24
Monitoring Flashback Database 6-26
Monitoring Flashback Database with EM 6-28
Guaranteed Restore Points 6-29
Summary 6-30
Practice Overview: Performing Flashback Database 6-31

7 Dealing with Database Corruption
Objectives 7-2
What Is Block Corruption? 7-3
Block Corruption Symptoms: ORA-1578 7-4
How to Handle Corruption 7-5
Corruption-Related Features 7-7
DBVERIFY Utility 7-8
Interpreting DBVERIFY Output 7-9
ANALYZE Command 7-11
Verifying Block Integrity in Real Time: DB_BLOCK_CHECKING 7-12
Verifying Block Integrity in Real Time: DB_BLOCK_CHECKSUM 7-13
Using EXP to Detect Corruption 7-14
Using Flashback for Logical Corruption 7-15
DBMS_REPAIR Package 7-16
Using DBMS_REPAIR 7-17
Block Media Recovery (BMR) 7-21
BLOCKRECOVER Command 7-22
Examples of Using BLOCKRECOVER 7-23
The RMAN BMR Interface 7-25
Alternative Actions to Take 7-26
Summary 7-27
Practice Overview: Perform Block Media Recovery 7-28

8 Monitoring and Managing Memory
Objectives 8-2
Memory Management: Overview 8-3
Oracle Memory Structures 8-4
Buffer Cache 8-6
Using Multiple Buffer Pools 8-8
Shared Pool 8-10
Large Pool 8-11
Java Pool 8-12
Redo Log Buffer 8-13
Automatic Shared Memory Management: Overview 8-14
Benefits of Automatic Shared Memory Management 8-15
How ASMM Works 8-16
Configuring ASMM by Using Database Control 8-17
Manually Configuring ASMM 8-18
Behavior of Autotuned SGA Parameters 8-21
Behavior of Manually Tuned SGA Parameters 8-22
Using the V$PARAMETER View 8-23
Modifying the SGA_TARGET Parameter 8-24
Disabling ASMM 8-25
Manually Resizing Dynamic SGA Parameters 8-26
Program Global Area (PGA) 8-27
Automatic PGA Memory Management 8-29
PGA Management Resources 8-30
Using the Memory Advisor to Size the SGA 8-31
Using the Memory Advisor to Size the PGA 8-32
Efficient Memory Usage: Guidelines 8-33
Memory Tuning Guidelines for the Library Cache 8-35
Summary 8-37
Practice Overview: Use ASMM to Correct a Memory Allocation Problem 8-38

9 Automatic Performance Management
Objectives 9-2
Tuning Activities 9-3
Performance Planning 9-4
Instance Tuning 9-6
Performance Tuning Methodology 9-7
Statistics Collection 9-8
Oracle Wait Events 9-10
System Statistics 9-11
Displaying Session-Related Statistics 9-13
Displaying Service-Related Statistics 9-14
Troubleshooting and Tuning Views 9-15
Dictionary Views 9-16
Diagnosis of Hung or Extremely Slow Databases 9-17
Using Memory Access Mode 9-18
Using the Hang Analysis Page 9-19
Automatic Workload Repository 9-21
AWR Snapshot Baselines 9-23
Advisory Framework: Overview 9-24
Database Control and Advisors 9-26
Typical Advisor Tuning Session 9-27
Manually Invoking ADDM 9-28
Using the SQL Tuning Advisor: Review 9-29
SQL Access Advisor: Overview 9-30
Typical SQL Access Advisor Session 9-31
Workload Source 9-32
Recommendation Options 9-33
Reviewing Recommendations 9-35
Asynchronous COMMIT 9-36
Using Asynchronous COMMIT 9-37
Summary 9-38
Practice Overview: Use ADDM to Diagnose Performance Problems 9-39

10 Managing Schema Objects
Objectives 10-2
Table Types 10-3
What Is a Partition and Why Use It? 10-4
Partitions 10-5
Creating a Partition 10-6
Partitioning Methods 10-7
Partition Maintenance 10-8
Index-Organized Tables 10-9
Index-Organized Tables and Heap Tables 10-10
Creating Index-Organized Tables 10-12
Clusters 10-13
Cluster Types 10-14
Situations Where Clusters Are Useful 10-16
Sorted Hash Cluster: Overview 10-17
Sorted Hash Cluster: Example 10-18
Sorted Hash Cluster: Basic Architecture 10-19
Schema Management Tasks 10-20
Estimating Resource Usage 10-21
Analyzing Growth Trends 10-22
Managing Optimizer Statistics 10-23
Reorganizing Schema Objects Online 10-24
Reorganizing Objects: Impact Report 10-26
Reorganizing Objects: Review 10-27
Basic Steps for Manual Online Reorganization 10-28
Summary 10-29
Practice Overview: Managing Schema Objects 10-30

11 Managing Storage
Objectives 11-2
Space Management: Overview 11-3
Free Space Management 11-4
Types of Segments 11-5
Allocating Extents 11-6
Block Space Management 11-7
Row Chaining and Migration 11-8
Proactive Tablespace Monitoring 11-9
Thresholds and Resolving Space Problems 11-10
Monitoring Tablespace Space Usage 11-11
Shrinking Segments 11-12
Results of Shrink Operation 11-13
Space Reclamation with ASSM 11-14
Segment Advisor: Overview 11-15
Segment Advisor 11-16
Implementing Recommendations 11-18
Database Control and Segment Shrink 11-19
Shrinking Segments by Using SQL 11-20
Managing Resumable Space Allocation 11-21
Using Resumable Space Allocation 11-22
Resuming Suspended Statements 11-24
Transporting Tablespaces 11-26
Concept: Minimum Compatibility Level 11-27
Transportable Tablespace Procedure 11-28
Determining the Endian Format of a Platform 11-29
Transporting Databases 11-30
Database Transportation Procedure: Source System Conversion 11-31
Database Transportation Procedure: Target System Conversion 11-32
Database Transportation: Considerations 11-33
Summary 11-34
Practice Overview: Managing Storage 11-35

12 Automatic Storage Management
Objectives 12-2
Automatic Storage Management: Review 12-3
ASM General Architecture 12-5
ASM Instance Tasks 12-7
Creating an ASM Instance 12-8
ASM Instance Initialization Parameters 12-9
Database Instance Parameter Changes 12-10
Starting Up an ASM Instance 12-11
Accessing an ASM Instance 12-12
ASM Home Page 12-14
ASM Performance Page 12-15
ASM Configuration Page 12-16
Shutting Down an ASM Instance 12-17
DBCA and Storage Options 12-18
ASM Storage: Concepts 12-19
ASM Disk Groups 12-20
Failure Group 12-21
Disk Group Mirroring 12-22
Disk Group Dynamic Rebalancing 12-23
Managing Disk Groups 12-24
ASM Administration Page 12-25
Create Disk Group Page 12-26
Creating and Dropping Disk Groups 12-27
Adding Disks to Disk Groups 12-28
Miscellaneous ALTER Commands 12-30
ASM Files 12-32
ASMCMD Utility 12-33
Migrating Your Database to ASM Storage 12-34
Summary 12-36
Practice Overview: Using Automatic Storage Management 12-37

13 Managing Resources
Objectives 13-2
Database Resource Manager: Overview 13-3
Database Resource Manager Concepts 13-4
Why Use Resource Manager 13-5
Accessing Resource Plans 13-7
Example: SYSTEM_PLAN 13-8
Creating a New Resource Plan 13-9
Creating Consumer Groups 13-10
Assigning Users to Consumer Groups 13-11
Specifying Resource Plan Directives 13-12
Resource Allocation Methods for Resource Plans 13-13
Comparison of EMPHASIS and RATIO 13-14
Active Session Pool Mechanism 13-16
Setting the Active Session Pool 13-17
Maximum Estimated Execution Time 13-18
Consumer Group Switching 13-19
Switching Back to the Initial Consumer Group at the End of Call 13-20
Setting Idle Timeouts 13-22
Resource Consumer Group Mapping 13-23
Activating a Resource Plan for an Instance 13-25
Database Resource Manager Information 13-26
Monitoring the Resource Manager 13-27
Summary 13-30
Practice Overview: Using the Resource Manager 13-31

14 Automating Tasks with the Scheduler
Objectives 14-2
Simplifying Management Tasks 14-3
A Simple Job 14-4
Key Components and Steps 14-5
1. Creating a Program 14-6
2. Creating and Using Schedules 14-7
3. Creating and Running a Job 14-8
4. Monitoring a Job 14-9
Using a Time-Based or Event-Based Schedule 14-10
Creating a Time-Based Job 14-11
Creating an Event-Based Schedule 14-13
Creating Event-Based Schedules with Enterprise Manager 14-14
Creating an Event-Based Job 14-15
Event-Based Scheduling 14-16
Creating Complex Schedules 14-18
Creating Job Chains 14-19
Example of a Chain 14-21
1. Creating a Chain Object 14-22
2. Defining Chain Steps 14-23
3. Defining Chain Rules 14-24
4. Starting the Chain 14-25
Monitoring Job Chains 14-26
Advanced Scheduler Concepts 14-27
Creating a Job Class 14-28
Creating a Window 14-29
Prioritizing Jobs Within a Window 14-30
Summary 14-31
Practice Overview: Automating Tasks with the Scheduler 14-32

15 Database Security
Objectives 15-2
Oracle Transparent Data Encryption (TDE): Overview 15-3
TDE Process 15-5
Implementing Transparent Data Encryption 15-6
Existing Tables and TDE 15-9
Transparent Data Encryption: Considerations 15-10
Wallet Support for Usernames and Passwords 15-11
Data Pump and Transparent Data Encryption 15-12
RMAN Encrypted Backups: Overview 15-13
Transparent Mode Setup 15-14
Password Mode Setup 15-15
Dual Mode Setup 15-16
RMAN-Encrypted Backups: Considerations 15-17
Need for Data Privacy 15-18
Definition and Usage of Terms 15-19
Virtual Private Database: Overview 15-20
Virtual Private Database: Features 15-21
Column-Level VPD: Example 15-22
Creating a Column-Level Policy 15-23
Summary 15-24
Practice Overview: Using Oracle Database Security 15-25

16 Using Globalization Support
Objectives 16-2
What Every DBA Needs to Know 16-3
What Is a Character Set? 16-4
Understanding Unicode 16-6
How Are Character Sets Used? 16-8
Problems to Avoid 16-9
Another Sample Problem 16-10
Choosing Your Character Set 16-11
Database Character Sets and National Character Sets 16-12
Obtaining Character Set Information 16-13
Specifying Language-Dependent Behavior 16-14
Specifying Language-Dependent Behavior for the Session 16-15
Language- and Territory-Dependent Parameters 16-16
Specifying Language-Dependent Behavior 16-18
Linguistic Searching and Sorting 16-19
Using Linguistic Searching and Sorting 16-21
Case- and Accent-Insensitive Search and Sort 16-23
Support in SQL and Functions 16-24
Linguistic Index Support 16-25
Customizing Linguistic Searching and Sorting 16-26
Implicit Conversion Between CLOB and NCLOB 16-27
NLS Data Conversion with Oracle Utilities 16-28
NLS Data Conversion with Data Pump 16-30
Globalization Support Features 16-31
Summary 16-32
Practice Overview: Using Globalization Support Features 16-33