کــد دوره:
مدرس دوره: مهندس امیر رستنده
مـدت دوره: 40 ساعت
شهریـه دوره:1,470,000 تومان
امتیاز ثبت نام: امتیاز
اشتراک گذاری:

شهریه مدرس دوره مـدت دوره تاریخ شروع کلاس ساعت برگزاری روزهای برگزاری ظرفیت لینک ثبت نام
1,470,000 تومان مهندس امیر رستنده 40 ساعت 99/4/26 13-17 پنج شنبه ها 10 ثبت نام

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