oracle 11G 新特性

官网的说明链接如下：/cd/E11882_01/server.112/e22487/toc.htm一. 11.2.0.1新特性This chapter containsdescriptions of all of the features that are new to Oracle11g Database,Release 2. This chapter contains the following sections:(1) ApplicationDevelopment(2) Availability(3) BusinessIntelligence and Data W arehousing(4) Clustering(5) DatabaseOverall(6) Diagnosability(7) Performance(8) Security(9) ServerManageability(10) UnstructuredData Management1.1 Application DevelopmentThe followingsections describe the new application development features for Oracle Database11g Release 2 (11.2).1.1.1 OracleApplication ExpressThe following sections describe OracleApplication Express features.（1）ApplicationDate Format（2）Custom Themes（3）Declarative BLOB Support（4）DocumentedJavaScript Libraries（5） EnhancedReport Printing（6） FormsConversion（7）ImprovedSecurity（8） InteractiveReporting Region（9） Runtime-OnlyInstallation1.1.2 OtherGeneral Development FeaturesThe followingsections describe new features in the areas of OCI, Pro*C, JDBC, and otherdevelopment APIs.（1）Support W ITHHOLD Option for CURSOR DECLARATION in Pro*C（2）Pro*C Supportfor 8-Byte Native Numeric Host Variable for INSERT and FETC H（3） Pro*COBOLSupport for 8-Byte Native Numeric Host Variable for INSERT and FETCH（4） JDBCSupport for Time Zone Patching（5） JDBCSupport for SecureFile Zero-Copy LOB I/O and LOB Prefetching（6） OCISupport for 8-Byte Integer Bind/Define1.2 AvailabilityThe focus ofthis Availability section is aimed towards providing capabilities that keep theOracle database available for continuous data access, despite unplannedfailures and scheduled maintenance activities. These various capabilities formthe basis of Or acle Maximum Availability Architecture (MAA), which is theOracle blueprint for implementing a highly available infrastructure usingintegrated Oracle technologies.1.2.1 Backupand RecoveryThe followingsections describe new features in this release that provide improvements in thearea of backup and recovery.（1） AutomaticBlock RepairAutomatic blockrepair allows corrupt blocks on the primary database or physical standbydatabase to be automatically repaired, as s oon as they are detected, bytransferring good blocks from the other destination. In addition, RECOVERBLOCK is enhanced to restore blocks from a physical standby database. Thephysical standby database must be in real-time query mode.--当在主库或者物理standby库上检测到坏块时，会自动对这些坏块进行修复。

This featurereduces time when production data cannot be accessed, due to block corruption,by automatically repairing the corruptions as soon as they are detected inreal-time using good blocks from a physical standby database. This reducesb lock recovery time by using up-to-date good blocks from a real-time,synchronized physical standby database as opposed to disk or tape backups orflashback logs.（2） Backupto Amazon Simple Storage Service (S3) Using OSB Cloud ComputingOracle nowoffers backup to Amazon S3, an internet-based storage service, with the OracleSecure Backup (OSB) Cloud Module. This is part of the Oracle Cloud Computingoffering.This featureprovides easy-to-manage, low cost database backup to W eb services storage,reducing or eliminating the cost and time to manage an in-house backupinfrastructure.--使用OSB 可以将DB 备份到amazon S3 存储上。

（3） DUPLICATEW ithout Connection to Target DatabaseDUPLICATE canbe performed without connecting to a target database. This requires connectingto a catalog and auxiliary database.The benefit isimproved availability of a DUPLICATE operation by not requiringconnection to a target database. This is particularly usefulfor DUPLICATE to a destination database where connection to thetarget database may not b e available at all times.--duplicate 可以在连接到catalog 和 auxiliary 库上进行工作，而不需要在连到target db上。

（4） EnhancedTablespace Point-In-Time Recovery (TSPITR)Tablespace point-in-time recovery (TSPITR)is enhanced as follows:--TSPITR 得到如下的增强：1) You now have the ability torecover a dropped tablespace.2) TSPITR can be repeated multipletimes for the same tablespace. Previously, once a tablespace had been recoveredto an earlier point-in-time, it could not be recovered to another earlierpoint-in-time.3) DBMS_TTS.TRANSPORT_SET_CHECK isautomatically run to ensure that TSPITR is successful.4) AUXNAME is no longer usedfor recovery set data files.This feature improves usability withTSPITR.（5） NewDUPLICATE OptionsThe following are new options forthe DUPLICATE command:--Duplicate 增加选项：1）NOREDONOREDO indicatesthat archive logs are not applied. Because targetless DUPLICATE does notconnect to the target database, it cannot check if the database isrunningin NOARCHIVELOG mode. It can also be used during regular duplicationto force adatabase currently in ARCHIVELOG mode to be recoveredwithout applying archive logs (for example, because it was in NOARCHIVELOG modeat the point-in-time it is being duplicated).--noredo指定archive logs 不被应用。