Oracle 1Z0-067

Free Questions in OTE format

About Oracle 1Z0-067 dump

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
  

Back up and recover a NOARCHIVELOG database

• Perform backup and recovery in NOARCHIVELOG mode
  
• Use SQL in RMAN
  

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
  

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
  

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
  

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
  

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
  

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
  

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

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
  

Perform Flashback Database

• Configure Flashback Database
  
• Perform Flashback Database
  

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
  

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

Tune RMAN performance

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

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