Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Self-Paced Learning    |    Online Training     


Contact Us   -   Why Choose Wintrac   -   Clients    

Courses
ADA
Adobe
Agile
AJAX
Android
Apache
AutoCAD
Big Data
Business Analysis
Business Intelligence
Business Objects
Business Skills
C++ programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
CRM
Crystal Reports
Datawarehousing
DB2
Desktop Application Software
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Lotus
Machine learning/AI
Macintosh
Mainframe programming
Microsoft technologies
Mobile
MultiMedia and design
.NET
NetApp
Networking
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PowerBuilder
Professional Soft Skills Workshops
Project Management
Rational
Ruby
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software quality and tools
SQL Server
Sybase
Symantec
Telecommunications
Teradata
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
Oracle Database 12c Backup & Recovery Workshop
Oracle Training Overview

All of the data within a database installation is at risk unless one has designed, tested and implemented a robust backup and recovery strategy. The objective of this training course is to assist you in doing just that, and this is one of the most essential modules in the entire Oracle 12c database administrator curriculum.

Among the tools and facilities that you will learn to use are the Oracle Recovery Manager (RMAN), the Enterprise Manager 12c Cloud Control, the Data Recovery Advisor, Oracle Flashback technologies, Redo Log File Size Advisor and the MTTR Advisor. Since it can be tempting to short-cut appropriate backup procedures if these perform poorly, special attention is given to backup performance and optimization.


Oracle Training Course Objectives

The objectives for this course are as follows:
  • Automatically managed backup strategies and database recovery operations using RMAN, the Enterprise Manager Cloud Control, and other database facilities.
  • 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.
  • Complete and incomplete media recovery, including database point-in-time, tablespace and table point-in-time recovery.
  • Configure 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 optimum efficiency.
  • Achieve data preservation through archival backups.
  • Duplicate and clone databases for regulatory compliance, Real Application Testing database replay, test configuration and other purposes.
  • Tablespace transportation, database transportation, cross-platform transportation and endian format conversion.
  • Detect and handle failures and corruption, including the use of RMAN block recovery and the Data Recovery Advisor.
  • Newly released or enhanced features such as backup file compression, encryption, parallelization and others.
  • Recovering from logical failure using appropriate Oracle Flashback technologies, such as Flashback Table, Flashback Drop and Flashback Database.
Oracle Training Audience

The primary target audiences for this course are:
  • Database administrators
  • Web server administrators
  • System administrators
  • Implementation specialists
  • Data center support engineers
  • Senior application designers and developers
Prerequisites

Specific prerequisites for this course are the following titles, or equivalent experience:
  • ORACLE DATABASE 12C: SQL FUNDAMENTALS (LEVELS I & II)
  • ORACLE DATABASE 12C: INSTALL & UPGRADE WORKSHOP
  • ORACLE DATABASE 12C: ARCHITECTURE & INTERNALS
  • ORACLE DATABASE 12C: ADMINISTRATION WORKSHOP
Certification Examination

This course is applicable to certification training as an Oracle Database 12c Administrator Certified Professional (OCP) for "Exam 1Z1-063 Oracle Database 12c: Advanced Administration" and certification training as an Oracle Certified Implementation Specialist for "Exam 1Z0-497 Oracle Database 12c: Essentials".

Suggested Next Course

Administrators may wish to proceed onto more focused and specialized courses with these modules:
  • ORACLE DATABASE 12C: MANAGE THE MULTITENANT ARCHITECTURE
  • ORACLE DATABASE 12C: ADVANCED ADMINISTRATION & ASM
Oracle Training Course duration

5 Days

Oracle Training Course outline

GETTING STARTED: ABOUT DATABASE FAILURE & RECOVERY
  • BACKUP & RECOVERY FACILITIES
  • THE BACKUP ADMINISTRATOR
  • BACKUP STORAGE TECHNOLOGIES
GETTING STARTED: CONFIGURE THE DATABASE FOR RECOVERY
  • MANAGE REDO DATA
  • MANAGE ARCHIVED REDO DATA
  • ABOUT THE FAST RECOVERY AREA
  • RECOVERABILITY CHECKLISTOracle Database 12c: Backup & Recovery Workshop
GETTING STARTED: AUTOMATIC INSTANCE RECOVERY
  • ABOUT INSTANCE RECOVERY
  • MEAN TIME TO RECOVER (MTTR)
  • INSTANCE RECOVERY PARALLELISM
  • MTTR ADVISOR & CHECKPOINT TUNING
  • REDO LOGFILE SIZE ADVISOR
  • FAST-START ON-DEMAND PARALLELISM
BACKUP: CONFIGURE RMAN
  • RMAN ARCHITECTURE
  • LAUNCH & USE RMAN
  • CONFIGURE RMAN SETTINGS
  • RMAN CHANNELS
