Código: 1Z0-063
| Prova | Oracle Database 12c: Advanced Administration |
| Preço | US$ 245.00 |
| Duração | 120 minutos |
| Número de questões | ainda não definido |
| Nota de aprovação | ainda não definido |
| Treinamento oficial recomendado |
Tópicos do exame
Oracle Database 12c: Backup and Recovery
Describing Oracle Data Protection Solutions
- Explain Oracle backup and recovery solutions
Performing Basic Back up and Recovery
- Back up and recover a NOARCHIVELOG database
Configuring for Recoverability
- Configure and manage RMAN settings
- Configure the Fast Recovery Area
- Configure control files and redo log files for recoverability
Using the RMAN Recovery Catalog
- Create and use an RMAN Recovery Catalog
- Protect the RMAN Recovery Catalog
Implementing Backup Strategies
- Use various RMAN backup types and strategies
Performing Backups
- Perform full and incremental backups
- Manage backups
Configuring RMAN Backup Options and Creating Backup of Non-Database Files
- Use techniques to improve backups
- Perform backup of non-database files
Using RMAN-Encrypted Backups
- Create RMAN-encrypted backups
Diagnosing Failures
- Describe the Automatic Diagnostic Workflow
- Handle block corruption
Performing Restore and Recovery Operations
- Describe and tune instance recovery
- Perform complete and incomplete recovery
Performing Recovery of Database and Non-Database files
- Perform recovery for spfile, password file, 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
Using Oracle Secure Backup
- Configure and use Oracle Secure Backup
Using Flashback Technologies
- Describe the Flashback technologies
- Use Flashback to query data
- Perform Flashback Table operations
- Describe and use Flashback Data Archive
Using Flashback Database
- Perform Flashback Database
Transporting Data
- Describe and use transportable tablespaces and databases
Duplicating a Database
- Choose a technique for duplicating a database
- Create a backup-up based duplicate database
- Duplicate a database based on a running instance
Monitoring and Tuning of RMAN Operations
- Tune RMAN performance
Oracle Database 12c: Managing Multitenant Architecture
Multitenant Container and Pluggable Database Architecture
- Describe the multitenant architecture
- Explain pluggable database provisioning
Creating Multitenant Container Databases and Pluggable Databases
- Configure and create a CDB
- Create a PDB using different methods
- Unplug and drop a PDB
- Migrate a non-CDB to a PDB database
Managing a CDB and PDBs
- Establish connections to CDB/PDB
- Start up and shut down a CDB and open and close PDBs
- Evaluate the impact of parameter value changes
Managing Storage in a CDB and PDBs
- Manage permanent and temporary tablespaces in CDB and PDBs
Managing Security in a CDB and PDBs
- Manage common and local users
- Manage common and local privileges
- Manage common and local roles
- Enable common users to access data in specific PDBs
Managing Availability
- Perform backups of a CDB and PDBs
- Recover PDB from PDB datafiles loss
- Use Data Recovery Advisor
- Duplicate PDBs using RMAN
Managing Performance
- Monitor operations and performance in a CDB and PDBs
- Manage allocation of resources between PDBs and within a PDB
- Perform Database Replay
Moving Data, Performing Security Operations and Interacting with Other Oracle Products
- Use Data Pump
- Use SQL*Loader
- Audit operations
- Use Other Products with CDB and PDBs – Database Vault, Data Guard, LogMiner