Oracle 12c Backup & Recovery Exam 1Z0-063 Prep Course

Share this page:

Exam Details

Exam Title:	Oracle Database 12c: Advanced Administration
Exam Number:	1Z0-063
Exam Price:	₹10,265.00 More on exam pricing
Format:	Multiple Choice

Duration:	120
Number of Questions:	80
Passing Score:	60%
Validated Against:	This exam has been validated against Oracle Database 12.1.0.1.0.

Overview

This Oracle Database 12c: Backup and Recovery expanded course demonstrates the evaluation of recovery requirements. The course explains to develop backup, restore and recovery strategies along with the procedures for the same. The course trains the participants about identifying and repairing data failures and secures the database availability for apt backup and recovery scenarios.

Course Prerequisites

Good knowledge of Oracle Database 12c Administration

Course Content / Exam(s)

1. Introduction

Curriculum Context
Suggested Schedule
Oracle Database Innovation
Enterprise Cloud Computing
Assessing Your Recovery Requirements
Categories of Failure
Data Failures
Oracle Data Protection Solutions
Assisting with Overview and Advice
Complete Oracle Backup Solution
Integrated Oracle Recovery Manager (RMAN)
Oracle Secure Backup
Oracle Secure Backup Cloud Module
Oracle Data Guard: Overview
Physical Standby Database: Redo Apply Architecture
Oracle Active Data Guard
Logical Standby Database: SQL Apply Architecture
Oracle Maximum Availability Architecture: Robust and Integrated Data
Protection
Basic Workshop Architecture

2. Getting Started

Naming the Core Components of an Oracle Database Server
Oracle Database Server Architecture: Overview
What You Already Know About Database Storage Architecture
Naming Logical and Physical Database Structures
What You Already Know About Process Architecture
Process Structures
Reviewing Processes
Reviewing Database Writer Process (DBWn)
Reviewing Log Writer Process (LGWR)
Reviewing Checkpoint Process (CKPT)
Reviewing System Monitor Process (SMON)
Reviewing Process Monitor (PMON)
Reviewing Archiver Processes (ARCn)
Adding Process Names
Database Log Mode
ORCL Database in ASM
Facilitating Database Management with Oracle Restart
Oracle DBA Tools
Separation of DBA Duties
Connecting to RMAN and a Target Database
Using SQL in RMAN
Quick Start: A Problem-Solution Approach
Performing Restore and Recovery of a Database in NOARCHIVELOG Mode

3. Configuring for Recoverability

Types of RMAN Commands
Job Commands: Example
Configuring Persistent Settings for RMAN
Viewing Persistent Settings
Managing Persistent Settings
Specifying a Retention Policy
Recovery Window Retention Policy: Example
Using a Fast Recovery Area
Configuring the Fast Recovery Area
Sizing the Fast Recovery Area
Fast Recovery Area Space Management
Multiplexing Control Files
Control File Autobackups
Best Practice: Multiplexing Redo Log Files
Multiplexing the Redo Log
Creating Archived Redo Log Files
Configuring ARCHIVELOG Mode

4. Using the RMAN Recovery Catalog

RMAN Repository Data Storage: Comparison of Options
Storing Information in the Recovery Catalog
Reasons to Use a Recovery Catalog
Creating the Recovery Catalog: Three Steps
Configuring the Recovery Catalog Database
Creating the Recovery Catalog Owner
Creating the Recovery Catalog
Managing Target Database Records in the Recovery Catalog
Registering a Database in the Recovery Catalog
Unregistering a Target Database from the Recovery Catalog
Recovery Catalog Resynchronization: Concepts
Manually Resynchronizing the Recovery Catalog
Using RMAN Stored Scripts
Executing RMAN Stored Scripts
Maintaining RMAN Stored Scripts
Backing Up the Recovery Catalog
Creating and Using Virtual Private Catalogs
Creating a Virtual Private Catalog (12.1.0.1)
Managing Virtual Private Catalogs
Creating a Virtual Private Catalog (12.1.0.2)
Upgrading Virtual Private Catalogs for 12.1.0.2

5. Backup Strategies and Terminology

Backup Solutions: Overview
Backup Terminology
Balancing Backup and Restore Requirements
Comparing Backup Strategies
Option 1: Full and Incremental Backups
Option 2: Incrementally Updated Disk Backups
Option 3: Offloading Backups to Physical Standby Database in Data Guard
Environment
Backing Up Read-Only Tablespaces
Data Warehouse Backup and Recovery: Best Practices
Additional Backup Terminology
Creating Backup Sets
Creating Image Copies
Creating a Whole Database Backup
Case Study 1: How to Protect an OLTP Database
Case Study 2: How to Protect a DSS Database
Case Study 3: How to Protect the Recovery Catalog Database

6. Performing Backups

RMAN Backup Types
Incrementally Updated Backups
Incrementally Updated Backups: Example
Fast Incremental Backup
Maintaining Block Change Tracking File
Monitoring Block Change Tracking
Automatic Disk-to-Disk Backup and Recovery
Oracle-Suggested Backup
Reporting on Backups
Using Dynamic Views
Managing Backups: Cross-Checking and Deleting

