Download Oracle Database-12c-New Features Guide PDF

TitleOracle Database-12c-New Features Guide
TagsOracle Database Sql Databases Pl/Sql Resource Description Framework
File Size2.3 MB
Total Pages128
Table of Contents
                            Contents
List of Tables
Preface
	Audience
	Documentation Accessibility
	Related Documents
	Conventions
1 Oracle Database 12c Release 1 (12.1) New Features
	1.1 Application Development
		1.1.1 Enhanced Developer Productivity with Oracle Application Express
			1.1.1.1 Accessibility
			1.1.1.2 Automatic Purging of Workspaces
			1.1.1.3 Dynamic Actions
			1.1.1.4 End User Data Upload
			1.1.1.5 Error Handling
			1.1.1.6 Expanded Interactive Reports
			1.1.1.7 Improved Charting Engine
			1.1.1.8 Mobile Applications
			1.1.1.9 Modernized Application Builder
			1.1.1.10 Packaged Applications
			1.1.1.11 Plug-Ins
			1.1.1.12 Tabular Forms
			1.1.1.13 Team Development
			1.1.1.14 Themes and Templates
			1.1.1.15 Time Stamp and Time Zone Support
			1.1.1.16 Use of ROWID
			1.1.1.17 Web Services Support
			1.1.1.18 Websheets
		1.1.2 Enhanced Globalization Support
			1.1.2.1 Expanded Database Locale Support
			1.1.2.2 Replacement of CSSCAN and CSALTER with DMU
			1.1.2.3 Unicode 6.1 Support
			1.1.2.4 Unicode Collation Algorithm Conformance
		1.1.3 General
			1.1.3.1 Import and Export of Workspace Manager Schema
			1.1.3.2 Performance Improvements to Workspace Operations and Views
		1.1.4 Improved Oracle SQL and PL/SQL
			1.1.4.1 An Invoker's Rights Function Can Be Result Cached
			1.1.4.2 An Object of Type LIBRARY Can Be Defined Using an Object of Type DIRECTORY
			1.1.4.3 Enhanced Oracle Native LEFT OUTER JOIN Syntax
			1.1.4.4 JDBC Support for PL/SQL Data Types as Parameters
			1.1.4.5 Mechanism to Restrict the Ability to Reference a PL/SQL Unit to a White List of Database Objects
			1.1.4.6 Native Client API Support for PL/SQL Package Types and Boolean Types as Parameters
			1.1.4.7 New PL/SQL DBMS_UTILITY.EXPAND_SQL_TEXT Procedure
			1.1.4.8 New PL/SQL Package UTL_CALL_STACK
			1.1.4.9 New Predefined PL/SQL Inquiry Directives
			1.1.4.10 New SCHEMA Parameter for DBMS_SQL.PARSE() Procedure
			1.1.4.11 PL/SQL Functions Defined in the SQL WITH Clause
			1.1.4.12 PL/SQL-Specific Data Types Allowed Across the PL/SQL-to-SQL Interface
			1.1.4.13 Precompilers Support for SQL Plan Management
			1.1.4.14 SQLJ Support for SQL Plan Management
			1.1.4.15 Temporal Validity
			1.1.4.16 Temporal Validity Flashback Queries
		1.1.5 OCI/OCCI Enhancements
			1.1.5.1 Auto-Tuning Oracle C Client Interface (OCI) Applications
			1.1.5.2 Oracle C/C++ Client (OCI/OCCI) Support for Row Count Per Iteration for Array DML
		1.1.6 Reduced Cost and Complexities of Migrating to Oracle
			1.1.6.1 Default Values for Columns Based on Oracle Sequences
			1.1.6.2 DEFAULT Values for Columns on Explicit NULL Insertion
			1.1.6.3 IDENTITY Columns
			1.1.6.4 Increased Size Limit for VARCHAR2, NVARCHAR2, and RAW Data Types
			1.1.6.5 JDBC Support for Sybase Applications Migration
			1.1.6.6 Implicit Result Sets
			1.1.6.7 Native SQL Support for Query Row Limits and Row Offsets
			1.1.6.8 Oracle Database Driver for MySQL Applications
			1.1.6.9 Precompiler Support for Prefetch By Memory
			1.1.6.10 SQL CROSS APPLY, OUTER APPLY and LATERAL
			1.1.6.11 SQL Translation Framework
		1.1.7 Support .NET and Microsoft Development Community
			1.1.7.1 Microsoft .NET Framework 4 and 4.5 Support
			1.1.7.2 Oracle TimesTen In-Memory Database
			1.1.7.3 64-Bit ODP.NET XCopy for Windows x64
			1.1.7.4 Entity Framework and LINQ
			1.1.7.5 Implicit REF CURSOR Parameter Binding
			1.1.7.6 Oracle SQL Supports APPLY Keyword
			1.1.7.7 Returning Row Counts
			1.1.7.8 Windows Communication Foundation (WCF) Data Services and Open Data Protocol (OData)
		1.1.8 Support Java Development Community
			1.1.8.1 JDBC Support for Monitoring Database Operations (DBOP)
			1.1.8.2 Database Support for JDK Upgrade
			1.1.8.3 Database Support for Latest Java SE and Standard Utilities
			1.1.8.4 Enhanced Security for Java in the Database
			1.1.8.5 JDBC Enhanced Security
			1.1.8.6 JDBC Support for Database Resident Connection Pool
			1.1.8.7 JDBC Support for Latest Java Standards
	1.2 Business Intelligence and Data Warehousing
		1.2.1 Oracle Advanced Analytics
			1.2.1.1 Decision Tree Mining Text Data
			1.2.1.2 Expectation Maximization (EM) Clustering and Density Estimation
			1.2.1.3 Feature Extraction Using Singular Value Decomposition
			1.2.1.4 Feature Selection and Creation for Generalized Linear Models (GLM)
			1.2.1.5 Native Double in Data Mining Functions
			1.2.1.6 Native SQL Support for Row Pattern Matching
			1.2.1.7 Native Text Support
			1.2.1.8 On-the-Fly Models
			1.2.1.9 Prediction Details and Cluster Functions
		1.2.2 Oracle OLAP
			1.2.2.1 Cube Query Performance Enhancements
			1.2.2.2 Cube Statistics Support
		1.2.3 Partitioning Enhancements
			1.2.3.1 Asynchronous Global Index Maintenance for DROP and TRUNCATE Partition
			1.2.3.2 Cascade Functionality for TRUNCATE and EXCHANGE Partition
			1.2.3.3 Interval Reference Partitioning
			1.2.3.4 ONLINE Move Partition
			1.2.3.5 Partial Indexes for Partitioned Tables
			1.2.3.6 Partition Maintenance Operations on Multiple Partitions
		1.2.4 Performance With Zero Effort
			1.2.4.1 Adaptive Query Optimization
			1.2.4.2 Adaptive SQL Plan Management
			1.2.4.3 Automatic Column Group Detection
			1.2.4.4 Concurrent Execution of UNION and UNION ALL Branches
			1.2.4.5 Concurrent Statistics Gathering
			1.2.4.6 Database Smart Flash Cache Support for Multiple Flash Devices
			1.2.4.7 Dynamic Statistics
			1.2.4.8 Enhanced Parallel Statement Queuing
			1.2.4.9 Enhancements to Incremental Statistics
			1.2.4.10 Enhancements to System Statistics
			1.2.4.11 Improved Automatic Degree of Parallelism
			1.2.4.12 New Types of Optimizer Statistics
			1.2.4.13 Online Statistics Gathering for Bulk Loads
			1.2.4.14 Out-of-Place Materialized View Refresh
			1.2.4.15 Session-Private Statistics for Global Temporary Tables
			1.2.4.16 SQL Plan Directives
			1.2.4.17 Synchronous Materialized View Refresh
	1.3 Compression and Archiving
		1.3.1 Archiving
			1.3.1.1 Database Hardening: Enable Flashback Data Archive (FDA) for Security-Related Application Tables
			1.3.1.2 Flashback Data Archive Improvements
		1.3.2 General
			1.3.2.1 Optimization for Flashback Data Archive History Tables
		1.3.3 Information Lifecycle Management
			1.3.3.1 Automatic Data Optimization (ADO)
			1.3.3.2 EXECUTE_ILM Procedure
			1.3.3.3 Heat Map
			1.3.3.4 PL/SQL Interface for Managing ADO Policies
			1.3.3.5 Row-Level Compression Tiering
			1.3.3.6 Segment-Level Compression Tiering
			1.3.3.7 In-Database Archiving
		1.3.4 SecureFiles Enhancements
			1.3.4.1 Enable PDML Operations on SecureFiles
			1.3.4.2 Oracle Data Pump: Support SecureFiles LOB as Default
			1.3.4.3 SecureFiles is the Default for LOB Storage
	1.4 Database Overall
		1.4.1 Database Consolidation
			1.4.1.1 Integrate With Operating System Processor Groups
			1.4.1.2 Oracle Data Pump Support for Database Consolidation: Full Transportable
			1.4.1.3 Multitenant Architecture
			1.4.1.4 PDBs Backup and Recovery
			1.4.1.5 PDBs Point-in-Time Recovery
			1.4.1.6 PDBs Resource Plans
		1.4.2 Grid Scheduler
			1.4.2.1 New Job Types
		1.4.3 Overall
			1.4.3.1 Cloning a Database
		1.4.4 Utilities
			1.4.4.1 LOGTIME Parameter for Oracle Data Pump Command
			1.4.4.2 Oracle Data Pump Audit Commands
			1.4.4.3 Oracle Data Pump Change Table Compression at Import Time
			1.4.4.4 Oracle Data Pump Enhanced Compression Options
			1.4.4.5 Oracle Data Pump Export View As a Table
			1.4.4.6 Oracle Data Pump No Logging Option for Import
			1.4.4.7 Oracle Data Pump Security: No-Echo of Encryption Passwords on Export and Import Commands
			1.4.4.8 SQL*Loader and External Tables: Use dNFS for Accessing Files on NFS Servers
			1.4.4.9 SQL*Loader Audit Direct Path Loads
			1.4.4.10 SQL*Loader Express Mode
	1.5 High Availability
		1.5.1 Application Continuity
			1.5.1.1 Application Continuity for Java
			1.5.1.2 Transaction Guard
		1.5.2 Logical Replication
			1.5.2.1 Support for Extended VARCHAR2 in XStream
			1.5.2.2 XStream New Apply Parameters
			1.5.2.3 XStream New Capture Parameters
			1.5.2.4 XStream Optimized Management of Large Transactions
			1.5.2.5 XStream Support for Advanced LOB Deduplication
			1.5.2.6 XStream Support for XML Object Relational and Binary
		1.5.3 Global Data Services
			1.5.3.1 Global Data Services (GDS)
			1.5.3.2 Oracle C/C++ Application High Availability Enhancements
		1.5.4 Improved Resiliency
			1.5.4.1 Oracle ASM Disk Scrubbing
		1.5.5 Online Operations
			1.5.5.1 Editioned and Noneditioned Objects
			1.5.5.2 Enhanced Online DDL Capabilities
			1.5.5.3 Invisible Columns
			1.5.5.4 Lock Timeout for FINISH_REDEF_TABLE
			1.5.5.5 Metadata-Only DEFAULT Column Values for NULL Columns
			1.5.5.6 Move a Data File Online
			1.5.5.7 Multiple Indexes on Same Set of Columns
			1.5.5.8 Online Redefinition of Multiple Partitions
			1.5.5.9 Single Command REDEF_TABLE to Redefine Table or Partition
			1.5.5.10 Support Redefinition of Tables With VPD Policies
		1.5.6 Oracle Data Guard Enhancements
			1.5.6.1 Advanced Data Guard Broker Manageability
			1.5.6.2 Oracle Data Guard Broker Support for Cascaded Standby Databases
			1.5.6.3 Fast Sync
			1.5.6.4 Single Command Role Transitions
			1.5.6.5 Real-Time Apply is Default Setting for Data Guard
			1.5.6.6 Resumable Switchover Operations
			1.5.6.7 Active Data Guard Enhanced Security
			1.5.6.8 Active Data Guard Support for DML on Global Temporary Tables
			1.5.6.9 Active Data Guard Support for Sequences
			1.5.6.10 Active Data Guard Real-Time Cascade
			1.5.6.11 Active Data Guard Far Sync
		1.5.7 Data Guard Rolling Upgrade Enhancements
			1.5.7.1 Data Guard Rolling Upgrade Support for Advanced Data Types
			1.5.7.2 Data Guard Rolling Upgrade Support for XDB Repository
			1.5.7.3 Disaster Protection During Database Rolling Upgrade
			1.5.7.4 Oracle Advanced Queuing (AQ) Support for Data Guard Database Rolling Upgrade
			1.5.7.5 Oracle Data Guard Broker Support for Database Rolling Upgrades
			1.5.7.6 Oracle Scheduler Support for Data Guard Database Rolling Upgrade
			1.5.7.7 Rolling Upgrade Using Active Data Guard
			1.5.7.8 SQL Apply Extended Data Type Support (EDS)
			1.5.7.9 SQL Apply Support for Objects, Collections, and XMLType
			1.5.7.10 SQL Apply Support for XMLType
			1.5.7.11 SQL Apply Support for SecureFiles LOBs
		1.5.8 Oracle Database Advanced Queuing Enhancements
			1.5.8.1 JMS Bulk Message Purging
			1.5.8.2 JMS Event-Driven Listener
			1.5.8.3 JMS Message Priorities, Exception Queues, and Expiration
			1.5.8.4 JMS Transactional Nonpersistent Queues
			1.5.8.5 Message Forwarding on Oracle RAC
			1.5.8.6 AQ Rules Engine Fast Evaluation of SYS_CONTEXT and Other Predicates
			1.5.8.7 Rules Engine Result Cache
			1.5.8.8 Sharded Queues for Performance and Scalability
			1.5.8.9 Simplified Metadata and Schema
		1.5.9 RMAN Enhancements
			1.5.9.1 Active Database Duplication Enhancements
			1.5.9.2 Cross-Platform Backup and Restore
			1.5.9.3 DUPLICATE Enhancements
			1.5.9.4 Multisection Image Copies
			1.5.9.5 Multisection Incremental Backups
			1.5.9.6 Network-Enabled RESTORE
			1.5.9.7 RMAN Command-Line Interface Enhancements
			1.5.9.8 Storage Snapshot Optimization
			1.5.9.9 Table-Level Recovery From Backups
	1.6 Manageability
		1.6.1 Database Performance Tuning
			1.6.1.1 Enterprise Manager Database Express
			1.6.1.2 PGA Size Limit
			1.6.1.3 Real-Time Database Operations Monitoring
			1.6.1.4 Resource Manager Runaway Query Management
			1.6.1.5 Spot ADDM
		1.6.2 Database Testing
			1.6.2.1 Mask At Source or Mask During Subset
			1.6.2.2 Self Update for Oracle Applications Masking and Subsetting Templates
			1.6.2.3 Database Replay Support for Database Consolidation
			1.6.2.4 Database Replay Workload Scale-Up and Characterization
			1.6.2.5 Enhanced Database Replay Reporting
		1.6.3 General
			1.6.3.1 Queryable Patch Inventory
	1.7 Oracle RAC and Grid Infrastructure
		1.7.1 Oracle ASM Enhancements
			1.7.1.1 Oracle Flex ASM
			1.7.1.2 Oracle ASM Shared Password File in a Disk Group
			1.7.1.3 Oracle ASM Rebalance Enhancements
			1.7.1.4 Oracle ASM Disk Resync Enhancements
			1.7.1.5 Oracle ASM chown, chgrp, chmod and Open Files Support
			1.7.1.6 Oracle ASM Support ALTER DISKGROUP REPLACE USER
			1.7.1.7 Enterprise Manager Support for Oracle ASM Features
			1.7.1.8 Oracle ASM File Access Control on Windows
			1.7.1.9 Oracle Grid Infrastructure Rolling Migration for One-Off Patches
		1.7.2 Oracle ACFS Enhancements
			1.7.2.1 Oracle ACFS Support for All Oracle Database Files
			1.7.2.2 Oracle ACFS and Highly Available NFS
			1.7.2.3 Oracle ACFS Snapshots Enhancements
			1.7.2.4 Oracle ACFS Replication Integration with Oracle ACFS Security and Encryption
			1.7.2.5 Oracle Audit Vault Support for Oracle ACFS Security and Encryption
			1.7.2.6 Oracle ACFS Security and Encryption Features
			1.7.2.7 Oracle ACFS File Tags for Grid Homes
			1.7.2.8 Oracle ACFS Plug-in APIs
			1.7.2.9 Enterprise Manager Support for Oracle ACFS New Features
			1.7.2.10 Oracle ACFS Replication and Tagging on AIX
			1.7.2.11 Oracle ACFS Replication and Tagging on Solaris
		1.7.3 Oracle Clusterware Enhancements
			1.7.3.1 Oracle Flex Cluster
			1.7.3.2 Policy-Based Cluster Management and Administration
			1.7.3.3 What-If Command Evaluation
			1.7.3.4 Oracle Cluster Registry Backup in ASM Disk Group Support
			1.7.3.5 Shared Grid Naming Service (GNS)
			1.7.3.6 SRVCTL Support for Oracle Flex Cluster Implementations
			1.7.3.7 Online Resource Attribute Modification
		1.7.4 Other Grid Infrastructure Enhancements
			1.7.4.1 Grid Infrastructure Script Automation for Installation and Upgrade
			1.7.4.2 Multipurpose Cluster Installation Support
		1.7.5 Oracle RAC Enhancements
			1.7.5.1 Support for IPv6 Based IP Addresses for Oracle RAC Client Connectivity
	1.8 Performance
		1.8.1 Database Performance Enhancements
			1.8.1.1 Advanced Network Compression
			1.8.1.2 Very Large Network Buffers
		1.8.2 General
			1.8.2.1 Asynchronous I/O Control for Direct NFS Client
			1.8.2.2 Tracking I/O Outliers
		1.8.3 Hardware Optimizations
			1.8.3.1 Multi-Process Multi-Threaded Oracle
		1.8.4 Improve Ease of Performance Out-of-the-Box
			1.8.4.1 Ability to Specify NFS Version in Direct NFS Client
	1.9 Security
		1.9.1 Data Encryption, Hashing and Redaction
			1.9.1.1 Oracle Data Redaction
			1.9.1.2 Support for Secure Hash Algorithm SHA-2 in Oracle Database
		1.9.2 Database Security Enhancements
			1.9.2.1 Auditing Enabled By Default
			1.9.2.2 Code-Based Security
			1.9.2.3 Data Guard Support for Separation of Duty (SoD)
			1.9.2.4 Enhanced Security of Audit Data
			1.9.2.5 Increased Security When Using SELECT ANY DICTIONARY
			1.9.2.6 Last Login Time Information
			1.9.2.7 Oracle Database Vault Mandatory Realms
			1.9.2.8 Oracle Label Security Metadata Export and Import
			1.9.2.9 Password Complexity Check
			1.9.2.10 Privilege Analysis
			1.9.2.11 Resource Role Default Privileges
			1.9.2.12 Separation of Duty for Audit Administration
			1.9.2.13 Separation of Duty for Database Administration
			1.9.2.14 SYSBACKUP Administration Privilege
		1.9.3 Encryption Key Management Enhancements
			1.9.3.1 Updated Key Management Framework
		1.9.4 Improve Security Manageability, Administration and Integration
			1.9.4.1 Oracle Database Vault Persistent Protections
			1.9.4.2 Simplified Oracle Database Vault and Oracle Label Security Installation
			1.9.4.3 Transparent Sensitive Data Protection
			1.9.4.4 VPD Fine-Grained Context-Sensitive Policies
		1.9.5 Protect the Database Server From Outside
			1.9.5.1 Restricted Service Registration for Oracle RAC
		1.9.6 Real Application Security
			1.9.6.1 Real Application Security
		1.9.7 Security Optimizations
			1.9.7.1 Unified Context-Based Database Audit Architecture
	1.10 Spatial and Graph
		1.10.1 Oracle Spatial and Graph Enhancements
			1.10.1.1 Vector Performance Acceleration
			1.10.1.2 Spatial Routing Engine Enhancements
			1.10.1.3 Spatial Geocoder - Improved Asian Address Support Using Zones
			1.10.1.4 Spatial GeoRaster - Raster Algebra and Analytics
			1.10.1.5 Spatial GeoRaster - Enhanced Image Processing
			1.10.1.6 Spatial GeoRaster - Java API Enhancements
			1.10.1.7 Spatial GeoRaster - New Metadata Content
		1.10.2 Network Data Model and RDF Semantic Graph Enhancements
			1.10.2.1 Network Data Model Graph - Feature Modeling and Analysis
			1.10.2.2 Network Data Model Graph - Temporal Modeling and Analysis
			1.10.2.3 RDF Views on Relational Tables
			1.10.2.4 RDF Semantic Graph Named Graph Support
			1.10.2.5 Support for Analytic Operations and Tools
			1.10.2.6 RDF Semantic Graph Support for XML Schema, Text and Spatial Data Types
			1.10.2.7 RDF Semantic Graph Document Indexing Enhancements
			1.10.2.8 RDF Semantic Graph Support for W3C and OGC Standards, Open Source, and Third-Party Technologies
	1.11 Unstructured Data
		1.11.1 Oracle Multimedia Enhancements
			1.11.1.1 DICOM Protocol Support for Oracle Database
			1.11.1.2 Integrating Oracle Multimedia DICOM with Oracle WebCenter Content
			1.11.1.3 Full Mode Database Import and Export for Oracle Multimedia
		1.11.2 Oracle Text Enhancements
			1.11.2.1 Near Real-Time Indexing
			1.11.2.2 Automatic Management of Near Real-Time Indexes
			1.11.2.3 BIG_IO Large TOKEN_INFO Option
			1.11.2.4 Separate Offsets
			1.11.2.5 Updatable SDATA Sections
			1.11.2.6 Add SDATA Section to Existing Index
			1.11.2.7 Ordering by SDATA Sections
			1.11.2.8 Increased Number of Field Sections
			1.11.2.9 Document-Level Lexer
			1.11.2.10 Increased Number of MDATA Sections
			1.11.2.11 Language Identification
			1.11.2.12 BIGRAM Mode for the Japanese VGRAM Lexer
			1.11.2.13 Mild Not (MNOT) Operator
			1.11.2.14 Forward Index
			1.11.2.15 NEAR Operator Enhancements
			1.11.2.16 Pattern Stopclass
			1.11.2.17 Session-Duration SQEs
			1.11.2.18 Query Filter Cache
			1.11.2.19 Snippet Support in Result Set Interface
		1.11.3 Oracle XML Enhancements
			1.11.3.1 Enhanced ANYDATA Support
			1.11.3.2 Integrated Oracle XQuery Implementation
			1.11.3.3 Oracle XDK/J DOM Improvements
			1.11.3.4 Domain Index Support of Hash Partitioned Tables
			1.11.3.5 Oracle XSLT or XPath Engine Interoperability
			1.11.3.6 Programmatically Create and Manipulate Scalable DOM
			1.11.3.7 Standalone XQuery Virtual Machine
			1.11.3.8 Support XQuery Full-Text Specification
			1.11.3.9 XDK/J Support for Fast Infoset
			1.11.3.10 XmlDiff Support for XDK Java
			1.11.3.11 Support for XQuery Update
		1.11.4 Oracle XML Repository Enhancements
			1.11.4.1 Enable Digest Authentication with Oracle Database HTTP Listener
			1.11.4.2 WebDAV, HTTP, and FTP Access for DBFS
	1.12 Upgrades
		1.12.1 General
			1.12.1.1 Enhanced Upgrade Automation
			1.12.1.2 Parallel Upgrade
	1.13 Windows
		1.13.1 Windows Security Enhancements
			1.13.1.1 Support for Oracle Home User on Windows
			1.13.1.2 Support of Oracle Home User for Oracle Net Services
			1.13.1.3 Named User Support for Oracle RAC Services on Windows
