新增Database 12cR2 Administration Certified Professional

郑全

主要增加云部分的内容.
升级路径：可以从11g ocp/12c ocp 直接升级到 12c r2 ocp

考试编号：1Z0-074

考试教材：
Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1


考试知识点：


Introduction

• Global objectives of the course
• Lessons grouped by area
• Schedule of the week
  

Application Containers and Applications

• Application root and application PDBs
• Create and manage an application container
• Install application in an application container
• Patch application
• Upgrade application
• Impacts in Data Guard, Oracle GoldenGate, Oracle Streams, XStream, ADO and Heat Map
  

Security in PDBs

• Create users commonly, locally in application containers
• Grant privileges commonly, locally in application containers
• Difference between common and local roles in application containers
• Grant roles commonly, locally in application containers
• Difference between common and local objects in application containers
• Difference between common and local profiles in application containers
• Manage PDB lockdown profiles
• Create unified auditing policies operations in application containers
  

PDBs Creation Using New Methods

• Create a PDB from CDB seed enhancements
• Unplug into a PDB archive file and plug using the archive file
• Create a local UNDO tablespace at PDB level
• Hot cloning
• Near-zero downtime PDB relocation
• Create a remote proxy PDB
  

PDBs Recovery and Flashback

• Shut down a PDB when an essential PDB datafile is missing
• Flashback at PDB level
• Flashback a PDB to a clean PDB restore point
  

Performance in PDBs

• View CDB / PDB ADDM analysis
• Manage SGA and PGA at the PDB level
• Share resources between PDBs
  

Upgrade and Other Operations in PDBs

• Upgrade a 12.1.0.2 CDB to 12.2
• Upgrade a 12.1.0.2 PDB to 12.2 by using unplug / plug / upgrade
• Use cross-platform non-CDB or PDB backupsets to import into a CDB
  

Privileges and User Profiles

• New 12.2 SYSRAC administrative privilege
• Password file enhancements
• Grant administrative privileges to external users
• Migrate the password file from pre-12 or 12.1 to 12.2
• New system privilege INHERIT ANY REMOTE PRIVILEGES and object privilege INHERIT REMOTE PRIVILEGES
• Enhance the security of administrative users
• Pre-configure a maximum number of days in the user profile for which a user can remain inactive
  

Unified Auditing

• Create and enable audit policies for all users to whom the role is granted directly
• Capture VPD (Virtual Private Database) generated predicates
  

Data Redaction

• New redaction format library in EM GUI
• Redaction policy expression
• New redaction functions
  

Data Encryption

• Encrypt / decrypt / rekey tablespaces online
• Specific tablespaces: SYSAUX, SYSTEM, UNDO and temporary
• Complete the operations with ALTER TABLESPACE ENCRYPTION FINISH ENCRYPT|REKEY|DECRYPT
  

Transparent Sensitive Data Protection

• Use TSDP with Unified Auditing
• Use TSDP with Fine-Grained Auditing (FGA)
• Use TSDP with Transparent Data Encryption (TDE)
  

Availability Enhancements

• Non auto-login support for duplicate: Use encrypted backups whose decryption keys are in a non auto-login wallet
• Update and drop the catalog without entering the UPGRADE CATALOG and DROP CATALOG commands twice: UPGRADE / DROP CATALOG NOPROMPT
• Automate the two step manual process into one recovery operation after missing logs found during RECOVER DATABASE: Recover Database Until Available Redo
• REPAIR FAILURE command
• Transport Data Across Platforms
• Steps to recover a table
• Describe online redefinition supports
  

Oracle Data Pump, SQL*Loader and External Tables

• Oracle Data Pump enhancements
• SQL*Loader enhancements
• External table enhancements
  

In-Memory Column Store

• Dynamic parameter in 12.2 : INMEMORY_SIZE
• Caches results of frequently evaluated expressions and virtual columns for subsequent reuse
• Optimizing joined columns by creating join groups
• Interaction with other products, features
  

SQL Tuning

• SQL Performance Analyzer enhancements
• SQL Plan Management enhancements
• Statistics Gathering Performance Improvements: Optimizer Statistics Advisor
• SQL Performance Analyzer (SPA) enhancements to make it resilient to certain workloads which can cause divergence
• New ways of SQL processing
• Continuous Adaptive Query Plans
  

Resource Manager and Other Performance Enhancements

• Manage session PGA limit
• Reduce Cursor Invalidations for DDLs
• Describe the Advanced Index Compression (HIGH)
• Define real-time materialized views with on query computation
• Use ON STATEMENT refresh when a DML operation takes place on materialized views without the need to committhe transaction
• Describe HCC data compression with ADO row-level policy
  

Partitioning

• Explain auto-list partitioning
• Composite partitioning
• Explain multicolumn list partitioning
• Read-only partition
• Defer subpartition segment creation
• Filter data during partition maintenance operations
  

Manageability

• Start / stop a DBOP by specifying the Session ID and Serial#
  

Diagnosability

• Set a retention target to ADR for an automatic delete of ADR files
• Use the retention advisor
• Install TFA Collector by default for RDBMS (with RDBMS root scripts)
• Start TFA Collector
• Allow Data Pump tracing to be changed without stopping and then restarting the job
• MV refresh statistics
  

Oracle Database Cloud Services

• Describe the Oracle Database Cloud Services console
• Create a database deployment under 12.2
• Database deployment backup and recovery automatic procedures
• Differences between database deployments and on-premises databases
• Migrate on-premises database to Oracle Database Public Cloud Services
  

SQL Enhancements

• Describe the new SQLcl utility
• Use new 128 bytes length for database objects
• Recall SQL*Plus commands in the same session from memory
• Use the new VALIDATE_CONVERSION function