Oracle 11g R2 recovery manager RMAN enhancements

BKJIA featured translations] Oracle 11g R2 extends many new feature suites for backup and recovery, including recovery manager RMAN, many of which are extensions for earlier features.

BKJIA editing recommendations: New features and application details of Oracle 11g

Automated block recovery. In my opinion, the block-level media recovery MBR introduced by Oracle 10gR1 has convinced people that at least people are considering using RMAN to replace outdated alter tablespace... The begin backup method backs up the database. MBR means that when only a small part of data blocks need to be restored, people no longer need to restore and restore a complete data file. Oracle 11g R2 now automates MBR. If one or more corrupted data blocks are detected in the data file, RMAN will automatically restore and restore these data blocks, DBA does not need to do anything. If the real-time query mode of data guard is enabled, Oracle 11g R2 can check the corresponding physical backup database to find the latest data block version that has not been damaged, and transmit this intact data block to the primary database.

Flexible set newname commands. If you do not have a data file list, restore a DATABASE to a different platform or file system at a specified time point using RAMN, duplicate database, or tablespace, you will know how welcome these new features. Oracle 11g R2 can now accept the tablespace-level or database-level FORMAT specification for data file names. In addition, a unique identifier % U can be listed now) or basic name % B), but the new data file name is more standardized.

No target database replication. Cloning a database in an earlier database version requires connecting to the target database, which is always inconvenient because the target database may be unavailable, oracle 11g R2 now uses the duplicate database command to execute non-target replication on any selected DATABASE, but it still produces an AUXILIARY to connect to the final copied DATABASE. Of course, now a CATALOG connection is required to restore a directory database. The NOREDO and undo tablespace commands must be specified for non-target replication, because there is no way to check whether the source database is in ARCHIVELOG mode and which source database TABLESPACE is an undo tablespace.

Enhanced TSPITR. Oracle 11g R2 removes some restrictions on table space Point-In-Time Recovery (TSPITR) restoration at a specified Time Point In the Tablespace, and provides a very useful tool to restore the Tablespace, it can be restored to the status at a certain time point before the tablespace. no matter whether the restored directory is available or not, TSPITR can now restore any number of time points. TSPITR can also restore the deleted tablespace.

Back up data to cloud. Undoubtedly, cloud computing will be the hottest technology in the future. Oracle 11g R2 can now back up the database to Amazon's Simple Storage Service (S3, use the security backup media management software provided by Oracle.

Bkjia.com is translated. Do not reprint it if it is not authorized. For reprinted on the Cooperation site, please indicate the original translator and the source is bkjia.com, and the original content cannot be modified .]

Original article: The Second 5 top new features in Oracle Database 11g R2 Author: Jim Czuprynski