Tuesday, May 18, 2010

Oracle Database 11g RMAN New Features

Advice on abstracts recovery, alongside advancement of the aforementioned file, and basic catalogs for aegis are aloof a few of the new gems accessible from RMAN in Oracle Database 11g. Following are most valueable new features available in oracle database 11g.
Data Recovery Advisor

The Data Recover Advisor is a new tool aimed at reducing a user’s time spent analyzing and formulating a suitable recovery plan for a given failure. In Oracle Database 11g, the new Data Accretion Adviser makes this operation abundant easier. The adviser comes in two flavors: command band approach and as a awning in Oracle Enterprise Manager Database Control. Each acidity has its advantages for a accustomed specific situation. For instance, the above advantage comes in accessible back you demand to automate the identification of such files via carapace scripting and agenda accretion through a account such as cron or at. The closing avenue is accessible for amateur DBAs who ability demand the affirmation of a GUI that guides them through the process. I'll call both here.


Command Line Options

RMAN> List failure;
RMAN> List failure 142 detail;
RMAN> advise failure;
RMAN> repair failure preview;
RMAN> repair failure;

Proactive Health Checks
The apparatus dbverify can do the job but it ability be a little annoying to use because it requires autograph a calligraphy book contaning all datafiles and a lot of parameters. The achievement additionally needs scanning and interpretation. In Oracle Database 11g, a new command in RMAN, VALIDATE DATABASE, makes this operation atomic by blockage database blocks for concrete corruption. If bribery is detected, it logs into the Automatic Diagnostic Repository. RMAN again produces an achievement that is partially apparent below:

RMAN> validate database;
RMAN> validate tablespace users;
RMAN> validate datafile 1;
RMAN> validate datafile 4 block 56;

Multisession Backups
RNAM can backup or restore a single file in parallel by dividing the work among multiple channels.

RMAN> RUN
{Allocate channel c1 type disk format ‘/backup1/%U’;
 Allocate channel c1 type disk format ‘/backup1/%U’;
 Backup Section size 500m Datafile 6;
}

RMAN> List backup of datafile 6;

Fast Backup Compression

I addition to the Oracle Database 10g backup compression algorithm (BZIP2), RMAN now supports the ZLIB algorithm, which offers 10% Backup performance, with a trade-off of <20% lower compression ratio, versus BZIP2.

RMAN> configure compression algorithm ‘ZLIB’;
RMAN> configure compression algorithm ‘bzip2’

Network-enabled Database Duplication
A clone database on a remote site can now be easily created directly over the network with the enhanced DUPLICATE command, without the need for existing backups.

Virtual Private Catalog
A recovery catalog administrator can grant visibility of subset of registered database in the catalog to specific RMAN users.

Integration with Windows Volume Shadow Copy Services (VSS)
The Oracle database can participate in the VSS infrastructure on Windows platforms, with compatible backup management applications and storage system.

1 comments:

sap upgrade automation said...

Nice post. This feature is an exceptional advancement in the latest version of Oracle i.e 11g. In earlier version doing the backup and recovery process was not so easy to follow but with this feature things have become so simple for all the DBAs.