2 Oracle Database 12c Documentation
	2.1 Documentation Titles and Online Documentation Structure
		2.1.1 Data Mining Documentation
		2.1.2 Gateways Documentation
		2.1.3 Installation Documentation
		2.1.4 Java Development Documentation
		2.1.5 Oracle® Multimedia 12c Documentation
		2.1.6 OLAP Documentation
		2.1.7 Oracle Text Documentation
		2.1.8 Release Notes Documentation
		2.1.9 Server Documentation
		2.1.10 Spatial and Semantic Documentation
		2.1.11 TimesTen In-Memory Database Documentation
                        
Document Text Contents
Page 1

Oracle® Database
New Features Guide

12c Release 1 (12.1)

E17906-16

June 2013

Oracle Database New Features Guide is addressed to those of
you familiar with previous releases of Oracle Database and
who would like to become familiar with features, options,
and enhancements that are new in this release of the
database.

Page 2

Oracle Database New Features Guide, 12c Release 1 (12.1)

E17906-16

Copyright © 2001, 2013, Oracle and/or its affiliates. All rights reserved.

Contributor: The Oracle Database 12c documentation is dedicated to Mark Townsend, who was an
inspiration to all who worked on this release.

This software and related documentation are provided under a license agreement containing restrictions on
use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your
license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license,
transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse
engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is
prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If
you find any errors, please report them to us in writing.

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it
on behalf of the U.S. Government, the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software,
any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users
are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and
agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and
adaptation of the programs, including any operating system, integrated software, any programs installed on
the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to
the programs. No other rights are granted to the U.S. Government.

