Create Account

Oracle 1Z0-067

Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP

Free Questions in OTE format

File Date Q&A Votes Size  
Oracle.1Z0-067.v2018-11-14.207q.ote 2018-11-14 207 0/0 837.33 Kb
Oracle.1Z0-067.v2016-02-01.176q.ote 2016-02-01 176 0/0 752.32 Kb

Notification about new Oracle 1Z0-067 files

Subscribe to Oracle 1Z0-067 dump here, you will be informed about new OTE files.

About Oracle 1Z0-067 dump

Backup and Recovery
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 database parameters that affect RMAN operations
  • Configure persistent settings for RMAN
  • View persistent settings
  • Specify a retention policy

Configure the Fast Recovery Area

  • Explain the Fast Recovery Area
  • Configure 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
  • Create and use Virtual Private Catalogs

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

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
  • Detect database corruptions using the ANALYZE and DBVERIFY utility
  • Detect database corruptions using the DBMS_REPAIR package
  • Implement the DB_BLOCK_CHECKING parameter to detect corruptions

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
  • Perform automated TSPITR

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
  • Recover using incrementally updated backups
  • Switch to image copies for fast recovery
  • Perform disaster recovery

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

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
Monitoring and Tuning of RMAN Operations
Tune RMAN performance

  • Interpret RMAN error stacks
  • Diagnose performance bottlenecks
  • Tune RMAN backup performance

Using Automatic Storage Management
Use Automatic Storage Management

  • Explain Automatic Storage Management (ASM)
  • Set up initialization parameter files for ASM and database instances
  • Administer ASM diskgroups
  • Execute SQL commands with ASM file names
  • Perform startup and shutdown for ASM instances
  • Use the ASMCMD command-line interface
  • Set up ASM fast mirror resynch
  • Use RMAN to migrate your database to ASM
  • Performing User-Managed Backup and Recovery

© 2006 ExamBrainDumps