1Z0-066 Oracle Database 12c: Data Guard Administration

Oracle Data Guard Basics
Describe the Architecture of Oracle Data Guard
Explain the applicability between physical and logical standby and snapshot databases
Explain the benefits of implementing Oracle Data Guard
Explain Data Guard use with the Oracle Multi-tennant databases

Creating a Physical Standby Database by Using Enterprise Manager Cloud Control
Create a Data Guard broker configuration
Create a physical standby database
Verify a Data Guard configuration
Edit database properties related to Data Guard
Test a Data Guard configuration

Managing Oracle Net Services in a Data Guard Environment
Configure client connectivity in a Data Guard configuration
Implement failover procedures to automatically redirect clients to a new primary database
Using Application Continuity in a Data Guard Environment

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
Create a physical standby database by using the DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE RMAN command

Using Oracle Active Data Guard
Use Real-time Query to access data on a physical standby database
Enable RMAN block change tracking for a physical standby database
Use Far Sync to extend zero data loss protection for intercontinental configurations
Using Temporary Undo. Global Sequences and Session Sequences
Using Automatic Block Media Recovery
Configure Real-Time Cascading

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
Create a logical standby database
Manage SQL Apply filtering

Oracle Data Guard Broker Basics
Describe the Data Guard broker architecture
Describe the Data Guard broker components
Explain the benefits of the Data Guard broker
Describe Data Guard broker configurations

Creating a Data Guard Broker Configuration
Create a Data Guard broker configuration
Manage the Data Guard broker configuration

Monitoring a Data Guard Broker Configuration
Use Enterprise Manager to manage your Data Guard configuration
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 switchover
Perform a failover

Using Flashback Database in a Data Guard Configuration
Configure Flashback Database
Explain the advantages of using Flashback Database in a Data Guard configuration

Enabling Fast-Start Failover
Configure fast-start failover
View information about the fast-start failover configuration
Manage the observer
Perform role changes in a fast-start failover configuration
Manually reinstate the primary database

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
Offload backups to a physical standby database
Recovering databases in a Data Guard Environment
Managing Archive Redo Logs in a Data Guard Environment

Patching and Upgrading Databases in a Data Guard Configuration
Patch and upgrade databases using traditional patch methods
Perform rolling upgrades

Optimizing a Data Guard Configuration
Monitor configuration performance
Optimize redo transport for best performance
Optimize SQL Apply

QUESTION: No: 1
Which two statements are true for Data Guard environments with multi-tenant databases?

A. DB_UNIQUE_NAME must be specified differently for each pluggable database within a multitenant
standby database.
B. Each pluggable database within a multi-tenant physical standby database has a minimum of one
associated Oracle Net service name.
C. Each pluggable database within a multi-tenant physical standby has one MRP background process
running during redo apply.
D. A pluggable database within a multi-tenant standby database can have a different open mode than the
container database
E. A pluggable database within a multi-tenant standby database can have a different database role than
the container database.

Answer: A, D

QUESTION: No: 2
Your Data Guard environment has two remote physical standby databases Client applications use the
local naming method to connect to the primary database instance.
You want applications to automatically connect to the new primary database instance in case of a
switchover or a failover
Which will fulfill this requirement?

A. Create a database service on each standby database that is started automatically by a trigger, when
the database rote is PRIMARY, modify the connection description used by client applications to include all
the standby hosts and connect to the database instance using that service name.
B. Create a database service on the primary database that is started automatically by a trigger, when the
database role is PRIMARY, modify the connection descriptors used by client applications to include all the
standby hosts and connect to the database instance using that service name.
C. Set the INSTANCE_NAME parameter identically on all databases; modify the connection descriptor on
client applications to include all the standby hosts and connect to the database instance using that service
name.c
D. Set the DB_NAME and DB_UNIQUE_NAME identical on all databases, modify the connection
descriptors on client applications to include all the standby hosts and connect to the database using that
service name.

Answer: A

QUESTION: No: 3
Examine the Data Guard configuration:
DGMGRL >show configuration;
Configuration-Animals
Protection Mode MaxPerformance Databases
dogs-Primary database
sheep-Snapshot standby database
cats-Snapshot standby database
Fast-Start Failover: DISABLED
Configuration Status: SUCCESS
You receive an error while attempting to raise the protection mode to Maximum Availability:
DGMGDRL> edit configuration set protection mode as max availability;
Error ORA-16627 operation disallowed since no standby databases would remain to support protection
mode Failed.
Identify two statements that you can execute, either one of which will enable successful raising of the
protection mode to Maximum Availability.

A. DGMGRL> convert database sheep to physical standby;
B. DGMGRL> convert database cats to physical standby;
C. DGMGRL> edit database dogs set property LogXptMode= fastsync;
D. DGMGRL> edit database sheep set property LogXptMode= fastsync;
E. DGMGRL> edit database cats set property LogXptMode= sync;

Answer: B, E

QUESTION: No: 4
You administer a Data Guard environment with a primary and two physical standby databases.
One of the physical standby databases is used for reporting and is on the same host as the primary
database.
The other physical standby database is remote, used for disaster recovery and REDO is routed to it via a
far sync instance.
Backups are offloaded to the remote physical standby.
Which three are true concerning the management of archive logs in this Data Guard configuration?

A. Archive logs on the primary database may be deleted once they are applied on all standby databases.
B. Archive logs on the primary database may be deleted once they are shipped on all standby databases.
C. The deletion policy for archive logs on the remote physical standby should be set so that archived logs
are deleted once they backed up at least once on the remote physical standby database.
D. The deletion policy for archive logs on the remote physical standby should be set so that archived logs
are deleted once they are applied on all standby databases.
E. Archive logs on the primary database may be deleted once they are archived locally to disk.

Answer: A, D, E

QUESTION: No: 5
Which two are prerequisites for configuring flashback database for Oracle 12c databases, in a Data
Guard environment?

A. a flash recovery area must be configured
B. The database must be in MOUNT state.
C. The database must be in ARCHIVELOG mode.
D. A far sync instance must be configured to flash back a standby when the primary has been flashed back.
E. The Data Guard Broker must be used.

Answer: A, C

Click here to view complete Q&A of 1Z0-066 exam
Certkingdom Review