Use the best ways of preparing for 1Z0-066 Exam Dumps with DumpsQuestion Oracle 1Z0-066 dump PDF [2021]
Oracle 1Z0-066 exam candidates will surely pass the Exam if they consider the 1Z0-066 dumps learning material presented by DumpsQuestion.
NEW QUESTION 29
Your Data Guard environment consists of these components and settings:
1. A primary database
2. Two remote physical standby databases
3. The redo transport mode is set to SYNC.
4. Real-time query is enabled for both standby databases.
5. The DB_BLOCK_CHECKING parameter is set to TRUE on both standby databases.
You notice an increase in redo apply lag time on both standby databases.
Which two would you recommend to reduce the redo apply lag on the standby databases? (Choose two.)
- A. Increase the number of standby redo log files on the standby databases.
- B. Decrease the redo log file size on the primary database.
- C. Increase the size of standby redo log files on the standby databases.
- D. Lower DB_BLOCK_CHECKING to MEDIUM or LOW on the standby databases.
- E. Increase the size of the buffer cache on the physical standby database instances.
Answer: D,E
Explanation:
Explanation
Use Data Guard Redo Apply Best Practices
To improve the Redo Apply rate of a physical standby database (and media recovery):
* Set DB_CACHE_SIZE to a Value Greater than on the Primary Database
* Set DB_BLOCK_CHECKSUM=FULL and DB_BLOCK_CHECKING=MEDIUM or FULL
* Maximize I/O Rates on Standby Redo Logs and Archived Redo Logs
* Assess Recovery Rate
* Assess Database Wait Events
* Tune I/O Operations
* Assess System Resources
References: https://docs.oracle.com/database/121/HABPT/config_dg.htm#HABPT4904
NEW QUESTION 30
Your Data Guard environment consists of these components and settings:
1. A primary database supporting an OLTP workload
2. A remote physical standby database
3. Real-time query is enabled
4. The redo transport mode is set to SYNC.
5. The protection mode is set to Maximum Availability.
Which two are true regarding the DelayMins Database Property for the standby database? (Choose two.)
- A. It allows logical corruptions on the primary to be recovered by using the physical standby database.
- B. It specifies a delay before the primary ships redo to the standby destination having DelayMins set.
- C. It allows user errors on the primary to be recovered by using the physical standby database.
- D. It can only be enabled for a configuration in Maximum Performance mode.
- E. It enables you to bypass the default network timeout interval specified for the standby redo transport destination.
- F. It can only be enabled for a configuration in Maximum Availability mode.
Answer: B,C
Explanation:
F: The DelayMins configurable database property specifies the number of minutes log apply services will delay applying the archived redo log data on the standby database.
References: https://docs.oracle.com/cd/E11882_01/server.112/e40771/dbpropref.htm#DGBKR855
NEW QUESTION 31
You created a physical standby database PRODSBY1 from the primary database PROD using SQL and RMAN.
Which two are prerequisites for creating a Data Guard Broker configuration to manage these databases?
(Choose two.)
- A. The primary database must have FORCE LOGGING enabled.
- B. The standby database must have supplemental logging enabled.
- C. A local net service name to enable connectivity to the PRODSBY1 database instance must be defined on the primary database host.
- D. The primary database must have supplemental logging enabled.
- E. The DG_BROKER_START parameter must be set to TRUE for both database instances.
Answer: A,E
Explanation:
B: Enabled forced logging on the primary database by issuing the following command.
ALTER DATABASE FORCE LOGGING;
-- Make sure at leat one logfile is present.
ALTER SYSTEM SWITCH LOGFILE;
C: Enable Broker
When we have a primary database and a standby database, we need to start using the Data Guard Broker to manage them. Connect to both databases (primary and standby) and issue the following command.
ALTER SYSTEM SET dg_broker_start=true;
References: https://oracle-base.com/articles/12c/data-guard-setup-using-broker-12cr1
NEW QUESTION 32
Which two statements are true for Data Guard environments with multi-tenant databases?
- A. Each pluggable database within a multi-tenant physical standby database has a minimum of one
associated Oracle Net service name. - B. A pluggable database within a multi-tenant standby database can have a different open mode than the
container database - C. A pluggable database within a multi-tenant standby database can have a different database role than
the container database. - D. Each pluggable database within a multi-tenant physical standby has one MRP background process
running during redo apply. - E. DB_UNIQUE_NAME must be specified differently for each pluggable database within a multitenant
standby database.
Answer: B,E
NEW QUESTION 33
You must use a physical standby database file to recover a data file on a primary database in a Data Guard environment.
Which three of these steps must be performed on the primary database after the file has been backed up using RMAN on the physical standby database? (Choose three.)
- A. Catalog the data file copy for RMAN to use on the primary database for restore.
- B. Switch to the data file copy using the RMAN SWITCH command.
- C. Connect to the primary database as the TARGET.
- D. Back up the data file as copy on the standby host to a location on the primary host.
- E. Back up the data file as copy on the standby host to a location on the standby host.
- F. Connect to the primary database as the AUXILIARY.
Answer: A,B,F
Explanation:
Explanation
You can use files on a standby database to recover a lost datafile.
Start RMAN and take the following steps to copy the datafiles from the standby to the primary:
1. Connect to the standby database as the target database
2. (A) Connect to the primary database as the auxiliary database
3. Back up the datafile on the standby host across the network to a location on the primary host. (This step, E, is assumed to have been taken already).
4. Exit the RMAN client
5. Start RMAN and connect to the primary database as target, and to the recovery catalog
6. (B, D) Use the CATALOG DATAFILECOPY command to catalog this datafile copy so that RMAN can use it.
CATALOG DATAFILECOPY '/disk9/df2copy.dbf';
Then use the SWITCH DATAFILE command to switch the datafile copy so that /disk9/df2copy.dbf becomes the current datafile:
RUN {
SET NEWNAME FOR DATAFILE 2 TO '/disk9/df2copy.dbf';
SWITCH DATAFILE 2;
}
References: https://docs.oracle.com/cd/E11882_01/server.112/e41134/rman.htm#SBYDB4870
NEW QUESTION 34
Which two statements are true regarding Data Guard Broker? (Choose two.)
- A. It can be used to create and manage standby databases.
- B. It automatically starts the DMON process for the database instances that are part of a Data Guard configuration.
- C. It can be used to monitor redo transport and log apply services.
- D. It can be used to perform failovers and switchovers.
- E. It automatically adds the primary database to an existing broker configuration when Enterprise Manager Cloud Control is used to create a standby.
Answer: B,D
Explanation:
B: The Data Guard monitor process (DMON) is an Oracle background process that runs for every database instance that is managed by the broker. When you start the Data Guard broker, a DMON process is created.
C: The following list describes some of the operations the broker automates and simplifies:
* Invoking switchover or failover with a single command to initiate and control complex role changes across all databases in the configuration.
Etc.
Incorrect Answers:
E: Oracle Enterprise Manager works with the Data Guard monitor to automate and simplify the management of a Data Guard configuration including:
* Performance tools and graphs that help you monitor and tune redo transport services and log apply services.
References: https://docs.oracle.com/cd/B28359_01/server.111/b28295/concepts.htm
NEW QUESTION 35
Your Data Guard environment consists of these components and settings:
1. A primary database supporting an OLTP workload
2. A remote physical standby database
3. Real-time query is enabled
4. The redo transport mode is set to SYNC.
5. The protection mode is set to Maximum Availability.
Which two are true regarding the DelayMins Database Property for the standby database? (Choose two.)
- A. It allows logical corruptions on the primary to be recovered by using the physical standby database.
- B. It specifies a delay before the primary ships redo to the standby destination having DelayMins set.
- C. It allows user errors on the primary to be recovered by using the physical standby database.
- D. It can only be enabled for a configuration in Maximum Performance mode.
- E. It enables you to bypass the default network timeout interval specified for the standby redo transport destination.
- F. It can only be enabled for a configuration in Maximum Availability mode.
Answer: B,C
Explanation:
Explanation
F: The DelayMins configurable database property specifies the number of minutes log apply services will delay applying the archived redo log data on the standby database.
References: https://docs.oracle.com/cd/E11882_01/server.112/e40771/dbpropref.htm#DGBKR855
NEW QUESTION 36
Which three are true about the rolling release upgrade method for Data Guard environments using a transient Logical Standby database? (Choose three.)
- A. The original primary database can ship redo to any standby database that is part of the Data Guard configuration during the rolling release upgrade process.
- B. The transient logical standby database used for the rolling release upgrade can run with a newer version of the Oracle software than the primary database.
- C. SELECT GUARD_STATUS FROM V$DATABASE; must return NONE as a prerequisite for the rolling release upgrade with a transient logical standby database.
- D. A rolling release upgrade can be performed with the Data Guard environment in any protection mode.
- E. The transient logical standby database used for the rolling release upgrade must have the same DBID as the primary database.
Answer: A,B,C
NEW QUESTION 37
A customer has these requirements for their potential Data Guard implementation:
1. Zero data loss must still be guaranteed through the loss of any one configuration component.
2 The primary database must be protected against a regional disaster
3 . Performance overheads on the primary should be minimized as much as possible given these requirements.
4. Downtime on the primary database for any reason must be kept to a minimum.
Components referred to in the broker commands are:
Which Data Guard broker commands are needed to implement these requirements?
- A. EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: physt1,
FASTSYNC)'; EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: fs1
SYNC)'; EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES=' (pnma: physt2 SYNC)';
EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY - B. EDIT DATABASE prima SET PROPERY REDOROUTES^' (LOCAL: fs1 SYNC)'; EDIT
FAR_SYNCfs1 SET PROPERTY REDORUOTES=' (prima physt ASYNC)'; EDIT
CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY; - C. EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: physt1,
FASTSYNC)'; EDIT DATABASE prima SET PROPERY REDOROUTES= (LOCAL: fs1.
FASTSYNC)'; EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES=' (prima: physt2
ASYNC)'; EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY; - D. EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: fs1 ASYNC)'; EDIT
FAR_SYNC fs1 SET PROPERTY REDORUOTES=' (prima physt FASTSYNC)'; EDIT
CONFIGURATION SET PROTECTION MODE AS MAXPROTECTION
Answer: A
NEW QUESTION 38
After converting your physical standby database to a logical database, you get an error:
How can you rectify the error?
- A. Reinstate the physical standby database PRODSBY as a logical standby, thereby replacing the physical standby database metadata in the broker configuration.
- B. Reinstate both the primary and physical standby databases The broker will automatically detect that PRODSBY is a logical standby update to the metadata.
- C. Add a logical standby database PRODSBY and enable it, thereby replacing the physical standby database metadata in the broker configuration.
- D. Remove the physical standby database PRODSBY from the broker configuration, add a logical standby database PRODSBY to the broker configuration and enable it.
Answer: B
NEW QUESTION 39
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. 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.
- B. 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. 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.
- D. 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.
Answer: D
NEW QUESTION 40
Your Data Guard environment consists of these components and settings:
1. A primary database
2. Two remote physical standby databases
3. The redo transport mode is set to SYNC.
4. Real-time query is enabled for both standby databases.
5. The DB_BLOCK_CHECKING parameter is set to TRUE on both standby databases.
You notice an increase in redo apply lag time on both standby databases.
Which two would you recommend to reduce the redo apply lag on the standby databases? (Choose two.)
- A. Increase the number of standby redo log files on the standby databases.
- B. Decrease the redo log file size on the primary database.
- C. Increase the size of standby redo log files on the standby databases.
- D. Lower DB_BLOCK_CHECKING to MEDIUM or LOW on the standby databases.
- E. Increase the size of the buffer cache on the physical standby database instances.
Answer: D,E
Explanation:
Use Data Guard Redo Apply Best Practices
To improve the Redo Apply rate of a physical standby database (and media recovery):
* Set DB_CACHE_SIZE to a Value Greater than on the Primary Database
* Set DB_BLOCK_CHECKSUM=FULL and DB_BLOCK_CHECKING=MEDIUM or FULL
* Maximize I/O Rates on Standby Redo Logs and Archived Redo Logs
* Assess Recovery Rate
* Assess Database Wait Events
* Tune I/O Operations
* Assess System Resources
References: https://docs.oracle.com/database/121/HABPT/config_dg.htm#HABPT4904
NEW QUESTION 41
Which three are true concerning database states after a successful switchover? (Choose three.)
- A. If the former primary database became a logical standby database it will be in mount state.
- B. If the former primary database became a logical standby database it will be open read-write.
- C. The new primary database will be open read-write.
- D. If the former primary database became a physical standby database it will be in the same state as the former physical standby database.
- E. If the former primary database became a physical standby database it will always be open read-only.
- F. The former primary database will always be open.
Answer: A,C,E
Explanation:
Explanation/Reference:
References: https://docs.oracle.com/database/121/SBYDB/pre12_role_trans.htm#SBYDB5212
NEW QUESTION 42
Examine the Data Guard configuration:
DGMGRL> show configuration;
Configuration -Animals Protection Mode MaxAvailability
Databases
dogs- Primary database
cats- Snapshot standby database
sheep- Snapshot standby database
Fast-Start Failover DISABLED
Configuration Status: ORA-01034: ORACLE not available ORA-16625: cannot reach database "dogs'1
DGM-17017 unable to determine configuration status
You wish to perform a failover to Sheep
Which command, or sequence of commands, should you issue to the broker before executing "failover to
sheep", using the broker?
- A. DGMGRL> convert database sheep to physical standby;
- B. None, because you can directly failover to a Snapshot Standby Database
- C. DGMGRL> convert database cats to physical standby,
- D. DGMGRL> convert database sheep to physical standby; DGMGRL> convert database cats to physical
standby; - E. DGMGRL>edit configuration set protection mode as maxperformance; DGMGRL> convert database
sheep to physical standby;
Answer: D
NEW QUESTION 43
You must configure an Oracle Data Guard environment consisting of:
1. A primary database
2. One Physical Standby Database
3. One Logical Standby Database
You must meet these requirements:
1. Primary database availability should not be compromised by the availability of the standby databases.
2. Under normal operations, transactions executed on the primary database should not commit before redo is written to disk on both the primary database and at least one standby database.
Which redo transport mode and which protection mode would you configure to meet these requirements?
- A. SYNC AFFIRM and Maximum Availability
- B. SYNC NOAFFIRM and Maximum Protection
- C. SYNC NOAFFIRM and Maximum Availability
- D. ASYNC and Maximum Performance
- E. SYNC AFFIRM and Maximum Protection
Answer: A
Explanation:
Explanation/Reference:
Explanation:
The Maximum Availability protection mode provides the highest level of data protection that is possible without compromising the availability of a primary database. Transactions do not commit until all redo data needed to recover those transactions has been written to the online redo log and to at least one synchronized standby database. If the primary database cannot write its redo stream to at least one synchronized standby database, it operates as if it were in maximum performance mode to preserve primary database availability until it is again able to write its redo stream to a synchronized standby database.
This mode ensures that no data loss will occur if the primary database fails, but only if a second fault does not prevent a complete set of redo data from being sent from the primary database to at least one standby database.
When a transport is performed using SYNC/AFFIRM, the primary performs write operations and waits for acknowledgment that the redo has been transmitted synchronously to the physical standby and written to disk. A SYNC/AFFIRM transport provides an additional protection benefit at the expense of a performance impact caused by the time required to complete the I/O to the standby redo log.
Incorrect Answers:
D: In the case of SYNC/NOAFFIRM, in which there is no check that data has been written to disk on the standby, there may be some data loss.
A, B: The Maximum Protection mode ensures that zero data loss occurs if a primary database fails. To provide this level of protection, the redo data needed to recover a transaction must be written to both the online redo log and to at least one synchronized standby database before the transaction commits. To ensure that data loss cannot occur, the primary database will shut down, rather than continue processing transactions, if it cannot write its redo stream to at least one synchronized standby database.
Because this data protection mode prioritizes data protection over primary database availability, Oracle recommends that a minimum of two standby databases be used to protect a primary database that runs in maximum protection mode to prevent a single standby database failure from causing the primary database to shut down.
E: The Maximum Performance protection mode provides the highest level of data protection that is possible without affecting the performance of a primary database. This is accomplished by allowing transactions to commit as soon as all redo data generated by those transactions has been written to the online log. Redo data is also written to one or more standby databases, but this is done asynchronously with respect to transaction commitment, so primary database performance is unaffected by delays in writing redo data to the standby database(s).
This protection mode offers slightly less data protection than maximum availability mode and has minimal impact on primary database performance.
This is the default protection mode.
References: https://docs.oracle.com/cd/B28359_01/server.111/b28294/protection.htm
NEW QUESTION 44
A query on the view DBA_LOGSTDBY_UNSUPPORTED on your primary database returns several rows.
As a result of this, you decide that an upgrade may not use logical standby databases.
Which three are true about upgrading Data Guard environments consisting of one physical standby database running on a separate host from the primary?
- A. Redo Apply on the standby database must be stopped while the primary database is upgraded.
- B. The upgrade requires downtime until the upgrade of the standby is completed.
- C. Fast-Start Failover can be used to protect the primary database during the upgrade.
- D. With manual upgrade, catupgrd.sq1 can be executed on the primary and standby databases simultaneously.
- E. The new release of the Oracle Software must be installed on both the primary and standby database hosts.
- F. The broker must be disabled during the upgrade.
- G. The upgrade requires downtime until the upgrade of the primary is completed.
Answer: E,F,G
Explanation:
Explanation/Reference:
B: Disable the broker's management of the configuration and then stop the broker.
E: On the primary database install the newer release of the Oracle software, and on the logical standby database, install the newer release of the Oracle software.
Incorrect Answers:
C: Oracle Database 12c introduces a new command-line upgrade utility (catctl.pl). This utility replaces the catupgrd.sql script used to upgrade to previous releases of Oracle Database. The new command-line upgrade utility enables parallel processing during the database upgrade, resulting in better upgrade performance and reduced database downtime.
G: Disable fast-start failover if it is enabled.
References:
https://docs.oracle.com/database/121/SBYDB/upgrades.htm
https://docs.oracle.com/database/121/DGBKR/upgrade_appx.htm#DGBKR1212
NEW QUESTION 45
Examine this query and its output:
Which are true?
- A. The observer is currently running on o17.example com
- B. The observer is not running, but should run on o17 example.com.
- C. The observer is connected to the database on which the query was executed.
- D. Cats is a bystander database.
- E. The observer is not connected to the database on which the query was executed.
Answer: E
NEW QUESTION 46
Which two are prerequisites for configuring flashback database for Oracle 12c databases, in a Data Guard environment? (Choose two.)
- A. A flash recovery area must be configured.
- B. A far sync instance must be configured to flash back a standby when the primary has been flashed back.
- C. The Data Guard Broker must be used.
- D. The database must be in MOUNT state.
- E. The database must be in ARCHIVELOG mode.
Answer: A,E
Explanation:
Configure the following database settings before enabling Flashback Database:
You must have a fast recovery area enabled, because flashback logs can only be stored in the fast recovery area.
Your database must be running in ARCHIVELOG mode, because archived logs are used in the Flashback Database operation.
For Oracle Real Application Clusters (Oracle RAC) databases, the fast recovery area must be in a clustered file system or in ASM.
Reference: https://docs.oracle.com/database/121/BRADV/flashdb.htm#BRADV582
NEW QUESTION 47
Attempting to start the observer raises an error:
DGMGRL> start observer:
DGM-16954: Unable to open and lock the Observer configuration file Failed.
Identify two possible reasons for this error.
- A. Fast-Start Failover is not yet enabled for this Data Guard configuration.
- B. There is already an observer running for this Data Guard configuration.
- C. The broker configuration has not yet been created.
- D. There is another observer running for a Data Guard configuration which uses the same observer configuration file.
- E. The observer configuration file is marked read-only.
Answer: D,E
Explanation:
Explanation/Reference:
Error code: DGM-16954
Description: Unable to open and lock the Observer configuration file
Cause: The Observer configuration file cannot be opened or cannot be locked for exclusive access.
Action: Make sure the Observer has the correct operating system privileges to write the file and there is no other Observer that is using the same file. Try the command again.
References: https://www.oraexcel.com/oracle-12cR1-DGM-16954
NEW QUESTION 48
You must manually reinstate a database using DGMGRL
To which database should you connect with DGMGRL before issuing the REINSTATE command and in which state should the target database be?
- A. The target database should be MOUNTED and DGMGRL should be connected to the target database
- B. The target database should be MOUNTED and DGMGRL should be connected to any database that is a member of the configuration
- C. The target database should be MOUNTED and DGMGRL should be connected to the primary database.
- D. The target database should be in NOMOUNT state and DGMGRL should be connected to any database that is a member of the configuration
- E. The target database should be in NOMOUNT state and DGMGRL should be connected to the primary database
Answer: C
NEW QUESTION 49
Attempting to start the observer raises an error:
DGMGRL> start observer:
DGM-16954: Unable to open and lock the Observer configuration file Failed.
Identify two possible ways to start the observer successfully. (Choose two.)
- A. Set the Observer Override property to TRUE before starting the observer.
- B. Enable Fast-Start Failover before starting the observer.
- C. Create a broker configuration and enable Fast-Start Failover before starting the observer.
- D. Start the observer using a different observer configuration file.
- E. Start the observer in a different working directory.
Answer: D,E
Explanation:
Explanation/Reference:
Explanation:
Error code: DGM-16954
Description: Unable to open and lock the Observer configuration file
Cause: The Observer configuration file cannot be opened or cannot be locked for exclusive access.
Action: Make sure the Observer has the correct operating system privileges to write the file and there is no other Observer that is using the same file. Try the command again.
References: https://www.oraexcel.com/oracle-12cR1-DGM-16954
NEW QUESTION 50
......
Accurate & Verified Answers As Seen in the Real Exam here: https://www.dumpsquestion.com/1Z0-066-exam-dumps-collection.html