Get Oracle 1Z0-066 Exam Dumps

Answer : B

If STANDBY_MAX_DATA_DELAY is set to 0, a query issued to a physical standby database is guaranteed to return the exact same result as if the query were issued on the primary database, unless the standby database is lagging behind the primary database, in which case an ORA-3172 error is returned.

Real-time Query Restrictions include:

The standby database must receive redo data via the SYNC transport.

Note: In an Active Data Guard environment, this session parameter can be used to specify a session-specific apply lag tolerance, measured in seconds, for queries issued by non-administrative users to a physical standby database that is in real-time query mode.

Answer : A, B, D

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

Answer : B, C

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.

Answer : B

Sheep is the Physical standby database.

Error cause: The broker rejects an attempt to change the configuration's overall protection mode since it could not find any online, enabled standby databases that support the proposed protection mode.

Action: If changing the overall protection mode, confirm that at least one standby database satisfies the new protection mode.

Answer : A, B, C