Full Name: Oracle Database 19c: Data Guard Administration
Exam Code: 1Z0-076
Oracle 1Z0-076 Exam Details:
| Exam Name | Oracle Database 19c - Data Guard Administration |
| Exam Code | 1Z0-076 |
| Exam Price | USD $245 (Pricing may vary by country or by localized currency) |
| Duration | 120 minutes |
| Number of Questions | 74 |
| Passing Score | 61% |
| Format | Multiple Choice Questions (MCQ) |
| Recommended Training | Oracle Database 19c: Data Guard Administration Workshop |
| Sample Questions | Oracle Certified Professional, Oracle Database 19c - Data Guard Administrator (OCE) |
| Recommended Practice | 1Z0-076 Online Practice Exam |
Oracle 1Z0-076 Syllabus Topics:
| Oracle Data Guard Basics | - Describe the Architecture of Oracle Data Guard - Explain the benefits of implementing Oracle Data Guard - Explain the applicability between physical and logical standby and snapshot databases - Explain Data Guard use with the Oracle Multi-tennant databases |
| Managing Oracle Net Services in a Data Guard Environment | - Understand the basics of Oracle Net Services - Implement Data Guard best-practice solutions in the networking setup |
| Creating a Physical Standby Database by Using SQL and RMAN Commands | - Configure the primary database and Oracle Net Services to support the creation of the physical standby database and role transition - Describe the Database Nologging Enhancements - Create a physical standby database by using the DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE RMAN command - Demonstrate the usage of the PL/SQL procedure DBMS_DBCOMP.DBCOMP - Explain the creation of a standby database by using DBCA |
| Using Oracle Active Data Guard:Supported Workloads in Read-Only Standby Databases | - Perform Real-Time query to access data on a physical standby database - Describe the supported workload in Active Data Guard (Read-Only) instances |
| Creating and Managing a Snapshot Standby Database | - Create a snapshot standby database to meet the requirement for a temporary, updatable snapshot of a physical standby database - Convert a snapshot standby database back to a physical standby database |
| Creating a Logical Standby Database | - Determine when to create a logical standby database - Manage SQL Apply filtering - Create a logical standby database |
| Oracle Data Guard Broker Basics | - Describe the Data Guard broker architecture - Explain the benefits of the Data Guard broker - Describe the Data Guard broker components - Describe Data Guard broker configurations |
| Creating a Data Guard Broker Configuration | - Create a Data Guard broker configuration - List the new Data Guard Broker commands - Manage the Data Guard broker configuration |
| Monitoring a Data Guard Broker Configuration | - Use Enterprise Manager to manage your Data Guard configuration - List the new Data Guard Broker VALIDATE commands - Invoke DGMGRL to manage your Data Guard configuration |
| Configuring Data Protection Modes | - Describe the data protection modes - Change the data protection mode of your configuration |
| Performing Role Transitions | - Explain the database roles - Perform a failover - Perform a switchover - Explain how to keep physical standby sessions during role transition |
| Using Flashback Database in a Data Guard Configuration | - Configure Flashback Database - Explain the functionality of replicated restore points - Explain the advantages of using Flashback Database in a Data Guard configuration - Explain the functionality of automatic flashback |
| Enabling Fast-Start Failover | - Configure fast-start failover - Perform role changes in a fast-start failover configuration - View information about the fast-start failover configuration - Manually reinstate the primary database - Manage the observer |
| Backup and Recovery Considerations in an Oracle Data Guard Configuration | - Use Recovery Manager (RMAN) to back up and restore files in a Data Guard configuration - Recover your primary database over the network - Offload backups to a physical standby database - Synchronize Standby Database from Primary Database with one command - Enable RMAN block change tracking for a physical standby database - Using Automatic Block Media Recovery |
| Patching and Upgrading Databases in a Data Guard Configuration | - Patch and upgrade databases using traditional patch methods - Perform rolling upgrades |
| Optimizing and Tuning a Data Guard Configuration | - Monitor configuration performance - Describe Tunable Automatic Outage Resolution - Optimize redo transport for best performance - List Diagnostic Tools in Active Data Guard (Read-Only) environment - Optimize SQL Apply |
| Managing Physical Standby Files After Structural Changes on the Primary Database | - Describe the primary database changes that may or may not require manual intervention at a physical standby database. |
| Using Oracle Active Data Guard: Far Sync and Real-Time Cascading | - Use Far Sync to extend zero data loss protection for intercontinental configurations - Describe how to create a far sync instance by using RMAN - Describe the Real-Time Cascading |
| Enhanced Client Connectivity in a Data Guard Environment | - Configure client connectivity in a Data Guard configuration - Using Application Continuity in a Data Guard Environment - Implement failover procedures to automatically redirect clients to a new primary database |
Posts
0 comments:
Post a Comment