Oracle Database 12c Overview
Oracle Database 12c Introduction Oracle Database Architecture Overview Oracle Database Instance Configurations Oracle Database Memory Structures Process Structures Process Startup Sequence Database Storage Architecture Logical and Physical Database Structures Container and Pluggable Database Overview Installing Oracle Grid Infrastructure for a Standalone Server Overview of Oracle Grid Infrastructure for a Standalone Server System Requirements for Oracle Grid Infrastructure Configuring Storage for Oracle Automatic Storage Management (ASM) Installing Oracle Grid Infrastructure for a Standalone Server Upgrading Oracle Grid Infrastructure for a Standalone Server
Installing Oracle Database Software
Planning Your Installation System Requirements for Oracle Database Configuring Oracle Linux with Oracle RDBMS Pre-Install RPM Operating System Groups and Users Setting Environment Variables Checking the System Requirements Using the Oracle Universal Installer (OUI) Performing a Silent Mode Installation
Creating an Oracle Database by Using DBCA
Planning the Database Storage Structure Choosing non-CDB or CDB Types of Databases (based on workload) Choosing the Appropriate Character Set Understanding How Character Sets are used Setting the NLS_LANG Initialization Parameter Using the Database Configuration Assistant (DBCA) Oracle Database Management Tools
Introducing Oracle Database Management Tools
Using SQL*Plus Using SQL Developer Logging in to Oracle Enterprise Manager Database Express Using the Enterprise Manager Database Express Home Page Understanding the Enterprise Manager Cloud Control Framework Using Enterprise Manager Cloud Control
Managing the Database Instance
Initialization Parameter Files Starting an Oracle Database Instance Shutting Down an Oracle Database Instance Viewing Log Files Using Trace Files Using the Dynamic Performance Views Data Dictionary
Configuring the Oracle Network Environment
Oracle Net Services Overview Oracle Net Listener Overview Establishing Oracle Network Connections Connecting to a Server Tools for Configuring and Managing the Oracle Network Using the Listener Control Utility Using Oracle Net Configuration Assistant Using Oracle Net Manager
Administering User Security
Database User Accounts (overview) Predefined Administrative Accounts Creating a User Authentication Unlocking a User Account and Resetting the Password Privileges Roles Profiles
Managing Database Storage Structures
Understanding Storage of Data Database Block contents Exploring the Storage Structure Creating a New Tablespace Overview of Tablespaces Created by Default Managing Tablespaces Viewing Tablespace Information Using Oracle Managed Files
Managing Space
Space Management Overview Block Space Management Row Chaining and Migration Free Space Management within Segments Types of Segments Allocating Extents Allocating Space Creating Tables without Segments
Managing Undo Data
Undo Data Overview Transactions and Undo Data Storing Undo Information Comparing Undo Data and Redo Data> Managing Undo Configuring Undo Retention Guaranteeing Undo Retention Changing an Undo tablespace to a Fixed Size
Managing Data Concurrency
Overview of Locks Locking Mechanism Data Concurrency DML Locks Enqueue Mechanism Lock Conflicts
Implementing Oracle Database Auditing
Separation of Responsibilities Database Security Monitoring for Compliance Standard Database Auditing Unified Audit Data Trail Separation for Duties for Audit Administration (AUDIT_ADMIN and AUDIT_VIEWER roles) Configuring the Audit Trail Specifying Audit Options
Backup and Recovery Concepts
Categories of Failures Flashback Technology Understanding Instance Recovery Phases of Instance Recovery Tuning Instance Recovery Using the MTTR Advisor Comparing Complete and Incomplete Recovery Oracle Data Protection Solutions
Backup and Recovery Configuration
Configuring for Recoverability Configuring the Fast Recovery Area Multiplexing the Control File Online Redo Log File Multiplexing the Online Redo Log File Archived Redo Log Files Archiver Process Archived Redo Log File Naming and Destinations
Performing Database Backups
Backup Solutions Overview Oracle Secure Backup (overview) User Managed Backup (overview) Backup Terminology and Types of Backups Using Recovery Manager (RMAN) Configuring Backup Settings Oracle-Suggested Backup Backing Up the Control File to a Trace File
Performing Database Recovery
Data Recovery Advisor Loss of a Control File Loss of a Redo Log File Loss of a Datafile in NOARCHIVELOG Mode Loss of a Noncritical Datafile in ARCHIVELOG Mode Loss of a System-Critical Datafile in ARCHIVELOG Mode
Moving Data
Describe ways to move data Use SQL*Loader to load data from a non-Oracle database Use external tables to move data via platform-independent files Explain the general architecture of Oracle Data Pump Use Data Pump Export and Import to move data between Oracle databases
Performing Database Maintenance
Manage the Automatic Workload Repository (AWR) Use the Automatic Database Diagnostic Monitor (ADDM) Describe and use the advisory framework Set alert thresholds User server-generated alerts Use automated tasks
Managing Performance
Use Automatic Memory Management Use the Memory Advisor to size memory buffers
Managing Performance: SQL Tuning
Manage optimizer statistics Use the SQL Tuning advisor Use the SQL Access Advisor to tune a workload
Managing Resources Using Database Resource Manager
Configure the Database Resource Manager Access and create resource plans Monitor the Resource Manager
Automating Tasks by Using Oracle Scheduler
Use Oracle Scheduler to simplify management tasks Use job chains to perform a series of related tasks Use Scheduler jobs on remote systems Use advanced Scheduler features to prioritize jobs
Using Oracle Restart
Oracle Restart Overview Oracle Restart Process startup Controlling Oracle Restart Choosing the Correct SRVCTL Utility Oracle Restart Configuration Using the SRVCTL Utility Obtaining Help for the SRVCTL Utility Starting Components by Using the SRVCTL Utility
Introduction to Upgrading to Oracle Database 12c
Upgrade Methods Data Migration Methods Supported Releases for Direct Upgrade Overview of Upgrade Process Performing a Rolling Upgrade Upgrading a CBD Upgrading by Using the Database Upgrade Assistant (DBUA) Manually Upgrading to Oracle Database 12c
Oracle 12c DBA-II [1Z0-063]
Oracle Data Protection Solutions
Explain Oracle backup and recovery solutions Describe types of database failures Describe the tools available for backup and recovery tasks Describe RMAN and maximum availability architecture Use the SYSBACK privilege Use RMAN stand-alone and job commands
Performing Basic Backup and Recovery
Back up and recover a NOARCHIVELOG database Perform backup and recovery in NOARCHIVELOG mode Use SQL in RMAN
Configuring for Recoverability
Configure and manage RMAN settings Configure persistent settings for RMAN View persistent settings Specify a retention policy Configure the Fast Recovery Area Explain the Fast Recovery Area Configure control files and redo log files for recoverability Multiplex control files Multiplex redo log files
Using the RMAN Recovery Catalog
Create and use an RMAN recovery catalog Configure a recovery catalog Register target databases in a recovery catalog Catalog additional backup files Resynchronize a recovery catalog Use and maintain RMAN stored scripts Upgrade and drop a recovery catalog Protect the RMAN recovery catalog Back up the recovery catalog Re-create an unrecoverable recovery catalog Export and import the recovery catalog
Implementing Backup Strategies
Use various RMAN backup types and strategies Enable ARCHIVELOG mode Create tape and disk based backups Create whole database backups Create consistent and inconsistent backups Create backup sets and image copies Create backups of read-only tablespaces Employ best practices for data warehouse backups Using Enterprise Manager Cloud Control
Performing Backups
Perform full and incremental backups Create full and incremental backups Use the Oracle-suggested backup strategy
Manage backups
Configure and monitor block change tracking Report on backups using LIST, REPORT commands Manage backups using CROSSCHECK, DELETE commands
Configuring RMAN Backup Options and Creating Backup of Non-Database Files
Use techniques to improve backups Create compressed backups Create multi-section backups of very large files Create proxy copies Create duplexed backup sets Create backups of backup sets Create archival backups Perform backup of non-database files Back up a control file to trace Back up archived redo log files Back up ASM diskgroup metadata
Using RMAN-Encrypted Backups
Create RMAN-encrypted backups Use transparent-mode encryption Use password-mode encryption Use dual-mode encryption Restore encrypted backups
Diagnosing Failures
Describe the Automatic Diagnostic Workflow Use the Automatic Diagnostic Repository Use ADRCI Find and interpret message output and error stacks Use the Data Recovery Advisor Handle block corruption Detect block corruption using RMAN Perform block recovery using RMAN
Performing Restore and Recovery Operations
Describe and tune instance recovery Perform complete and incomplete recovery Use RMAN RESTORE and RECOVER commands Restore ASM disk groups Recover from media failures Perform complete and incomplete or “point-in-time” recoveries using RMAN
Recovering Files Using RMAN
Perform recovery for spfile, control file, redo log files Perform table recovery from backups Perform recovery of index and read-only tablespaces, temp file Restore a database to a new host
Using Oracle Secure Backup
Configure and use Oracle Secure Backup
Using Flashback Technologies
Describe the Flashback technologies Configure a database to use Flashback technologies Guarantee undo retention Use Flashback to query data Use Flashback Query Use Flashback Version Query Use Flashback Transaction Query Flash back a transaction Perform Flashback Table operations Perform Flashback Table Restore tables from the recycle bin Describe and use Flashback Data Archive Use Flashback Data Archive Use DBMS_FLASHBACK_ARCHIVE package
Using Flashback Database
Perform Flashback Database Configure Flashback Database Perform Flashback Database
Transporting Data
Describe and use transportable tablespaces and databases Transport tablespaces between databases using image copies or backup sets Transport databases using data files or backup sets Transport data across platforms
Duplicating a Database
Choose a technique for duplicating a database From an active database, connected to the target and auxiliary instances From backup, connected to the target and auxiliary instances From backup, connected to the auxiliary instance, not connected to the target, but with recovery catalog connection From backup, connected to the auxiliary instance, not connected to the target and the recovery catalog Duplicate a database with RMAN Create a backup-up based duplicate database Duplicate a database based on a running instance
Moving Data
Describe ways to move data Use SQL*Loader to load data from a non-Oracle database Use external tables to move data via platform-independent files Explain the general architecture of Oracle Data Pump Use Data Pump Export and Import to move data between Oracle databases
Monitoring and Tuning of RMAN Operations
Tune RMAN performance Interpret RMAN error stacks Diagnose performance bottlenecks Tune RMAN backup performance
Multitenant Container and Pluggable Database Architecture
Describe the multitenant container database architecture Explain pluggable database provisioning
Creating Multitenant Container and Pluggable Databases
Configure and create a CDB Create a PDB using different methods Unplug and drop a PDB Migrate a non-CDB database to PDB
Managing a CDB and PDBs
Establish connections to CDB/PDB Start up and shut down a CDB and open and close PDBs Evaluate the impact of parameter value changes
Managing Storage in a CDB and PDBs
Manage permanent and temporary tablespaces in CDB and PDBs
Managing Security in a CDB and PDBs
Manage common and local users Manage common and local privileges Manage common and local roles Enable common users to access data in specific PDBs
Managing Availability
Perform backups of a CDB and PDBs Recover PDB from PDB datafiles loss Use Data Recovery Advisor Duplicate PDBs using RMAN
Managing Performance
Monitor operations and performance in a CDB and PDBs Manage allocation of resources between PDBs and within a PDB Perform Database Replay
Moving Data, Performing Security Operations and Interacting with Other Oracle Products
Use Data Pump Use SQL*Loader Audit operations Use Other Products with CDB and PDBs - Database Vault, Data Guard, LogMiner