Exam Number: 1Z0-073
Exam Title: Oracle Database 12cR2 Advanced Administration
Associated Certification Paths Database 12cR2 Administration Certified Professional
Duration: 100 Minutes
Number of Questions: 70
Passing Score: 56%%
TBD
View passing score policy
Validated Against:
Format: Multiple Choice
Complete Recommended Training
Complete the training below to prepare for your exam (optional):
Oracle Database 12c R2: Install and Upgrade Workshop Ed 2
Oracle Database 12c R2: Backup and Recovery Workshop Ed 3
Oracle Database 12c R2: Managing Multitenant Architecture Ed 2
Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1
Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.
Oracle Database 12c R2: Managing Multitenant Architecture Ed 2
CDB basics
Describe the CDB root and pluggable database containers
Differentiate the CDB root from a pluggable database
CDB and Regular PDBs
Configure and create a CDB
Create a new PDB from the CDB seed
Explore the instance
Explore the structure of PDBs
Application PDBs and Application Installation
Explain the purpose of application root and application seed
Define and create application PDBs
Install an application
Upgrade and patch applications
Describe the commonality concept in application contexts
Describe enhancements in various areas
PDB Creation
Clone an application PDB
Unplug and plug a non-CDB
Unplug and plug a regular PDB
Unplug and plug an application container
Convert regular PDBs to application PDBs
Configure and use the local UNDO mode
Perform hot cloning
Perform near-zero downtime PDB relocation
Create and use a proxy PDB
Drop PDBs
CDB and PDB Management
Establish connections to CDB and PDB
Start up and shut down a CDB
Open and close PDBs
Start PDB service
Change the different modes and settings of PDBs
Evaluate the impact of parameter value changes
Storage
Manage permanent tablespaces in CDB and PDBs
Manage temporary tablespaces in CDB and PDBs
Manage the UNDO tablespaces in CDB root and PDB
Security
Manage common and local users, roles, privileges and profiles in PDBs
Manage common and local objects in application containers
Enable common users to access data in PDBs
Manage PDB lockdown profiles
Manage other types of policies in application containers
Allow per-PDB wallets for certificates
Backup, Recovery, and Flashback
Backup CDB and PDBs
Recover a PDB from essential file damage
Recover a PDB from non-essential file damage
Use RMAN backups to plug unplugged PDBs
Duplicate PDBs
Validate CDBs and PDBs
Perform CDB flashback
Perform PDB flashback
Use clean restore points to complete PDB flashback
Performance Monitoring
Monitor operations and performance in a CDB and PDBs
Manage SGA and PGA limits at the PDB level
Manage AWR snapshots at the CDB and PDB levels
Run ADDM tasks for CDB and PDB recommendations
Manage application shared object statistics
Control query DOP involving the containers() construct
Control PDB IO rate limits
Resources Allocation
Manage resource allocation between PDBs and within a PDB
Manage PDB performance profiles
Avoid excessive session PGA
Data Movement
Export from a non-CDB and import into a PDB
Export from a PDB and import into a PDB or into a non-CDB
Use SQL*Loader to load data into a PDB
Upgrade Methods
Upgrade 12.1 CDB to 12.2
Upgrade 12.1 PDBs to PDBs in 12.2
PDBs in Cloud
Create a database deployment in the Cloud
Create PDBs in the Cloud database using DBaaS Monitor
Understand encryption in a Cloud CDB and PDBs
Manage PDBs in the Cloud database using DBaaS Monitor
Migrate on-premises PDBs in a database deployment in the Cloud
Oracle Database 12c R2: Backup and Recovery Workshop Ed 3
Getting Started
Set your ORCL database in NORARCHIVELOG mode
Configuring for Recoverablility
Configure and manage RMAN settings
Configure the Fast Recovery Area
Configure the control file to ensure appropriate protection
Configure the redo log files for recoverability
Configure ARCHIVELOG mode and the archived redo log files for recoverability
Using the RMAN Recovery Catalog
Contrast the use of a recovery catalog with that of a control file (to store backup information)
Create and configure an RMAN recovery catalog
Manage the Recovery Catalog Records(cross check and synchronize)
Protect the RMAN recovery catalog
Backup Strategies and Terminology
Describe RMAN backup types
Describe, compare and determine your backup strategy
Perform whole backups
Performing Backups
Perform full and incremental backups
Report and manage backups
Begin refining your basic backups:
configure block change tracking
Perform incremental level 1 backup
Recover incremental level 0 backup with level 1 incremental
Improving Your Backups
Compress backups
Use a media manager
Create multi-section backups of very large files
Create proxy copies
Create duplexed backup sets
Create archival backups
Backup non-database files:
Backup up a control file to trace
Backup archived redo log files
Catalog additional backup files
Back up ASM meta data
Using RMAN-Encrypted Backups
Describe and create RMAN-encrypted backups
Distinguish and use the following modes:
Transparent-mode encryption
Password-mode encryption
Dual-mode encryption
Diagnosing Failures
Detect and repair database corruption
Use the Automatic Diagnostic Repository
Analyze instance recovery with ADRCI
Find and interpret message output and error stacks
Use the Data Recovery Advisor
Handle block corruption
Restore and Recovery Concepts
Understand how to employ the best Oracle Database recovery technology for your failure situation
Describe instance or crash recovery
Describe complete recovery
Describe point-in-time recovery
Describe recovery through RESETLOGS
Performing Recovery, Part 1
Perform the appropriate type of restore and recovery operation based on the nature of your database failure
Recover from media failures in data files
Perform complete and incomplete or “point-in-time” recoveries
Performing Recovery, Part 2
Recover from loss of the server parameter file
Recover from control file and redo log file failures
Recreate the password authentication file
Recover index and read-only tablespaces
Review the automatic recovery of the tempfile
Describe the basic procedure of restoring the database to a new host
RMAN and Oracle Secure Backup
Configure for RMAN tape backups and restores
Perform RMAN backup to tape
Perform database recovery from tape
Manage tape backups
Using Flashback Technologies
Understand how to use flashback technologies to protect against and recover from various types of errors
Configure your database to use flashback technologies
Perform flashback operations
Distinguish temporal validity and temporal history
Using Flashback Database
Describe Flashback Database architecture
Configure your database to support Flashback Database
Perform Flashback Database
Transporting Data
Transport tablespaces between databases using image copies or backup sets
Transport databases using data files or backup sets
Performing Point-in-Time Recovery
Distinguish and describe point-in-time recovery (PITR) of table, tablespace, and database
Identify the circumstances where PITR is a good solution and where it cannot be used
List what operations occur when you perform a point-in-time recovery
Determine the correct target time for the point-in-time recovery
Perform automated TSPITR
Perform table recovery from backups
Duplicating a Database
Choose a technique for duplicating a database
Duplicate a database with RMAN
Use an RMAN backup to duplicate a database
Duplicate a database based on a running instance
RMAN Troubleshooting and Tuning
Interpret RMAN message output
Apply best practice tuning principles
Diagnose RMAN performance issues
Cloud Tooling for Backup and Recovery
Understand to Cloud Tooling Available for Backup and Recovery in a Database Cloud Instance.
List Backup Destinations
Describe Backup Utilities
Configure a Cloud Instance Backup
Perform an On-Demand Backup
Recover a a cloud Instance
Backup from On-Premise to Oracle Storage Cloud
Recover On-Premise Database from Storage Cloud
Oracle Database 12c R2: Install and Upgrade Workshop Ed 2
Oracle Software Installation Basics
Operating System Groups and Users
Environment Variables
Configuring the Oracle Software Owner EnvironmentUsing Oracle Universal Installer (OUI)
Installation Option: Silent Mode
Installing Oracle Grid Infrastructure for a Standalone Server
Overview of Oracle Grid Infrastructure for a Standalone Server and Oracle Restart
ASM Storage Components
Configuring Storage for Oracle Automatic Storage Management
Oracle Grid Infrastructure Installation: System Requirements
Creating Operating System Groups and Users
Installing Oracle Grid Infrastructure for Standalone Server
Upgrading Existing Oracle ASM Instances
Patching Oracle Software
Overview of Patching and patch types
Determining the latest patch sets available
Upgrading OPatch
Patching Using OPatch
Post Patch steps using Datapatch
Patching Using opatchauto
Patching Using OPlan
Installing Oracle Database Software
Oracle Database Installation: System Requirements
Creating Operating System Groups and Users
Types of Installation
Installing Oracle
Oracle Restart
Configuring and using Oracle Restart
Choosing and using the Correct SRVCTL Utility
Displaying the Oracle Restart Configuration for a Component
Manually Adding Components to the Oracle Restart Configuration
Preparing to Upgrade to Oracle Database 12c
Performance Testing
Using the Pre-Upgrade Information Tool
Performing Post-Upgrade Tasks
Required and recommended Tasks After Database Upgrade
Understanding Auditing Implementation
Enabling Unified Auditing
Administering the Roles Required for Auditing
Migrating Data by Using Oracle Data Pump
Oracle Data Pump: Overview
Data Pump Utility: Interfaces and Modes
Migrating by Using Oracle Data Pump
Importing by Using a Network Link
Click here to view complete Q&A of 1Z0-073 exam
Certkingdom Review, Certkingdom PDF Torrents
Best Oracle 1Z0-073 Certification, Oracle 1Z0-073 Training at certkingdom.com