CompTIA Online Training

1Z0-073 Oracle Database 12cR2 Advanced Administration

August 20, 2018 by admin

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

Comments |0|