7. Improving Your Backups

Saving Backup Space with Unused Block Compression
Compressing Backups
Using RMAN Backup Compression
Using a Media Manager
Configuring Backup and Restore for Very Large Files
Backing Up and Restoring Very Large Files
Creating RMAN Multisection Backups
Creating Proxy Copies
Creating Duplexed Backup Sets by Using BACKUP COPIES
Creating Backups of Backup Sets
Archival Backups: Concepts
Creating Archival Backups with RMAN
Managing Archival Database Backups
Backing Up Recovery Files
Backing Up the Control File to a Trace File
Cataloging Additional Backup Files
Backing Up ASM Disk Group Metadata

8. Using RMAN-Encrypted Backups

9. Diagnosing Failures

Reducing Problem Diagnosis Time
Automatic Diagnostic Workflow
Automatic Diagnostic Repository
ADR Command-Line Tool (ADRCI)
V$DIAG_INFO View
Interpreting RMAN Message Output
DEBUG Option
Interpreting RMAN Error Stacks
Data Recovery Advisor
Data Failure: Examples
Data Recovery Advisor RMAN Command-Line Interface
Listing Data Failures
Advising on Repair
Executing Repairs
Classifying (and Closing) Failures
Data Recovery Advisor Views
What Is Block Corruption?
Block Corruption Symptoms: ORA-01578
How to Handle Corruption
Setting Parameters to Detect Corruption
Block Media Recovery
Prerequisites for Block Media Recovery
Recovering Individual Blocks
Best Practice: Proactive Checks
Checking for Block Corruption
Automatic Block Repair: Primary Database
Automatic Block Repair: Physical Standby Database

10. Restore and Recovery Concepts

Understanding File Loss
Data Repair Techniques
Restoring and Recovering
Using RMAN RESTORE and RECOVER Commands
Instance Failure
Understanding Instance Recovery
Phases of Instance Recovery
Tuning Instance Recovery
Using the MTTR Advisor
Media Failure
Comparing Complete and Incomplete Recovery
Complete Recovery Process
Point-in-Time Recovery Process
Recovery with RESETLOGS Option
Case Study 1
Case Study 2
Case Study 3

11. Performing Recovery I

Ensuring Backups Are Available
Restoring in NOARCHIVELOG Mode
Recovery with Incremental Backups in NOARCHIVELOG Mode
Performing Complete Recovery
Restoring ASM Disk Groups
Restoring ASM Disk Groups: Examples
What You Already Know About Recovering Image Copies
Recovering Image Copies: Example
Performing a Fast Switch to Image Copies
Using SET NEWNAME for Switching Files
Using Restore Points
Performing Point-in-Time Recovery

12. Performing Recovery II

Recovery from Loss of Server Parameter File
Restoring the Server Parameter File from the Control File Autobackup
Loss of a Control File
Recovering from the Loss of All Control File Copies: Overview
Restoring the Control File from Autobackup
Restoring the SPFILE and the Control File
Recovering NOLOGGING Database Objects
Loss of a Redo Log File
Log Group Status: Review
Recovering from the Loss of a Redo Log Group
Clearing a Log File
Re-creating a Password Authentication File
Recovering from a Lost Index Tablespace
Recovering a Read-Only Tablespace
Automatic Tempfile Recovery
Restoring and Recovering the Database on a New Host
Preparing to Restore the Database to a New Host
Restoring the Database to a New Host
Performing Disaster Recovery
Restoring Encrypted Backups

13. RMAN and Oracle Secure Backup

Oracle Secure Backup: Overview
Oracle Secure Backup Interface Options
Managing Data to Be Protected
Backup Pieces and Backup Images
RMAN and Oracle Secure Backup: Overview
RMAN and Oracle Secure Backup Basic Process Flow
Starting with Oracle Secure Backup
Performing Installation Tasks
Verifying Your Installation
Securing Data and Access to the Backup Domain
Preauthorization
Defining Retention for RMAN Backups
Media Management Expiration Policies for Automated Tape Recycling
Database Backup Storage Selector
Setting Media Management Parameters in RMAN
of OSB Configuration for RMAN
Backing Up the Fast Recovery Area to Tape
Oracle Secure Backup Jobs
Displaying Log Files and Transcripts
Common obtool Commands

14. Using Flashback Technologies

Flashback Technologies Error Detection and Correction
What You Already Know About Transactions and Undo
Flashback Technology
Preparing Your Database for Flashback
Guaranteeing Undo Retention
Using Flashback Technology to Query Data
Flashback Query
Flashback Version Query
Flashback Table: Overview
Flashback Table
Flashback Table: Considerations
Flashback Transaction Query
Flashback Transaction Query: Considerations
Flashback Transaction Backout
Flashing Back a Transaction
Best Practices: Undo-based Flashback Flashback Query, Flashback Table
Flashback Drop and the Recycle Bin
Recycle Bin
Bypassing the Recycle Bin
Using Flashback Data Archives
Creating a Temporal History and Enabling Archiving
How the Flashback Data Archive Works
Collecting User Context in Temporal History
Transparent Schema Evolution
Full Schema Evolution
Temporal Validity and History
Using the PERIOD FOR Clause
Filtering on Valid-Time Columns: Example 1
Filtering on Valid-Time Columns: Example 2
Using DBMS_FLASHBACK_ARCHIVE

