Features of 12c Database Plugin

New Features of 12c Database Plugin

Ø Oracle Real Applications Clusters Management Enhancements

Enterprise Manager Cloud Control can be used to monitor and manage Oracle Real Applications Clusters (RAC)

Ø Manage Automatic Storage Management Clusters as a Target

We can now monitor and manage clustered Automatic Storage Management (ASM) instances as a single clustered target. This includes discovery, monitoring, configuration, and administration operations at the cluster level.

Ø Backup and Restore Enhancements

The new Group backup feature in Enterprise Manager Cloud Control provides the ability to backup multiple databases, Oracle homes, and file systems in one operation. Centrally maintained backup configurations can be created, containing uniform database and file backup settings that are applied to all of the objects in a Group backup.

Ø Streams and XStreams Support

Streams and XStreams configurations can now be managed and monitored using Enterprise Manager Cloud Control.

Ø Active Session History Analytics

Active Session History (ASH) Analytics enables a performance specialist to explore the different performance attributes of a database session at any point in time. With the ability to create filters on various dimensions, the DBA can not only identify performance issues but also obtain a good understanding of various performance patterns, workload behavior, and system resource usage.

Ø Emergency Monitoring

The Emergency Monitoring feature enables the database administrator to connect to an unresponsive database through a special proprietary mechanism and diagnose performance issues when normal mode connection is not possible.

Ø Real-time Automatic Database Diagnostic Monitor

Real-Time Automatic Database Diagnostic Monitor (ADDM) is an innovative way to analyze problems in extremely slow or hung databases, which would have traditionally required a database restart.

Ø Compare Period ADDM

The administrator can compare performance across any two periods of time and determine the root cause of why performance in one period was different than in the other.

Ø New Active Reports

Three new Active Reports have been added in this release: ASH Analytics, Real-Time ADDM, and Compare Period ADDM. These are interactive reports that can be used for offline analysis

Ø Data Subsetting

Data Subsetting provides the ability to create a smaller sized copy of the original production data that can be given to developers for testing. While it is a data subset, the referential relationships are preserved so that the data set is complete.

Ø Reversible Data Masking

You can use reversible masking, which relies on encryption and decryption algorithms, to enable user data encryption deterministically, as a regular expression in a format that you choose.

Ø Real Application Testing and Data Masking Integration

Real Application Testing and Data Masking integration provides users with the ability to perform secure testing without compromising data security and compliance regulations.

Ø Segregation of Duties

Enterprise Manager now supports the separation of roles specifically for provisioning into Designer and Operator. The Designer role corresponds to administrators who define provisioning standards. The Operator role typically corresponds to administrators who do actual software provisioning. Operators can be less experienced administrators.

Ø Provisioning Profiles

A provisioning profile is a read-only snapshot of an existing database environment that can be used as a starting point to provision a new database. The snapshot can capture the Grid infrastructure (Cluster ware and Automatic Storage Management), homes, database homes, and Database Configuration Assistant (DBCA) templates. This can all be stored in the Software Library for later use.

Ø Improved Troubleshooting for Deployment Procedures

Deployment Procedures are integrated with the Incident Framework, where incidents are automatically created for critical failures. An incident triggers dump scripts to collect debug information, which can then be packaged in an archive and sent to Oracle Support for analysis.

Ø Automatic Storage Management Cluster File System Support

Enterprise Manager now supports Automatic Storage Management Cluster File System Support (ACFS) Security and Encryption features. ACFS encryption enables users to store data on disk in an encrypted format. Enterprise Manager users who are ACFS administrators are now able to use these features to implement and manage security on file system objects stored in ACFS.