Download Oracle Database 12c: Data Guard Administration.1z0-066.BrainDumps.2018-12-19.55q.tqb

Vendor: Oracle
Exam Code: 1z0-066
Exam Name: Oracle Database 12c: Data Guard Administration
Date: Dec 19, 2018
File Size: 869 KB
Download Exam

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAM_HUB

Discount: 20%

ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator

Demo Questions

Question 1
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?
  1. The switchover succeeds but Dogs need to be reinstated.
  2. The switchover succeeds but Fast-Start Failover is suspended.
  3. The switchover succeeds and Cats become the new failover target.
  4. The switchover succeeds and Dogs become the new failover target.
  5. It results in an error indicating that a switchover is not allowed.
Correct answer: D
Explanation:
Incorrect Answers:E: NOT ALLOWED - Either this is a standby database and the primary database has not been switched first, or this is a primary database and there are no standby databases.
Incorrect Answers:
E: NOT ALLOWED - Either this is a standby database and the primary database has not been switched first, or this is a primary database and there are no standby databases.
Question 2
A data file on one of your physical standby databases has been accidentally deleted and you must restore and recover it. 
All the archive logs required for recovery are still on disk in the directory pointed to by the log_archive_dest_1 parameter. 
Which three steps must be performed to restore the missing file and recover the standby database while it is in the MOUNT state? (Choose three.)
  1. Recover the datafile by using the RMAN RECOVER DATAFILE command
  2. Restart the redo apply.
  3. Restore the datafile by using the RMAN RESTORE DATAFILE command.
  4. Stop the redo apply.
  5. Recover the database by using the RMAN RECOVER DATABASE command.
Correct answer: CDE
Explanation:
Recovery from Loss of Datafiles on the Standby Database 1. Connect SQL*Plus to the standby database. 2. Stop Redo Apply using the SQL ALTER DATABASE ... statement. 3. In a separate terminal, start RMAN and connect to both the standby and recovery catalog databases (use the TARGET keyword to connect to the standby instance). 4. Issue the following RMAN commands to restore and recover datafiles on the standby database:RESTORE DATAFILE <n,m,...>; RECOVER DATABASE; 5. To restore a tablespace, use the RMAN 'RESTORE TABLESPACE tbs_name1, tbs_name2, ...' command. 6. At the SQL*Plus prompt, restart Redo Apply using the SQL ALTER DATABASE ... statement. References: https://docs.oracle.com/cd/E11882_01/server.112/e41134/rman.htm
Recovery from Loss of Datafiles on the Standby Database 
1. Connect SQL*Plus to the standby database. 
2. Stop Redo Apply using the SQL ALTER DATABASE ... statement. 
3. In a separate terminal, start RMAN and connect to both the standby and recovery catalog databases (use the TARGET keyword to connect to the standby instance). 
4. Issue the following RMAN commands to restore and recover datafiles on the standby database:
RESTORE DATAFILE <n,m,...>; 
RECOVER DATABASE; 
5. To restore a tablespace, use the RMAN 'RESTORE TABLESPACE tbs_name1, tbs_name2, ...' command. 
6. At the SQL*Plus prompt, restart Redo Apply using the SQL ALTER DATABASE ... statement. 
References: https://docs.oracle.com/cd/E11882_01/server.112/e41134/rman.htm
Question 3
You administer a Data Guard environment consisting of a primary and three physical standby databases. 
One physical standby database is used for disaster recovery, one is used for reporting, and one is used as a replica for testing. 
The standby database used for testing is occasionally converted into a snapshot standby database and then converted back to a physical standby. 
The physical standby database is the only standby that is a mandatory destination. 
The broker configuration operates in MAXIMUM PERFORMANCE mode. 
Which ARCHIVELOG DELETION POLICY should be set, so that archive logs generated on the primary database are not deleted before they are consumed appropriately on each of the standby databases, but which allows them to be deleted form the primary as soon as it is safe to do so?
  1. CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;
  2. CONFIGURE ACHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
  3. CONFIGURE ACHIVELOG DELETION POLICY TO SHIPPED TO ALL STANDBY;
  4. CONFIGURE ACHIVELOG DELETION POLICY TO SHIPPED TO STANDBY;
  5. CONFIGURE ACHIVELOG DELETION POLICY TO NONE;
Correct answer: B
Explanation:
You can change this default deletion policy using the following RMAN command:CONFIGURE ARCHIVELOG DELETION POLICY TO [CLEAR | NONE | APPLIED ON STANDBY]; Use the APPLIED ON STANDBY clause so that archived redo log files that have been applied on all mandatory standby destinations will be deleted. Incorrect Answers:A: APPLIED ON ALL STANDBY is not valid.C, D: SHIPPED TO is not valid.E: Use the NONE clause so that archived redo logs in flash recovery area that were backed up or obsolete as per the RMAN retention policy are eligible for deletion. This is the default configuration. Archived redo log files that are backed up or obsolete are deleted to make space if the disk space in the flash recovery area becomes full.References: https://docs.oracle.com/cd/B19306_01/server.102/b14239/rman.htm#i1031870
You can change this default deletion policy using the following RMAN command:
CONFIGURE ARCHIVELOG DELETION POLICY TO [CLEAR | NONE | APPLIED ON STANDBY]; 
Use the APPLIED ON STANDBY clause so that archived redo log files that have been applied on all mandatory standby destinations will be deleted. 
Incorrect Answers:
A: APPLIED ON ALL STANDBY is not valid.
C, D: SHIPPED TO is not valid.
E: Use the NONE clause so that archived redo logs in flash recovery area that were backed up or obsolete as per the RMAN retention policy are eligible for deletion. This is the default configuration. Archived redo log files that are backed up or obsolete are deleted to make space if the disk space in the flash recovery area becomes full.
References: https://docs.oracle.com/cd/B19306_01/server.102/b14239/rman.htm#i1031870
CONNECT US
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!