주제 | 소개 |
---|
주제 1 | - Perform incomplete recovery using RMAN
- Perform Disaster recovery
- Recover using incrementally updated backups
- Restore a database onto a new host
|
주제 2 | - Using Flashback Technology
- Restore dropped tables from the recycle bin
- Describe the concepts of transportable tablespaces and databases
|
주제 3 | - Identify the types of failure that can occur in an Oracle database
- Perform backup and recovery in NOARCHIVELOG mode
|
주제 4 | - Using RMAN to Perform Recovery
- Perform complete recovery from a critical or noncritical data file loss using RMAN
|
주제 5 | - Specify different linguistic sorts for queries
- Use datetime datatypes
- Loading and Unloading Data
- Explain Data Pump architecture
|
주제 6 | - Implement Automatic Memory Management
- Manually configure SGA parameters
- Configure automatic PGA memory management
|
주제 7 | - Create duplex backup and back up backup sets
- Enable fast incremental backup
- Create a whole database backup and image file backups
|
주제 8 | - Switch to image copies for fast recovery
- Recover using a backup control file
|
주제 9 | - Using RMAN to Create Backups
- Create an archival backup for long-term retention
- Report on and maintain backups
|
주제 10 | - Reduce space related error conditions through proactively managing tablespace usage
- Use different storage options to improve the performance of queries
|
주제 11 | - Obtain globalization support configuration information
- Use automatic undo retention tuning and temporary undo
- Using Globalization Support
|
주제 12 | - Perform user-managed database recovery
- Perform user-managed and server managed backups
- Identify the need of backup mode
|
주제 13 | - Monitoring and Tuning RMAN
- Monitoring RMAN sessions and jobs
- Performing User-Managed Backup and Recovery
- Configure RMAN for Asynchronous I
- O
|
주제 14 | - Customize language-dependent behavior for the database and individual sessions
- Query data using non-case-sensitive and accent-insensitive searches
|
주제 15 | - Recover from a lost TEMP file, redo log group, password file
- Perform user-managed complete, incomplete database recovery
- Back up and recover a control file
|
주제 16 | - Manage resumable space allocation
- Reclaim wasted space from tables and indexes by using the segment shrink functionality
- Implement partitioning methods
|
주제 17 | - Using the RMAN Recovery Catalog
- Identify situations that require RMAN recovery catalog
- Back up the recovery catalog
|
주제 18 | - Create and configure a recovery catalog
- Synchronize the recovery catalog
- Create and use a virtual private catalog
|
주제 19 | - Identify the importance of checkpoints, redo log files, and archived log files
|
주제 20 | - Backup and Recovery Concepts
- Describe ways to tune instance recovery
- Configure ARCHIVELOG mode
|
참조: https://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:1Z0-034