advertisement

11g New Features and Enhancements for Backup and Recovery

60 %
40 %
advertisement
Information about 11g New Features and Enhancements for Backup and Recovery
Technology

Published on February 28, 2014

Author: FranciscoMunozAlvarez

Source: slideshare.net

Description

Presentation about Backup and Recovery in 11g
advertisement

By Francisco Munoz Alvarez Oracle 11G New Functionalities for DBAs

OK,are you from?

Born here Grow up here Got Married Here Mature here Now Living here

ORACLE 11G IMPROVEMENTS

STREAMS 30%-50% Faster RAC 70% Faster Optimizer Stats Collection 10X Faster More Details More Improvements Query Results Caching 25% Faster

Table Scans 2.5 X Faster using Advance Compression Need More? More Improvements Oracle Secure Files 5X Faster than normal filesystems.

“it enables read-only access to a physical standby database for queries, sorting, reporting, webbased access, while continuously keep applying all changes received from the primary database.” ACTIVE DATA GUARD 11G NEW FUNCTIONALITIES

“Compresses any type of data (structured and unstructured data), as well as network traffic, memory utilization and inclusive the amount of data in the process of being backed up” ADVANCED COMPRESSION 11G NEW FUNCTIONALITIES

• • • • • • OLTP compression – It allows structured and unstructured data to be compressed on INSERT, UPDATE and DELETE operations. RMAN Backup Compression - Compress RMAN backups. Datapump export compression - Compress datapump export files. SecureFiles Deduplication - Detect and eliminate duplicate copies of files stored within the database. SecureFiles Compression - Compress unstructured file data within the database. Network Traffic Compression - Compress Data Guard redo data as it is sent over the network. Compressions Available 11G NEW FUNCTIONALITIES

OLTP Compression When Loading Data

OLTP Compression When Reading

OLTP Compression When Inserting (Part II)

ADVANCED COMPRESSION 11G NEW FUNCTIONALITIES

“allows businesses to quickly adopt new technologies while eliminating the risks associated with any change “ “it combines a workload capture and replay feature with an SQL performance analyser to help you to test the changes against real-life workloads, then it will help you to fine-tune them before putting them into production” RAT Real Application Testing

“ Indexes that are ignored by the optimizer. Handy for testing without dropping “ INVISIBLE INDEXES 11G NEW FUNCTIONALITIES

“Virtual Private Catalog and Import Catalog” “Recovery Advisor” RMAN> LIST FAILURE; RMAN> ADVISE FAILURE; RMAN> REPAIR FAILURE; <PREVIEW><NOPROMPT> RMAN What is New “Active Database Duplication”

“Multi Section Backups” “Tablespace Point in Time Recovery” “Duration” Backup duration 00:30 database; <minimize time> <minimize load> RMAN Some more cool stuff

“Validate Database” “Archival Backup” Any time this command detects a database failure, it initiates a failure assessment and logs the failure in the ADR. RMAN “Backup Failover to Non-Flash Recovery Areas” Some more stuff

“ Configure the DB_ULTRA_SAFE initialization parameter on both the primary and standby systems for the most comprehensive data corruption prevention and detection.“ DB_ULTRA_SAFE 11G NEW FUNCTIONALITIES

DB_ULTRA_SAFE In the Primary DB

DB_ULTRA_SAFE In the Standby

“Read Only Tables” “Health Monitor” “Virtual Columns” “Edition Based Redefinition” purely expression-based and aren't stored on-disk Enables you to upgrade the database component of an application while it is in use, thereby minimizing or eliminating down time. Other Important Stuff In Oracle 11G

Blah! Blah! Blah! Blah! Blah! Blah! Blah! Blah! Blah! Blah!

Thank You!

Add a comment

Related presentations

Presentación que realice en el Evento Nacional de Gobierno Abierto, realizado los ...

In this presentation we will describe our experience developing with a highly dyna...

Presentation to the LITA Forum 7th November 2014 Albuquerque, NM

Un recorrido por los cambios que nos generará el wearabletech en el futuro

Um paralelo entre as novidades & mercado em Wearable Computing e Tecnologias Assis...

Microsoft finally joins the smartwatch and fitness tracker game by introducing the...

Related pages

What was new in 11g for Backup and Recovery?

RMAN New Features and Enhancements ... introduced with Oracle Database 11g in the backup and recovery area. In this version
Read more

What's New in Backup and Recovery? - Oracle Help Center

What's New in Backup and Recovery? ... Recovery features are new in Oracle Database 11g ... enhancement is helpful when it is not ...
Read more

Oracle 11g: Backup and Recovery (RMAN) New Features ASM ...

Advanced Oracle Tips and Tricks for the Oracle DBA: ... Oracle 11g: Backup and Recovery (RMAN) New Features ... New Features for Oracle 11g: ASM enhancements.
Read more

Recovery Manager (RMAN) Enhancements in Oracle Database ...

... (RMAN) Enhancements in Oracle Database 11g Release 1. ... Backup and Recovery Enhancements in Oracle Enterprise ... What's New in Backup and Recovery?
Read more

Oracle Database 11g Backup and Recovery Technologies

Oracle Database 11g Backup and Recovery Technologies An Oracle White Paper December 2008
Read more

Oracle Database 11g Release 2: New Features Overview ...

Oracle Database 11g Release 2: New Features Overview Seminar NEW ... include new features in grid ... Backup and Recovery Enhancements Describe new SET ...
Read more

Backup And Recovery - Oracle 11g tutorial | Wisdomjobs.com

Backup And Recovery - Oracle 11g ... Oracle backup and recovery tool.The following are the key new features and enhancements in the backup and ...
Read more

Oracle Database 11g: New Features Overview

Oracle Database 11g: New Features Overview ... Parallel Backup and Restore for Very Large Files ... RMAN Data Recovery Commands RMAN Security Enhancements
Read more

Oracle Database 11g: New Features for Administrators

Application Maintenance and Upgrade Enhancements; Backup and Recovery Enhancements; Flashback Technology, ... Oracle Database 11g: New Features for ...
Read more