At ValidExamDumps, we consistently monitor updates to the Oracle 1Z0-066 exam questions by Oracle. Whenever our team identifies changes in the exam questions,exam objectives, exam focus areas or in exam requirements, We immediately update our exam questions for both PDF and online practice exams. This commitment ensures our customers always have access to the most current and accurate questions. By preparing with these actual questions, our customers can successfully pass the Oracle Database 12c: Data Guard Administrator exam on their first attempt without needing additional materials or study guides.
Other certification materials providers often include outdated or removed questions by Oracle in their Oracle 1Z0-066 exam. These outdated questions lead to customers failing their Oracle Database 12c: Data Guard Administrator exam. In contrast, we ensure our questions bank includes only precise and up-to-date questions, guaranteeing their presence in your actual exam. Our main priority is your success in the Oracle 1Z0-066 exam, not profiting from selling obsolete exam questions in PDF or Online Practice Test.
Examine this list of possible steps:
1.Raise the compatibility level on both databases.
2.Restart SQL Apply on the upgraded logical standby database.
3. Start SQL Apply on the old primary database.
4. Perform a Switchover to the logical standby database.
5. Upgrade the logical standby database.
6. Upgrade the old primary database.
Which is the minimum number of steps in the correct order, to perform a rolling release upgrade of a data guard environment using an existing logical standby database and to enable the new functionality?
Execution: Execution of the rolling upgrade has five stages.
Stage 1 (5): The DBMS_ROLLING.START_PLAN procedure starts the execution of the rolling upgrade. This converts the LGM database, the future primary database, to a logical standby and starts the SQL Apply process at the LGM.
Stage 2 (2): You upgrade the database software at the databases that are part of the leading group. You also run the upgrade scripts at the LGM. After this is done, you must restart SQL Apply processes at the LGM database.
Stage 3 (4): After the apply lag reaches a given threshold (set to 10 minutes by default, but can be configured during the specification stage), the DBMS_ROLLING.SWITCHOVER procedure proceeds with the switchover operation. When the switchover is complete, the LGM becomes the primary database.
Stage 4: The LGM is now the primary database running the new database software and the databases in the leading group are protecting it. The TGM is mounted and the databases in the trailing group are still running the older version of the database software. You must prepare the TGM and TGS databases for upgrade by upgrading the database software and re-mounting the databases on the higher version binaries.
Stage 5 (3, 6): Execute the DBMS_ROLLING.FINISH_PLAN procedure at the current primary database (originally the LGM). It reinstates all the databases in the trailing group to become the standbys of the current primary database, and restarts the apply processes. The FINISH_PLAN procedure waits for all databases in the trailing group to be upgraded to the new release (although the database software for the trailing group databases was changed in Stage 4, the data dictionary of the trailing group databases, except for any logical standbys in the trailing group, are updated based on media recovery of the redo generated during the upgrade at the LGM database).
Note: To upgrade the database software in an Oracle Data Guard configuration in a rolling fashion, you first designate a physical standby as the future primary database.
Conceptually, the rolling upgrade process splits the Oracle Data Guard configuration into two groups: the leading group (LG) and the trailing group (TG).
Databases in the leading group are upgraded first; hence the name leading group. The leading group contains the designated future primary database, and the physical standbys that you can configure to protect the designated future primary. The future primary is first converted into a logical standby database and then the new database software is installed on it and the upgrade process is run. Other standby databases in the leading group also must have their software upgraded at this point.
References:
https://docs.oracle.com/database/121/SBYDB/dbms_rolling_upgrades.htm
Which two are true concerning the configuring of Flashback database in a Data Guard environment? (Choose two.)
Examine the Data Guard configuration:
DGMGRL> show configuration;
Configuration -- Animals
Protection Mode: MaxAvailability
Databases:
dogs - Primary database
sheep - (*) Physical standby database
cats - Physical standby database
Fast-Start Failover: ENABLED
Configuration Status:
SUCCESS
What happens if you issue ''switchover'' to sheep;'' at the DGMGRL prompt?
Examine the Data Guard configuration:
DGMGRL> show configuration;
Configuration Animals
Protection Mode: MaxAvailability
Databases:
dogs Primary database
dogsfs1 Far Sync
sheep Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
An attempt to enable fast-start failover raises an error:
DGMGRL> enable fast_start failover;
Error: ORA-16693: requirements not met for enabling fast-start failover
Failed.
Identify two possible reasons for this error. (Choose two.)
D: Ensure that the LogXptMode property for both the primary database and the Fast-Start Failover target standby database are SYNC.
A: If more than one physical or logical standby database exists, in this case it is the sheep database, you must specify the FastStartFailoverTarget value explicitly, prior to enabling fast-start failover. The indicated target is verified when fast-start failover is enabled.
Note: DGMGRL> enable fast_start failover;
Error: ORA-16651: requirements not met for enabling fast-start failover
Failed.
SOLUTION
1) Check whether the flashback database is enabled on primary & standby database
Select flashback_on from gv$database;
2) Check whether you have set the FastStartFailoverTarget parameter.
References:
https://docs.oracle.com/cd/E11882_01/server.112/e40771/dbpropref.htm#DGBKR862
http://psoug.org/oraerror/ORA-16651.htm
Which three are true concerning Automatic Block Media Recovery in a Data Guard environment when running an application as an ordinary Oracle user? (Choose three.)
B: For automatic block media recovery to work, a physical standby database must be in real-time query mode, which requires an Oracle Active Data Guard license.
D: A physical standby database operating in real-time query mode can be used to repair corrupt data blocks in a primary database.
C: If corruption occurs on the primary database, blockmedia recovery is performed automatically using a good copy of the block from the standby database and vice versa.
References:
https://ora600tom.wordpress.com/2013/09/07/abmr-automatic-block-media-recovery/