This software or hardware is developed for general use in a variety of information management
applications. It is not developed or intended for use in any inherently dangerous applications, including
applications that may create a risk of personal injury. If you use this software or hardware in dangerous
applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other
measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages
caused by use of this software or hardware in dangerous applications.

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of
their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks
are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD,
Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced
Micro Devices. UNIX is a registered trademark of The Open Group.

This software or hardware and documentation may provide access to or information on content, products,
and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly
disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle
Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your
access to or use of third-party content, products, or services.

Page 64

High Availability

1-48 Oracle Database New Features Guide

Zero data loss protection can be achieved across long distances. The far sync instance
is located within a distance of the primary database where synchronous transport does
not impact application performance. Far Sync handles all communication with remote
standby databases and is transparent when executing a zero data loss failover. Far
Sync also offloads the production database of the overhead of servicing multiple
remote destinations and redo transport compression.

1.5.7 Data Guard Rolling Upgrade Enhancements
The following sections describe rolling upgrades in Oracle Database.

1.5.7.1 Data Guard Rolling Upgrade Support for Advanced Data Types
This release includes additional native redo-based replication for Data Guard SQL
Apply to support database rolling upgrades (transient logical standby). Data types
include XMLType stored as binary XML, XMLType stored in object-relational format,
objects and collections, Database File System (DBFS), XDB, Oracle Spatial and Graph,
Oracle Text, Oracle Multimedia, Label Security, and Oracle SecureFiles (deduplication
and fragment operations).

