New Features of Oracle 11g R2 document Leakage

The following is only the information obtained by reading the document. Everything may change before 11gR2 is officially released.

1. RMAN Web-Services Backup
Oracle now allows direct backup of databases to Amazon S3 or other cloud computing storage solutions through RMAN, although there is no clear offer, however, it is foreseeable that it will be cheaper than purchasing a tape library. One problem that needs to be solved here is the backup efficiency, and the other is the security of the Backup set.

2. Edition-Based Redefinition
We have always known that in the product environment, we cannot redefine packages, functions, stored procedures, and views at will. Otherwise, serious lock waits may occur, the introduction of Edition-Based Redefinition helps you to smoothly upgrade or modify applications in busy product environments through version control.

3. Cluster Time Service
It may be because NTP has caused a series of RAC bugs. Therefore, Oracle simply implements a time synchronization service by itself. It seems that this is a prerequisite for installing RAC in 11gR2.

4. Columnar Compression
Column compression, a new compression method, consumes more CPU capabilities to achieve lower storage consumption, column compression is transparent to applications, the data warehouse system is worth trying this new function.

5. Data Pump Legacy Mode
The first exp in 11gR2 is no longer supported, and imp is still allowed. Therefore, 11gR2 provides a compatibility mode that allows you to use the previous exp and imp scripts in Data Pump to provide a smoother upgrade experience.

6. Significant Performance Improvement of On-Commit Fast Refresh
To improve the refresh of materialized views, more data warehouse users are encouraged to rewrite materialized views to improve application performance.

Finally, it is also the most important new feature, that is, the comprehensive upgrade of ASM and a new one.

7. Automatic Storage Management for All DataYes, all the data can be stored in ASM, because in 11gR2, ACFS, ADVM debuted.

ASM Dynamic Volume Manager (DVM)Is the volume management software of Oracle,ASM Cluster File System (ACFS)It is an Oracle Cluster file System. It not only stores the Oracle Datafile that can be accommodated by ASM, but also stores the Oracle Binary, log file, trace file and program files of other applications, OCR Disk and Voting Disk required by Oracle Clusterware can now be placed in ASM before 11gR2 must be placed on a bare device or a third-party Cluster File System)

1. Solve the sorting and efficiency problems in Oracle paging Query
2. Four skills for middle-stage Oracle Database Management
3. Network Application of Oracle Database