In this course, the concepts and architecture that support backup and recovery, along with the steps of how to carry it out in various ways and situations, are covered in detail. This includes how to define and test your own backup and recovery scenarios.
Also, the students learn to manage memory effectively and to perform some performance evaluation and tuning tasks, including using some of the advisors. All types of flashback technologies, scheduling jobs inside and outside of the database, and controlling system resource usage are covered. Topics are reinforced with hands-on practices.
Learn To:
Back up and recover a database using RMAN and Enterprise Manager
Configure Oracle Database for optimal recovery for any environment
Identify burdensome database sessions and poorly performing SQL
Configure the database instance such that resources are allocated among sessions and tasks appropriately Schedule jobs to run inside or outside of the database
Skills Gained
Back up and recover a database
Configure Oracle Database for optimal recovery
Administer ASM disk groups
Use an RMAN backup to duplicate a database
Automating Tasks with the Scheduler
Who Can Benefit
Database Administrators
Support Engineer
Data Warehouse Administrator
Technical Consultant
Prerequisites
Oracle Database 11g: Administration Workshop I New
Code:
11g-DBA2
Length:
5 days
Type:
Instructor-Led
Certified By:
Oracle
Tuition:
$3,000
This course is taught by Certified Oracle instructors. There is a difference. Learn More
This course is in the following categories. Click the categories to find similar courses and topics of interest.
There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below. We can also contact you when the course is scheduled in your area.
Database Architecture and ASM
Oracle Database Architecture Overview
ASM General Architecture
Creating an ASM Instance
Using Enterprise Manager to Manage ASM Users
ASM Storage Concepts
The ASMCMD Utility
ASM Scalability and Performance
Configuring for Recoverability
Purpose of Backup and Recovery Functionality
Typical Backup and Recovery Tasks
Oracle Backup and Recovery Solutions
Using Recovery Manager (RMAN)
Using a Flash Recovery Area
Flash Recovery Area Space Management
Using the RMAN Recovery Catalog
RMAN Repository Data Storage: Comparison of Options
Storing Information in the Recovery Catalog
Registering a Database in the Recovery Catalog
Recovery Catalog Resynchronization: Concepts
Using RMAN Stored Scripts
Backing Up and Recovering the Recovery Catalog
Using a Virtual Private Catalog
Configuring Backup Specifications
Using RMAN to Create Backups
Configuring Persistent Settings for RMAN
Using Enterprise Manager to Configure RMAN Settings
Control File Auto-backups
Managing Persistent Settings
Configuring Devices for Backup
Configuring and Allocating Channels for Use in Backups
Configuring Backup Optimization
Creating Backups
Creating an Oracle-Suggested Backup
Creating Backup Sets & Image Copies
Creating a Whole Database Backup
RMAN Backup Types
Monitoring Block Change Tracking
Creating Duplex Backup Sets
Archival Backups: Concepts
Encrypting Backups
Performing User-Managed Backup and Recovery
Restoring and Recovering
Causes of File Loss
Critical Versus Non-critical
Recovering from a TEMPFILE Loss
Re-creating Indexes
Recovering from a Lost Index Tablespace
Authentication Methods for Database Administrators
Recovering a Read-Only Tablespace
Using RMAN to Perform Recovery
Using RMAN RESTORE and RECOVER Commands
Performing Recovery Using Enterprise Manager
Recovery Using Incrementally Updated Backups
Perform a Fast Switch to Image Copies
Restoring and Recovering the Database on a New Host
Performing Disaster Recovery
Using RMAN to Duplicate a Database
Using RMAN to Create a Duplicate Database
Creating a Duplicate Database
Creating an Initialization Parameter File for the Auxiliary Instance
Database Character Sets and National Character Sets
Language- and Territory-Dependent Parameters
Linguistic Searching and Sorting
Case- and Accent-Insensitive Search and Sort
NLS Data Conversion with Oracle Utilities
When you take a certified course with ExitCertified, you are learning from
the creators of the products you use. Our commitment to your IT
community, along with our authorization to deliver certified courses,
ensures you receive a premium training experience.
