Monday, 30 October 2017

Oracle 1z0-066 Question Answer

Examine the Data Guard configuration:
DGMGRL> show configuration:
Configuration-Animals
Protection Mode: MaxAvailability
Databases:
Sheep- Primary database
Warning: ORA-16817: unsynchronized fast-start failover configuration
Dogs – (*) Physical standby database (disabled)
ORA- 16661: the standby database needs to be reinstated
Fast-Start Failover: ENABLED
Configuration Status:
WARNING
And the fast-start failover configuration:
DGMGRL> show fast_start failover;
Fast-Start Failover: ENABLED
Threshold : 30 seconds
Target: dogs
Observer : 017.example.com
Lag Limit: 30 seconds (not in use)
Shutdown Primary: TRUE
Auto-reinstate: TRUE
Observer Reconnect: 10 seconds
Observer Override: FALSE
Configurable Failover Conditions
Health Conditions:
Corrupted Controlfile YES
Corrupted Dictionary YES
Inaccessible Logfile NO
Stuck Archiver NO
Datafile Offline YES
Oracle error Conditions:
ORA-01578: ORACLE data block corrupted (file # %s, block # %s)
And finally the reason for the fail over:
SQL> select last_failover_reason from v$fs_failover_stats;
LAST_FAILOVER_REASON
ORA-01578: ORACLE data block corrupted (file # %s, block # %s)
Identify the task, or sequence of tasks, to bring the configuration into the SUCCESS state.

A. Bring Dogs to the NOMOUNT state and let the broker reinstate Dogs automatically.
B. MOUNT DOGS and issue “reinstate database dogs:” at the DGMGRL prompt while connected to Dogs.
C. MOUNT DOGS and issue “reinstate database dogs:” at the DGMGRL prompt while connected to Sheep.
D. Open Dogs and let the broker reinstate Dogs automatically.

Answer: C

Thursday, 7 September 2017

Oracle 1z0-066 Question Answer

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=’ (prima: physt2 SYNC)’;
EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;
B. 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
C. EDIT DATABASE prima SET PROPERY REDOROUTES=’ (LOCAL: fs1 SYNC)’;
EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES=’ (prima: physt ASYNC)’;
EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;
D. 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;

Answer: A

Wednesday, 21 June 2017

Oracle 1z0-066 Question Answer

Examine this query and its output:

SQL> select fs_failover_status, fs_failover_current_target,
2 fs_failover_observer_present, fs_failover_oserver_host
3 from v$database:
FS_FAILOVER_STATUS FS_FAILOVER_CURRENT_TARGET
FS_FAILOVER_OBSERVER_PRESENT FS_FAILOVER_OBSERVER_HOST
--------------- ----------------------- ---------------- ------------------
BYSTANDER cats NO
O17.example.com
Which are true?


A. The observer is not connected to the database on which the query was executed.
B. Cats is a bystander database.
C. The observer is connected to the database on which the query was executed.
D. The observer is currently running on o17.example.com.
E. The observer is not running, but should run on o17.example.com.

Answer: A


Which three are true about using RMAN in a Data Guard environment?


A. A recovery catalog is required when RMAN is used to take backups from a logical standby database in a Data Guard configuration if you plan to recover the primary using those backups.
B. Backups of archived redo logs taken on a physical standby are interchangeable with a primary.
C. A recovery catalog is required when RMAN is used to take backups from a physical standby database if you plan to recover the primary using those backups.
D. Backups of control files taken on a physical standby are not interchangeable with a primary.
E. Backups of data files taken on a physical standby are interchangeable with a primary.

Answer: BCE

Thursday, 4 May 2017

Oracle 1z0-066 Question Answer

Which three statements are true about snapshot standby databases?

A. Snapshot standby databases may be used for rolling release upgrades.
B. If datafiles grow while a database is a snapshot standby database, then they shrink when converted back to a physical standby database.
C. Flashback logs are used to convert a snapshot standby database back into a physical standby database.
D. A snapshot standby database can have Real-Time Query enabled.
E. A guaranteed restore point is created automatically when a physical standby database is converted into a snapshot standby database.

Answer: CE


Which three statements are true about Global Sequences when connected to a physical standby database with Real-Time Query enabled?


A. If the CACHE option is set then the size of the cache must be at least 100.
B. Their creation requires that a LOG_ARCHIVE_DEST_n parameter be defined in the standby that points back to their primary.
C. Their usage will always have a performance impact on the primary database.
D. Their usage may have a performance impact on the physical standby database if the CACHE size is too small
E. They must have the NOORDER and CACHE options set.

Answer: BDE

Thursday, 23 February 2017

Oracle 1z0-066 Question Answer

There are currently 6 APPLIER and 6 PREPARER processes running and no idle APPLIER processes on your logical standby database.
The MAX_SERVERS SQL apply parameter and number of archiver processes are both set to 12.
Identify two changes, each of which would allow you to increase the number of APPLIER processes.


A. Increase the PROCESSES initialization parameter
B. Increase the value for the MAX_SERVERS SQL apply parameter.
C. Decrease the number of archiver processes on the standby database.
D. Increase the PARALLEL_MAX_SERVER initialization parameter
E. Decrease the number of PREPARER processes
F. Increase the RECOVERY_PARALLELISM initialization parameter

Answer: BE