BACKUP: PERFORM RMAN BACKUPS
  • CONSISTENT VS. INCONSISTENT BACKUPS
  • BACKUP FILE TYPES
  • RMAN Backup Sets
  • RMAN Image Copies
  • FULL BACKUPS
  • INCREMENTAL BACKUPS
  • RETENTION POLICIES & OBSOLETE FILES
  • EXPIRED BACKUP ENTRIES
  • RMAN BACKUP REPORTS
  • REPORT UNRECOVERABLE
  • REPORT NEED BACKUP
  • LIST INCARNATION
BACKUP: RMAN MANAGEMENT WITH EM
  • MONITORING THE FAST RECOVERY AREA
  • THE EM INTERFACE TO RMAN BACKUP
  • ABOUT BACKUP GUIDED WORKFLOWS
  • SCHEDULE CUSTOMIZED BACKUP
  • SCHEDULE ORACLE-SUGGESTED BACKUP
  • MANAGE CURRENT BACKUPS
  • BACKUP REPORTS
  • RESTORE POINTS
  • BACKUP ENCRYPTION
THE RMAN RECOVERY CATALOG
  • RMAN CATALOG CONCEPTS
  • CREATE THE BASE CATALOG
  • REGISTER A TARGET DATABASE
  • MANAGE THE CENTRALIZED CATALOG
  • VIRTUAL PRIVATE CATALOGS
  • PROTECTION OF THE RECOVERY CATALOG
  • USING RMAN SCRIPTS
RECOVERY: USER-MANAGED RECOVERY
  • RECOVERY CONCEPTS
  • RECOVER TEMPORARY TABLESPACES
  • RECOVER READ-ONLY TABLESPACES
  • RECOVER INDEX TABLESPACES
  • RECOVER REDO LOG GROUP MEMBER
  • RECREATE THE PASSWORD FILE
RECOVERY: RMAN RECOVERY
  • COMPLETE RECOVERY
  • PARTIAL BUT COMPLETE RECOVERY
  • RMAN Failure Diagnosis
  • INCOMPLETE RECOVERY
  • RECOVERY USING EM
  • EM USER DIRECTED RECOVERY
  • EM ORACLE ADVISED RECOVERY
  • DECRYPTION DURING RESTORE
ADVANCED: ENHANCED RMAN CAPABILITIES
  • BACKUP OPTIMIZATION
  • PARALLELISM WITH SECTION SIZES
  • BACKUP PERFORMANCE & CONTROLOracle Database 12c: Backup & Recovery Workshop
  • MINIMIZE TIME vs. MINIMIZE LOAD
  • ARCHIVAL BACKUPS
ADVANCED: DATABASE DUPLICATION & CLONING
  • WHY PERFORM DATABASE DUPLICATION?
  • RMAN DUPLICATE OPERATION
  • RMAN DUPLICATE
  • DATABASE CLONING WITH EM
ADVANCED: DATA TRANSPORTATION
  • ABOUT TRANSPORTATION
  • READ-ONLY TS TRANSPORTATION
  • READ-WRITE TS TRANSPORTATION
  • CROSS-PLATFORM TS TRANSPORTATION
  • DATABASE TRANSPORTATION
  • EM TABLESPACE TRANSPORTATION
ADVANCED: HANDLING CORRUPTION WITH DATA RECOVERY ADVISOR
  • UNDERSTANDING FAILURE & CORRUPTION
  • HOW DOES CORRUPTION OCCUR?
  • DETECTING CORRUPTION
  • ANALYZE
  • DB_BLOCK_CHECKING
  • DB_BLOCK_CHECKSUM
  • DB_LOST_WRITE_PROTECT
  • DB_ULTRA_SAFE
  • RECOVERING FROM CORRUPTION
  • BLOCK MEDIA RECOVERY
  • ISOLATING CORRUPTION
  • DBMS_REPAIR() Units
  • About ADMIN_TABLES()
  • About CHECK_OBJECT()
  • About FIX_CORRUPT_BLOCKS()
  • About SKIP_CORRUPT_BLOCKS()
  • About DUMP_ORPHAN_KEYS()
  • About SEGMENT_FIX_STATUS()
FLASHBACK: ABOUT ORACLE FLASHBACK TECHNOLOGY
  • ABOUT FLASHBACK TECHNOLOGY
  • FLASHBACK & DATABASE SECURITY
  • CONFIGURATION FOR FLASHBACK
FLASHBACK: RECOVERY USING ORACLE FLASHBACK TECHNOLOGY
  • FLASHBACK TABLE
  • FLASHBACK DROP
  • FLASHBACK TABLE...TO BEFORE DROP
  • FLASHBACK DATABASE

 
About us
Contact us
Careers at Wintrac
Our Clients
Why Wintrac


Register for a free training CD-ROM drawing
Refer a client or instructor and earn $$$


Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
 
Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy