Some new features of Oracle 11g R2 document leaks

The following is just the information you get from reading the document, and everything may change before 11GR2 is officially released.

1. RMAN web-services Backup

Oracle now allows the database to be backed up directly to Amazon S3 or other cloud storage solutions via Rman, although there is no definitive offer, but it can be expected to be cheaper than buying a library. One of the things that needs to be addressed here is the efficiency of the backup and the security of the backup set.

2. edition-based redefinition

It has always been known that in the product environment, we can not arbitrarily redefine the package, functions, stored procedures, views, or may produce serious lock wait, now the introduction of edition-based redefinition help in the busy product environment through version control to Successfully upgrade or modify the application.

3. Cluster Time Service

Instead of NTP, perhaps because NTP caused a series of RAC Bugs, Oracle simply made a time synchronization service, which seems to be a prerequisite for installing RAC in 11GR2.

4. Columnar Compression

Column compression, a new compression mode, consumes more CPU power to achieve a smaller storage consumption, column compression for the application is transparent, the Data warehouse system is worth trying this new feature.

5. Data Pump Legacy Mode

The original exp in the 11GR2 is no longer supported, and IMP is still allowed to use it. So 11GR2 provides a compatibility mode that allows the previous exp and IMP scripts to be used in the data pump to provide a smoother upgrade experience for customers.

6. Significant performance improvement of On-commit Fast Refresh

For improvements in materialized view refreshes, more data warehouse users are encouraged to use materialized view overrides to improve application performance.

Finally, the most powerful new feature, that is, ASM comprehensive upgrade, completely reborn.

7. The Automatic Storage Management for the all data, yes, all of it can be stored in ASM, because ACFS in 11gr2, ADVM is a shining debut.

ASM Dynamic Volume Manager (DVM) is Oracle's volume management software, and ASM Cluster file System (ACFS) is Oracle's clustered filesystem, where it can store oracle that was previously available to ASM DataFile can also store Oracle Binary, log file, trace file, and other application program files, including OCR disk and voting required by Oracle Clusterware Disk can now also be placed in ASM (11GR2 must be placed in a bare device or a third-party clustered file system)