Data Guard database rolling upgrades reduce planned downtime by enabling the
upgrade to new database releases or patch sets in rolling fashion. Total database
downtime for such an upgrade is limited to the small amount of time required to
execute a Data Guard switchover.

1.5.7.2 Data Guard Rolling Upgrade Support for XDB Repository
XML DB Repository supports Data Guard rolling upgrades.

XML DB Repository is no longer a restriction for Data Guard rolling upgrades. Oracle
Database can be upgraded to new patch sets and database releases in a rolling fashion,
minimizing planned downtime for a broader range of customer Oracle Database
deployments.

1.5.7.3 Disaster Protection During Database Rolling Upgrade
Data protection is maintained during the Oracle Data Guard database rolling upgrade
process by enabling the standby database that is the target of the upgrade to continue
receiving primary database redo while the standby database is open in upgrade mode.

This reduces management complexity by eliminating the requirement to create and
maintain a separate archive log repository to provide the same level of data protection.

See Also:

Oracle Data Guard Concepts and Administration for details

See Also:

Oracle Data Guard Concepts and Administration for details

See Also:

Oracle XML DB Developer's Guide for details

See Also:

Oracle Data Guard Concepts and Administration for details

Page 65

High Availability

Oracle Database 12c Release 1 (12.1) New Features 1-49

