دوره Oracle Workshop II 11g Backup and Recovery & New Feature 12C

Introduction to Recovery Manager

What is RMAN?
Basic Features and New Features
RMAN Introduction Complete!

RMAN Architecture

RMAN Components

Component Releases
The Control File
CFRKT Parameter
Control File Creation
Control File Size
NOCATALOG Mode
Recovery Catalog
Recovery Catalog Maintenance

RMAN Setup

RMAN Installation
User “RMAN”
Password File
Oracle Net
Catalog Tablespace – SYSAUX
Create Catalog
Register Database
RMAN Startup Options
The Flash Recovery Area

Executing RMAN Commands

RMAN Command Basics

Using SQL Statements from the RMAN Console
Common Job Commands
Common Commands

RMAN Channels

Channel Concepts
Manual Allocation
Parallel Backups
Automatic Allocation

Backup with RMAN

Backup Concepts
Backup Set Concepts
Backupset Pieces
Using RMAN to Backup ASM Files
Control File AUTOBACKUP
Full Backup
Deleting Archive Logs After Backup
BACKUP Syntax
Interpreting BACKUP Command Output
Full Tablespace Backup
Compressed Backup
Datafile Backup
Incremental Backup
Enabling Change Tracking
Cumulative Incremental
Incrementally Updated Backup
Using BACKUP for Image Copies
Duplexing
Backup Archive Logs
Retention Policies
Recovery Window
Redundancy
Overriding Retention Policy
Using the Duration Parameter

Restore & Recovery with RMAN

What Are We Protected Against?
Recovery-Related Commands
RESTORE Command
RESTORE PREVIEW
RECOVER Command
Recover Deleted Files
Recover Lost Tablespace
Restore to New Location
PIT Recovery
Control File Recovery
Recovering Through Incarnations

Database duplication

For Standby
To create another primary
Duplication from backup or from the active database

Database flashback and the FRA

The Fast Recovery Area
Flashback technologies
Database flashback architecture
Configuring database flashback
Using database flashback
Database flashback and resetlogs

Debugging RMAN

RMAN Messages
Capturing RMAN Logs
Reading RMAN Messages
Useful Views
V$PROCESS / V$SESSION
V$SESSION.CLIENT_INFO
V$SESSION_LONGOPS
V$SESSION_WAIT
Terminating Disk Jobs
RMAN Debug Mode
Media Manager Debugging

Scripting and Reporting

Scripting
Reporting
Reporting: LIST
Reporting: REPORT
Reporting: Views
Reporting: SHOW

RMAN Maintenance

Expired Backups
Cross-Checking Backups
Listing Expired Backups
Status of All Backups
Deleting Expired Backups
Obsolete Backups
Deleting Obsolete Backups
Retention Policy

Tuning RMAN

Getting Started
Oracle Benchmark
Performance Factors
Tuning Tools
Checking RMAN Progress
V$SESSION_WAIT
Parallelism
Parallelism Test
Sync vs. Async I/O
Enable Async IO to Tape
Sync vs. Async Test
V$SESSION.CLIENT_INFO
Tape Compression
Multiplexing
Slowing RMAN Down
Backup Optimization

Getting Started With Tapes

Media Management Concepts
Installing the MML
Backup to Tape
Environment Variables
Default Tape Channels
Configurable Tape Settings
Setting Default SBT Channels
Backup with Default Channels
Tape Restore
V$SESSION_WAIT
Terminating Tape Jobs
Media Manager Debugging

RMAN Case Studies

Configure the daatabase for recoverability in all circumstances
Diagnose problems
Use the Recovery Advisor
# 1 – Lost Control File
# 2 – Lost online or archive redolog file(s)
# 3 – Tuning
# 4 – Dropped Tablespace
# 5 – Damaged critical datafile
# 6 – Damaged non-critical datafile
# 7 – Dropped schema
# 8 – Combinations of all the above