15. Flashback Database

Flashback Database: Continuous Data Protection
Flashback Database
Flashback Database Architecture
Configuring Flashback Database
Flashback Database: Examples
Flashback Database Considerations
Monitoring Flashback Database Information
Guaranteed Restore Points
Flashback Database and Guaranteed Restore Points
Best Practices: Flashback Database

16. Transporting Data

Transporting Data Across Platforms
Transporting Data with Minimum Down Time
Transporting a Tablespace with Image Copies
Determining the Endian Format of a Platform
Using the RMAN CONVERT Command
Transporting Data with Backup Sets
Process Steps: 1
Process Steps: 2
Database Transport: Using Data Files
Database Transportation Procedure
Database Transportation: Conversion
Database Transportation: Example 1
Database Transportation: Example 2
Database Transportation: Considerations
Database Transport with Backup Sets: 1
Database Transport with Backup Sets: 2
Transporting Inconsistent Tablespaces

17. Performing Point-in-Time Recovery

Point-in-Time Recovery
When to Use TSPITR
PITR Terminology
Tablespace Point-in-Time Recovery: Architecture
Preparing for PITR
Determining the Correct Target Time
Determining the Tablespaces for the Recovery Set
Identifying Objects That Will Be Lost
Performing RMAN TSPITR
Performing Fully Automated TSPITR
Improving TSPITR Performance
Performing RMAN TSPITR with an RMAN-Managed Auxiliary Instance
Performing RMAN TSPITR by Using Your Own Auxiliary Instance
Troubleshooting RMAN TSPITR
Recovering Tables from Backups
Table Recovery: Graphical Overview
Prerequisites and Limitations
Specifying the Recovery Point in Time
Process Steps of Table Recovery: 1
Process Steps of Table Recovery: 2

18. Duplicating a Database

Using a Duplicate Database
Choosing Database Duplication Techniques
Duplicating an Active Database with “Push”
“Push” Versus “Pull” Methods of Duplication
Duplicating a Database with a Target Connection
Duplicating a Database with Recovery Catalog Without Target Connection
Duplicating a Database Without Recovery Catalog or Target Connection
Creating a Backup-Based Duplicate Database
Creating an Initialization Parameter File for the Auxiliary Instance
Specifying New Names for Your Destination
Using the SET NEWNAME Clauses
Substitution Variables for SET NEWNAME
Specifying Parameters for File Naming
Starting the Instance in NOMOUNT Mode
Ensuring That Backups and Archived Redo Log Files Are Available
Allocating Auxiliary Channels
Understanding the RMAN Duplication Operation
Specifying Options for the DUPLICATE Command
Using Additional DUPLICATE Command Options
Substitution Variables for SET NEWNAME

19. RMAN Troubleshooting and Tuning

Interpreting RMAN Message Output
Using the DEBUG Option
Interpreting RMAN Error Stacks
Processing an RMAN Command
Troubleshooting with RMAN
Is There a Problem?
Diagnosing Performance Bottlenecks
Diagnosing Performance Bottlenecks: Read Phase
Is There a “Write” Problem?
Diagnosing Performance Bottlenecks: Write or Copy Phase
Using Dynamic Views to Diagnose RMAN Performance
Monitoring RMAN Job Progress
Identifying Backup and Restore Bottlenecks
Asynchronous I/O Bottlenecks
Synchronous I/O Bottlenecks
Tuning RMAN Backup Performance
Parallelization of Backup Sets
Setting LARGE_POOL_SIZE
RMAN Multiplexing

20. Workshop Overview

Workshop Structure and Approach
Business Requirements for the Workshop Database
Diagnosing the Failures

21. Oracle Database Cloud Service: Overview

Database as a Service Architecture
Database as a Service: Features and Tooling
Cloud Tooling for Database as a Service
Software Editions: Included Database Options and Management Packs
Accessing the Oracle Database Cloud Service Console
Automated Database Provisioning
Accessing Tools from the Service Console
Managing the Compute Node Associated With a Database Deployment
Managing Network Access to Database as a Service
Enabling Access to a Compute Node Port
Scaling a Database Deployment
Backing Up and Recovering Databases on Database as a Service
Backup Configuration Choices
Backup Configuration
Creating an On-Demand Backup
Customizing the Backup Configuration: Single-Instance Databases
Performing Recovery by Using the Service Console
Restoring and Recovering: Single-Instance Databases

Schedule for Oracle Database 12C: Backup and Recovery (Oracle Training in Nagpur, Pune And Bangalore)
Course Contents	Exam #	Regular Track (days)	Fast Track (days)
Oracle Database 12C: Backup and Recovery	1Z0-063	90	10
Balance Days for arrival, exam(s) and practice		10	5
Total duration		100	15