1.5.7.4 Oracle Advanced Queuing (AQ) Support for Data Guard Database Rolling
Upgrade
Databases that use Oracle Advanced Queuing (AQ) can be upgraded to new Oracle
Database releases and patch sets in rolling fashion using Data Guard database rolling
upgrades (transient logical standby database only). Rolling upgrades are supported
beginning in Oracle Database 12c Release 1 (12.1).

Data Guard database rolling upgrades reduce planned downtime by enabling the
upgrade to new database releases or patch sets in rolling fashion. Total database
downtime for such an upgrade is limited to the small amount of time required to
execute a Data Guard switchover.

1.5.7.5 Oracle Data Guard Broker Support for Database Rolling Upgrades
Oracle Data Guard broker now supports database rolling upgrades. With this new
feature, the Data Guard broker configuration can be preserved so that it does not have
to be rebuilt after the upgrade is complete.

1.5.7.6 Oracle Scheduler Support for Data Guard Database Rolling Upgrade
Oracle Scheduler jobs that are created at a primary database are replicated to a
transient logical standby database. This simplifies using Data Guard to upgrade to
new Oracle Database releases and patch sets in rolling fashion (transient logical
standby database only).

Data Guard database rolling upgrades reduce planned downtime by enabling the
upgrade to new database releases or patch sets in rolling fashion. Total database
downtime for such an upgrade is limited to the small amount of time required to
execute a Data Guard switchover.

