Oracle Database 11g: Backup & Recovery Courses and other IT courses from TEKsystems Education Services

Note: All fields are required

First Name:

Last Name:

Company:

Title:

Email Address:

Phone Number:

Address:

City:

State:

Zip Code:

Which Topic(s) Currently Interests Your Organization:

Tell Us More:

I have an immediate training or educational service need and I wish to be contacted today

I am a current TEKsystems Education Services client and wish to speak to someone

I have a training budget approved and I am ready to talk to someone about the details of my organization’s training need

I do not have an approved training budget, but I have a need and would like to talk to TEKsystems Education Services about their solutions

Unfortunately, I do not have a group training request

At the present time we do not offer training for individuals or groups less then 6 individuals. We apologize for any inconvenience.

My Delivery Method Needed Is:

Instructor-Led Classroom Training

Instructor-Led Virtual Training

Self-Paced Online Training

Code Number:

We Value Your Privacy!

Course Code:	RT 514
Course Abstract:	As the complexity and sophistication of the enterprise-wide database platform for an organization grows, so does the need for a state-of-the-art backup and recovery strategy. Recovery of contemporary databases goes far beyond the relatively limited tasks of years ago. Traditional strategies involved protecting data against failure, and in the event of a failure, recovering all the lost data. Today one needs to employ far more elaborate techniques. Regulatory compliance requirements call for data preservation through archival backups. Application testing and migration, among other scenarios, requires database duplication and cloning. Strategies to optimize and tune backup and recovery considering availability demands and large data volumes are also needed. And traditional problem-solving for data corruption, media failure, data loss and the like remain necessities. Certification Examination This course along with its prerequisites cover information necessary to complete the certification test Exam #1Z1-053 Oracle Database 11g: Administration II.
Audience:	This course is designed for individuals who are Oracle database administrators who will be specialists in backup and recovery duties. Oracle web server and application server administrators, as well as others who must manage an embedded repository database using Oracle database technology will also find this information useful. This course is also recommended for technical consultants, support engineers, project managers and other technical management and support personnel.
Duration:	5 days
Learning Outcomes:	Upon completion of this course, the participant will be able to: > Use Oracle flashback technology to recover from user errors and from database failures, including flashback data archive and flashback transaction backout along with the Total Recall capability. > Use advanced Enterprise Manager wizards and tools, including the integrated LogMiner, Flasback Transaction Backout wizard, database Recovery Wizard, Recovery Advisor interface, and others. > Database instance recovery, tuning checkpoints, the Redo Log File Size Advisor and the MTTR Advisor. > User-managed recovery scenarios, including recovery from temporary, read-only and index tablespaces. > Automatically managed backup strategies and database recovery operations using RMAN and other database facilities. Complete and incomplete media recovery, including database point-in-time recovery and tablespace point-in-time recovery. > Build upon basic RMAN capabilities with a centralized recovery catalog. Deploy standardized and consistent backup and recovery procedures throughout the enterprise by means of dynamic stored scripts and variable substitution. > Optimizing backups for faster performance and parallelization of operations, employing compression algorithms and other strategies for efficiency. > Data preservation through archival backups. > Security through transparent and explicit encryption features. > Duplicate databases for regulatory compliance, Real Application Testing database replay, test configuration and other purposes. > Detect and handle failures and corruption, including the use of RMAN block recovery and the Data Recovery Advisor. This course book applies to any operating system supported by the Oracle database. In particular, the examples and notations within this course are based on the Linux/UNIX and MS Windows environments.
Course Topics:	Recovery Concepts About the Backup & Recovery Structures Managing Redo Data Managing Archived Redo Data Creating a Foundation for Sound Recovery Oracle Flashback Technology About Flashback Technology Flashback Query SELECT...as of Timestamp SELECT...as of SCN Configuring Undo Management for Flashback UNDO_RETENTION Flashback Table Flashback Drop Flashback Versions Query Flashback Transaction Query Flashback Transaction Backout Flashback Database About Flashback Database Configuring the Flash Recovery Area Performing Database Flashback Monitoring Flashback Performance Flashback Database Considerations Configure Flashback Data Archive Instance Recovery About Instance Recovery Instance Recovery Parallelism MTTR Advisor & Tuning Checkpoints LOG_CHECKPOINTS_TO_ALERT Redo Logfile Size Advisor Fast-Start On-Demand Parallelism Configuring RMAN RMAN Architecture Launch & Use RMAN Configure RMAN Settings Allocate RMAN Channels Backup with RMAN About Backup File Types Performing Full Backups Performing Incremental Backups Establishing a Backup Retention Policy Generate Reports Report Unrecoverable Report Need Backup List Incarnation RMAN Management with EM Monitoring the Flash Recovery Area The EM Interface to RMAN Scheduling RMAN Backups Using the Oracle-Suggested Backup Strategy Manage Current Backups Backup Reports Manage Restore Points User-Managed Recovery Operations Recovery Concepts Recover Temporary Tablespaces Recover Read-Only Tablespaces Recover Index Tablespaces Recover Redo Log Group Member Recreate the Password File Recovery with RMAN Complete Media Recovery Incomplete Media Recovery Recovery Using EM Using the RMAN Recovery Catalog Understanding Catalog Concepts Create the Recovery Catalog Manage Virtual Private Catalogs Data Protection of the Recovery Catalog Using RMAN Scripts Database Duplication & Cloning Why Perform Database Duplication? RMAN Duplicate Database RMAN Duplicate Database Cloning Advanced RMAN Capabilities Backup Optimization Enhancing Parallelism with Section Sizes Archival Backups Backup Set Encryption Copying Files between Databases Transporting Tablespaces About Tablespace Transportation Read-Only Tablespace Transportation Read-Write Tablespace Transportation Transport Tablespaces Using EM Recovering from Corruption with Data Recovery Advisor How Does Corruption Occur? Detecting Corruption Analyze V$DATABASE_BLOCK_CORRUPTION View DB_BLOCK_CHECKING DB_BLOCK_CHECKSUM DB_LOST_WRITE_PROTECT DB_ULTRA_SAFE Recovery Using The Data Recovery Advisor Block Media Recovery Isolating Corruption With DBMS_REPAIR ()
Prerequisites:	Many participants taking this course have familiarity with system administration and administration of other non-Oracle databases, and this is helpful though not mandatory.

Oracle Database 11g: Backup & Recovery Course

Hot Courses

Top Skills

Testimonials

Agile
AJAX and Web 2.0
Business Analysis
Business Practices
Cisco
Communications
Customer Service/Communications
Data Warehousing
Database Developer
End User
Enterprise Architecture
Internet Application Developer
Lotus
Mainframe
Messaging Infrastructure
Networking
Operating Systems
Programming Languages
Programming Methodologies
Project Management
Project Management
Quality Assurance
Relational Databases
Reporting Tools
SAP
Scrum Master
Security
Server Applications
SQL & PL/SQL Programming
Testing
Testing and Quality Assurance
Virtualization
Web Technologies
Wireless Technology