- Home /
- Shop All /
- Networking & Security /
- Databases & SQL /
- Oracle Database 12c: Backup and Recovery Workshop
Description
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 textbook is to assist you in doing just that, and this is one of the most essential modules in the entire Sideris 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.
Audience
The primary target audiences for this textbook are:
• Database administrators
• Web server administrators
• System administrators
• Implementation specialists
• Data center support engineers
• Senior application designers and developers
Prerequisites
Specific prerequisites for this textbook are the following Sideris 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
Suggested Next Textbook(s)
Readers may next wish to proceed onto these advanced textbook modules:
• ORACLE DATABASE 12C: MANAGE THE MULTITENANT ARCHITECTURE
• ORACLE DATABASE 12C: ADVANCED ADMINISTRATION & ASM
About This Series
This textbook is part of the Sideris Oracle Certified Professional (OCP) Advanced Administrator series, which in turn is one of the learning paths from the Sideris Oracle 12c administration training curriculum.
eTextbook Available
See the list of related textbook items for an eTextbook version of this textbook
Content Summary
• Volumes: 2
• Pages: 959
• Hands-on Workshops: 13
• Exercises: 77
Certification
This textbook 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".
Objectives
• 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.
• Backup & Recovery Facilities
• HA & MAA
• The Backup Administrator
• Backup Storage Technologies
• Manage Redo Data
• Manage Archived Redo Data
• About The Fast Recovery Area
• Recoverability Checklist
• About Instance Recovery
• Mean Time To Recover (MTTR)
• Instance Recovery Parallelism
• Mttr Advisor & Checkpoint Tuning
• Redo Logfile Size Advisor
• FAST-START ON-DEMAND Parallelism
• RMAN Architecture
• Launch & Use RMAN
• Configure RMAN Settings
• RMAN Channels
• 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
• 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
• 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 Concepts
• Recover Temporary Tablespaces
• Recover Read-Only Tablespaces
• Recover Index Tablespaces
• Recover Redo Log Group Member
• Recreate The Password File
• 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
• Backup Optimization
• Parallelism With Section Sizes
• Backup Performance & Control
• Minimize Time Vs. Minimize Load
• Archival Backups
Advanced: Database Duplication & Cloning
• Why Perform Database Duplication?
• RMAN Duplicate Operation
• RMAN Duplicate
• Database Cloning With Em
• About Transportation
• Read-Only TS Transportation
• Read-Write TS Transportation
• Cross-Platform TS Transportation
• Database Transportation
• EM Tablespace Transportation
• 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()
• About Flashback Technology
• Flashback & Database Security
• Configuration For Flashback
• FLASHBACK TABLE
• FLASHBACK DROP
• FLASHBACK TABLE...TO BEFORE DROP
• FLASHBACK DATABASE
SKU | 035215S |
---|---|
Weight | 5.1265 |
Coming Soon | No |
Days of Training | 4.0 |
Audience | Student |
Product Family | Partnerware |
Product Type | Print Courseware |
Electronic | Yes |
ISBN | No |
Language | English |
Page Count | 964 |
Curriculum Library | Oracle |
Year | No |
Manufacturer's Product Code | ora12c250-ver2 |
Current Revision | 1.0 |
---|---|
Revision Notes | No revision information available |
Original Publication Date | 2016-04-25 00:00:00 |