1.5.7.7 Rolling Upgrade Using Active Data Guard
Active Data Guard provides several new PL/SQL packages and DDL commands to
automate the previous manual steps of performing a database rolling upgrade to a
new Oracle patch set, database release, or to perform other planned maintenance. The
process starts with a primary and physical standby database at the previous version
and ends with both primary and physical standby database at the new version. The
automation includes handling the switchover of production to the new version. It also
performs extensive validation at every step of the process. If problems are encountered
users can choose to either correct the error and resume the upgrade or roll back to the
original state of the configuration.

Rolling upgrade using Active Data Guard reduces management effort and improves
the reliability of performing database rolling upgrades. Users benefit from lower
administrative cost and higher availability by reducing downtime for planned
maintenance.

See Also:

Oracle Database Advanced Queuing User's Guide for details

See Also:

Oracle Data Guard Broker for details

See Also:

Oracle Data Guard Concepts and Administration for details

Page 127

Documentation Titles and Online Documentation Structure

Oracle Database 12c Documentation 2-19

Oracle TimesTen In-Memory
Database C Developer's Guide

E21637 Provides information about developing C
applications to access the Oracle TimesTen
In-Memory Database through ODBC. It also
includes information about TimesTen
support for XLA, OCI, and the Pro*C/C++
Precompiler.

