1z0-076
Oracle Database 19c: Data Guard Administration
1Z0-076 Oracle Database 19c Data Guard Administration Exam Guide
Oracle 1Z0-076 validates administration knowledge used to create high-availability and disaster-recovery solutions with Oracle Database 19c Data Guard. It is aimed particularly at database systems administrators responsible for disaster recovery and leads to the Oracle Certified Professional, Oracle Database 19c: Data Guard Administrator credential. This guide helps you decide whether your current experience is sufficient, which technical areas need deliberate practice, how to sequence your study, and when to confirm your readiness against the official exam information before scheduling.
What does 1Z0-076 validate?
1Z0-076, titled Oracle Database 19c: Data Guard Administration, tests whether you can work with Data Guard as an availability and disaster-recovery technology rather than merely recall isolated commands. Oracle says the certification demonstrates the ability to create a high-availability or disaster-recovery solution for an Oracle Database ecosystem.
The Oracle certification catalog places 1Z0-076 in the High Availability section of its Oracle Database certifications. The associated credential is Oracle Certified Professional, Oracle Database 19c: Data Guard Administrator. That positioning matters when you interpret the syllabus: the central question is how Data Guard protects, operates, monitors, and supports an Oracle database environment.
Oracle identifies Data Guard concepts, configuration, management, optimization, monitoring, data protection, high availability, and disaster recovery as knowledge areas developed through preparation. Oracle also associates the certification with workload-offload capabilities available in Data Guard. A useful study plan therefore needs both configuration knowledge and operational judgment: you should be able to select an approach, recognize its consequences, and diagnose an unhealthy configuration.
The practical capability behind the credential
The practical target is a defensible Data Guard design and administration process. That includes understanding how redo moves from a primary database, how a standby protects the primary, how protection modes change the availability and data-loss trade-off, and how administrators respond when synchronization or transport does not behave as expected.
Do not reduce the exam to a list of syntax fragments. A command is easier to remember when you understand the state it changes, the prerequisite it assumes, and the failure consequence that follows. Build those links while studying, especially for protection modes, redo transport, standby synchronization, and workload offload.
Who is the exam designed for?
Oracle describes the certification as intended for database systems administrators responsible for disaster recovery. Oracle lists an ideal candidate profile of 4 to 5 years of database-administration experience and 2 to 3 years of Data Guard experience. Treat that profile as a signal about expected context, not as a substitute for checking the current official eligibility and registration information.
Candidates with regular Oracle administration experience but limited Data Guard exposure should expect the configuration and failure-behavior topics to require extra time. Candidates who already operate Data Guard should spend less time rereading definitions and more time testing whether they can explain why a configuration meets a particular availability, performance, or protection requirement.
The credential is a stronger fit when your work involves standby databases, disaster recovery, planned or unplanned downtime, redo transport, synchronization, monitoring, or recovery decisions. If your experience is mainly unrelated application development, begin with the architecture and administration fundamentals before committing to an exam date.
A sensible self-assessment
Classify your current knowledge into three groups: tasks you have performed, tasks you can explain but have not performed, and tasks whose terminology is unfamiliar. The first group needs exam-style discrimination; the second needs a controlled lab or detailed walkthrough; the third needs foundational reading before practice questions become useful.
Pay particular attention to whether you can reason from a business requirement to a Data Guard choice. For example, can you explain what the organization is prioritizing when it chooses maximum availability instead of maximum performance? Can you identify what an acknowledgment confirms in a particular redo transport arrangement? Those questions expose gaps more reliably than command memorization.
What are the official exam facts?
Oracle lists the exam as multiple choice, with 74 questions, a duration of 120 minutes, and a passing score of 61%. Oracle states that the exam has been validated for Oracle Database 19c. These are the official facts in the supplied research and should be checked again on Oracle’s exam page before registration because administrative details can change.
The listed passing score is 61%; it is not a recommended practice target or a promise that a practice result predicts the exam outcome. Use it to understand the published threshold, then set a higher private readiness standard by requiring consistent reasoning across all major knowledge areas.
The supplied official research does not provide a detailed percentage blueprint for individual domains. Do not invent or infer domain weights from the general topic list. Instead, use the named knowledge areas to construct balanced coverage, giving additional study time to areas where you lack practical experience.
How to use the time limit in preparation
The 120-minute exam duration and 74-question format make reading discipline important, but they do not justify rushing through unfamiliar material. During practice, learn to identify the tested decision first, eliminate options that contradict the stated protection or availability requirement, and flag questions that require a slower comparison.
A practical recommendation is to use two passes in timed practice. On the first pass, answer questions whose wording and technical basis are clear. On the second, revisit flagged items and verify that your choice fits every condition in the scenario. This is a preparation method, not an official exam procedure; the official page remains the authority for delivery and current rules.
How should you study the three protection modes?
Start with the business trade-offs, then connect each mode to its redo transport behavior and failure response. Oracle’s 19c documentation identifies maximum availability, maximum performance, and maximum protection as the three Data Guard protection modes. The exam-relevant skill is distinguishing what each mode prioritizes and what happens when the standby cannot acknowledge the required redo.
Maximum availability provides the highest level of data protection possible without compromising primary database availability. If the primary cannot receive acknowledgment from at least one synchronized standby, Oracle documents that it operates as if it were in maximum performance mode to preserve primary availability until it can write its redo stream to a synchronized standby.
Maximum performance provides the highest level of data protection possible without affecting primary database performance. Oracle describes it as offering slightly less data protection than maximum availability mode with minimal impact on primary database performance. Study this mode as a deliberate performance-oriented choice, not as an automatically inferior configuration.
Maximum protection adds a stronger response to the risk of unprotected transactions. Unlike maximum availability, which allows the primary to continue processing if it cannot receive acknowledgment from a standby, maximum protection shuts the primary down rather than allowing it to continue processing transactions that are unprotected.
Oracle says maximum protection is similar to maximum availability but provides an additional level of data protection in the event of multiple failure events. Because the mode prioritizes data protection over primary availability, Oracle recommends a minimum of two standby databases for a primary running in maximum protection mode, so that failure of one standby does not cause the primary to shut down.
Build a protection-mode decision table
Create your own three-row table with these columns: business priority, transport expectation, primary-database behavior when acknowledgment is unavailable, and likely operational consequence. Fill it from the Oracle documentation rather than from memory. The act of explaining the consequence is more valuable than copying the mode names.
For maximum protection, explicitly record that protecting the primary from continuing with unprotected transactions can mean shutting the primary down. For maximum availability, record that the primary preserves availability by operating as maximum performance when it cannot receive acknowledgment from at least one synchronized standby. These distinctions are easy to blur in a hurried answer.
Understand SYNC, AFFIRM, and NOAFFIRM
Oracle explains that SYNC/AFFIRM makes the primary wait for acknowledgment that redo has been transmitted synchronously to the physical standby and written to disk. In that arrangement, the standby has the redo on disk when the system is recovered, so Oracle states there would be no data loss in the described recovery situation.
SYNC/NOAFFIRM makes the primary wait for acknowledgment that data has been received on the standby, not that it has been written to disk. Oracle identifies a performance benefit and potential exposure to data loss in a special case of multiple simultaneous failures. Do not treat SYNC alone as equivalent to SYNC/AFFIRM; the acknowledgment condition matters.
The supplied Oracle table lists these required redo transport attributes: maximum availability uses SYNC with either AFFIRM or NOAFFIRM according to configuration, maximum performance uses ASYNC with NOAFFIRM, and maximum protection uses SYNC with AFFIRM. The same table also requires DB_UNIQUE_NAME to be unique on the primary database and on each standby database.
Study the transport attributes as a set of conditions, not as independent vocabulary. When a question presents a protection mode, ask what the mode requires, what the acknowledgment confirms, and what performance or failure trade-off the stated attributes create. That sequence prevents a familiar-looking option from overriding the actual scenario.
Which technical skills deserve the most lab time?
Use lab time for state changes and failure analysis, not only for successful setup. The official knowledge areas cover concepts, configuration, management, optimization, monitoring, data protection, high availability, disaster recovery, and workload offload. A useful lab should let you connect configuration choices to observed status and recovery implications.
Begin with a simple primary-and-standby model that you can reset. Practice identifying each database consistently, checking the relationship between primary and standby, and following redo from generation through transport and application. Then introduce controlled interruptions and configuration changes so that you can explain what the administrator should verify next.
Include the LOG_ARCHIVE_CONFIG and protection-mode syntax shown in Oracle’s documentation as reading exercises and, where your environment supports it, controlled lab exercises. Oracle gives the example ALTER SYSTEM SET LOG_ARCHIVE_CONFIG='DG_CONFIG=(CHICAGO,BOSTON)' and shows the ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE command for selecting a protection mode. Treat CHICAGO and BOSTON as the documentation’s example values, not as values to copy into an unrelated environment.
Oracle documents a condition for changing to MAXIMUM PROTECTION on an open database: the current mode must be MAXIMUM AVAILABILITY and there must be at least one synchronized standby database. This is the kind of prerequisite that should be tested in your notes and lab checklist because it links a command to configuration state.
Configuration and management practice
Practice tracing a requirement through the configuration: identify the protection objective, select a mode, confirm the participating databases, check unique identity values, and validate transport and synchronization. After each exercise, write down which facts were prerequisites and which were outcomes. This creates a troubleshooting model rather than a collection of disconnected procedures.
Do not move straight to complex automation if you cannot explain a basic configuration manually. Automation can hide the reason a setting works. First learn the underlying relationships, then use broker or other administrative tooling as an operational layer and verify what it changed.
Monitoring and optimization practice
Monitoring study should answer three questions: Is redo being transported, is it available to the standby, and is the standby applying it appropriately? Add the distinction between a synchronized standby and one with a redo gap. Oracle’s protection-mode documentation defines a synchronized standby for these descriptions as one meeting the minimum requirements of the configured mode and having no redo gap.
Optimization should be tied to an explicit constraint. If the scenario prioritizes primary performance, examine why maximum performance and asynchronous transport may be appropriate. If it prioritizes protection, examine the acknowledgment and disk-write requirements instead. Never choose a mode solely because its name sounds safest or fastest.
Workload offload and operational use
Oracle associates the certification with workload-offload capabilities available in Data Guard, so include the purpose and trade-offs of using a standby for suitable work in your study map. Connect offload to availability and recovery objectives: using a standby for additional work does not remove the need to preserve its ability to protect or recover the primary.
The Oracle Database 19c Data Guard Administration Workshop is described as teaching use of Data Guard to protect an Oracle database against planned and unplanned downtime. That framing is useful for study design: include both planned operational changes and unplanned failure reasoning, rather than preparing only for initial configuration.
What study materials and lab sequence should you use?
Use Oracle’s 19c Data Guard documentation as the technical reference for protection-mode behavior and the Oracle exam page as the authority for exam facts. If structured instruction suits you, Oracle lists an Oracle Database 19c Data Guard Administration Workshop with a duration of 21 hours and 45 minutes. A course can organize learning, but it should be paired with retrieval practice and hands-on verification.
Read the protection-mode documentation slowly once, then revisit it while building your own decision notes. The important material is not only the definition of each mode; it includes acknowledgment behavior, synchronized standby requirements, redo transport attributes, the response to standby failure, and the conditions for changing a mode.
Keep a source-linked error log. For every missed practice item, record the requirement in the scenario, the fact that determined the answer, the option you selected, and the reason the other plausible options fail. This is especially effective for questions that contrast maximum availability with maximum protection or SYNC/AFFIRM with SYNC/NOAFFIRM.
A four-stage preparation roadmap
Stage one is orientation. Confirm the current official exam page, read the stated audience and knowledge areas, and list your experience in administration, Data Guard, monitoring, recovery, and workload offload. Do not schedule yet if the terminology itself is unfamiliar; first establish the architecture and vocabulary.
Stage two is technical foundation. Study the three protection modes, redo transport, synchronization, redo gaps, database identity, and the relationship between configuration and failure behavior. Create diagrams and decision tables in your own words. At the end of this stage, you should be able to explain why a setting satisfies a requirement.
Stage three is controlled practice. Build or use a suitable Oracle 19c learning environment if available to you, follow documented procedures, and deliberately test assumptions. Practice changing modes only when the documented prerequisites are satisfied. Record what you checked before and after each action.
Stage four is exam rehearsal. Use legitimate practice material that tests understanding, not leaked or memorized questions. Work under the published 120-minute duration when you are ready, review every error by knowledge area, and return to documentation for unresolved points. Schedule only when your results are stable and your weak areas have a specific correction plan.
How to divide study time
Do not divide time by an invented percentage blueprint. The supplied research names the domains but provides no official domain weights. Instead, allocate time according to risk: give more sessions to topics you have not administered, topics where your error log shows repeated confusion, and topics involving competing priorities or failure consequences.
A candidate with strong Data Guard operations may need focused review of exam wording, syntax prerequisites, and workload offload. A candidate with broad database-administration experience but little Data Guard practice may need the reverse: more time building and observing a configuration before attempting timed questions.
Which mistakes commonly weaken preparation?
The most damaging mistake is memorizing mode names without understanding the failure behavior attached to them. Other common problems include confusing receipt with disk persistence, ignoring the synchronized-standby condition, copying example identifiers, and treating a practice score as proof of readiness. Correct these by requiring every answer to include a technical reason.
Do not assume maximum protection is always the right answer because it sounds strongest. Oracle’s description makes clear that it can shut down the primary rather than permit unprotected transactions. The right choice depends on the stated availability, performance, and data-protection requirements.
Do not assume maximum availability guarantees the same behavior in every outage. Oracle documents that if the primary cannot receive acknowledgment from at least one synchronized standby, it operates as if in maximum performance mode to preserve primary availability. That fallback behavior is central to the distinction between modes.
Do not collapse SYNC/AFFIRM and SYNC/NOAFFIRM into one idea. The former includes acknowledgment that redo has been written to disk at the standby; the latter acknowledges receipt without that disk-write confirmation. Their protection and performance consequences differ.
Do not treat a command as valid without checking the state in which it is being executed. Oracle’s documented condition for setting MAXIMUM PROTECTION on an open database is an example of why prerequisites matter. Before choosing a command-based answer, identify the current mode and synchronization state.
Do not rely on unofficial question dumps or leaked content. They do not build the administration judgment the certification is intended to validate, and memorization cannot guarantee a passing result. Use documentation, a lawful course or lab, and original practice focused on concepts and scenarios.
Do not spend every session reading passively. After each technical topic, close the reference and explain the behavior from memory, draw the transport path, or solve a requirement-based scenario. Retrieval exposes uncertainty earlier than repeated highlighting.
A correction loop for missed questions
For each error, first label the failure: terminology, prerequisite, transport behavior, protection-mode trade-off, monitoring interpretation, or careless reading. Then locate the supporting Oracle documentation, rewrite the rule in plain language, and solve a new scenario that changes one condition. Repeat until you can explain why the tempting alternative is wrong.
This loop is more useful than simply increasing the number of questions attempted. It converts a wrong answer into a decision rule that can transfer to a differently worded scenario without relying on recalled question text.
How can you judge readiness before scheduling?
Schedule only after you can explain the major Data Guard decisions without consulting notes and can apply them to unfamiliar scenarios. Readiness should combine technical understanding, timed practice, and current administrative confirmation from Oracle; no single practice score proves that you are ready.
Use this final review checklist: explain the purpose of the three protection modes; distinguish availability, performance, and protection priorities; describe what SYNC/AFFIRM confirms; distinguish SYNC/NOAFFIRM; explain why DB_UNIQUE_NAME must be unique; recognize the synchronized-standby and redo-gap conditions; interpret a failure consequence; and describe where workload offload fits operationally.
Confirm the official page’s current exam facts before booking. The supplied research lists multiple choice, 74 questions, 120 minutes, and a 61% passing score, but the official Oracle page should be checked for any current changes to registration, delivery, policies, or other administrative details not established by this research.
If your weak areas are concentrated in configuration syntax, use a lab and documentation. If they are concentrated in scenario interpretation, use comparison tables and timed practice. If they are concentrated in monitoring, work through state and failure examples until you can identify the next verification step rather than guessing from a symptom.
A final week plan
In the final study period, stop expanding into unrelated Oracle subjects. Review your error log, protection-mode table, transport-attribute notes, and prerequisite checklist. Perform a small number of deliberate practice sessions, then spend more time explaining errors than collecting new questions.
Use the last review to verify distinctions that are easy to reverse: maximum availability versus maximum protection, maximum performance versus maximum availability, disk persistence versus receipt acknowledgment, and an unavailable standby versus a synchronized standby. These paired contrasts are more valuable than another broad glossary pass.
On the day before scheduling or final review, check the official Oracle exam page rather than relying on an old catalogue entry or third-party summary. Keep preparation decisions separate from official requirements: your private readiness standard can be stricter, while Oracle’s current page controls the published exam information.
Where should you take the next step?
Begin with Oracle’s exam page to confirm the current 1Z0-076 description and administrative information. Use the Oracle 19c Data Guard protection-mode documentation for the technical rules that drive many configuration and scenario decisions. If you prefer instructor-led structure, evaluate the official Data Guard Administration Workshop against your available time, then reinforce it with lab work and an error log.
Your immediate next action should be concrete: write a one-page comparison of the three modes, identify two topics you cannot yet explain, and choose a lab or documentation session for the first gap. After that, map each remaining weakness to one of Oracle’s named knowledge areas and review it until you can justify a decision, not merely repeat a definition.
Official references
The Oracle exam page is the primary reference for the title, credential, audience, exam format, duration, question count, passing score, validation, and stated knowledge areas. Oracle’s learning page describes the Data Guard Administration Workshop. Oracle’s certification catalogue places the exam in the High Availability section. Oracle’s 19c documentation supplies the detailed protection-mode and redo-transport behavior used in the technical preparation guidance above.
Conclusion
1Z0-076 preparation is strongest when it mirrors the administrator’s real task: choose a protection approach, configure it with the required conditions, monitor its state, and explain what happens when availability, performance, or standby acknowledgment changes. Confirm the current official exam information, build understanding around Oracle’s documented Data Guard behavior, and use labs and error analysis to turn that understanding into reliable decisions. That approach prepares you for the certification without depending on memorized or unauthorized exam content.
Related exams
- 1z0-078 exam — Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration
- 1z0-084 exam — Oracle Database 19c: Performance Management and Tuning
- 1z0-1116-23 exam — Oracle Guided Learning Content Developer Foundations Associate Rel 1
- 1z0-149 exam — Oracle Database 19c: Program with PL/SQL
- 1z0-202 exam — Siebel 8 Consultant Exam
- 1z0-532 exam — Oracle Hyperion Financial Management 11 Essentials