Oracle TimesTen In-Memory
Database Java Developer's
Guide

E21638 Provides information about developing Java
applications to access the Oracle TimesTen
In-Memory Database through JDBC. It also
includes information about support for
TimesTen JMS/XLA.

Oracle TimesTen In-Memory
Database PL/SQL Developer's
Guide

E21639 Provides information about using PL/SQL
with the Oracle TimesTen In-Memory
Database.

Oracle TimesTen In-Memory
Database TTClasses Guide

E21640 Describes how to use the TimesTen C++
Interface Classes (TTClasses) library.

Oracle TimesTen In-Memory
Database SQL Reference

E21642 Provides a reference for SQL statements,
expressions, and functions used with the
Oracle TimesTen In-Memory Database,
including TimesTen SQL extensions. It also
describes data types.

Oracle TimesTen In-Memory
Database Reference

E21643 Provides a reference for attributes, built-in
procedures and utilities used with the Oracle
TimesTen In-Memory Database.

Oracle TimesTen In-Memory
Database System Tables and
Views Reference

E21644 Describes TimesTen system tables and
replication tables.

Oracle TimesTen In-Memory
Database PL/SQL Packages
Reference

E21645 Provides reference information for packages
provided with TimesTen PL/SQL.

Oracle TimesTen In-Memory
Database Error Messages and
SNMP Traps

E21646 Provides a reference for Oracle TimesTen
In-Memory Database error messages and
SNMP traps.

Oracle TimesTen In-Memory
Database JDBC Extensions
Java API Reference

E21647 Provides reference information for TimesTen
JDBC classes and interfaces.

Oracle TimesTen In-Memory
Database JMS/XLA Java API
Reference

E21648 Provides reference information for TimesTen
JMS/XLA classes and interfaces.

Oracle Enterprise Manager
System Monitoring Plug-in for
Oracle TimesTen In-Memory
Database User's Guide

E28645 Describes how to install the Oracle
Enterprise Manager Plug-in for Oracle
TimesTen In-Memory Database.

Oracle Enterprise Manager
System Monitoring Plug-in for
Oracle TimesTen In-Memory
Database Release Notes

E28646 Provides late-breaking information about the
Oracle Enterprise Manager Plug-in for
Oracle TimesTen In-Memory Database.

Table 2–11 (Cont.) TimesTen In-Memory Database Documentation

Documentation
Part
Number Description

Page 128

Documentation Titles and Online Documentation Structure

2-20 Oracle Database New Features Guide

Similer Documents