Exam 1z0-066 topic 1 question 82 discussion

Actual exam question from Oracle's 1z0-066

Question #: 82
Topic #: 1

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?

A. Connect to the primary database as the AUXILIARY.
B. Catalog the data file copy for RMAN to use on the primary database for restore.
C. Back up the data file as copy on the standby host to a location on the standby host.
D. Switch to the data file copy using the RMAN SWITCH command.
E. Back up the data file as copy on the standby host to a location on the primary host.
F. Connect to the primary database as the TARGET.

Show Suggested Answer

Suggested Answer: ABD 🗳️
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

by Kamaelk at Jan. 21, 2020, 9:48 a.m.

Comments

Submit Cancel

JESUSBB

2 years, 5 months ago

Answer: B, D y F

upvoted 1 times

...

Rogazan

3 years, 6 months ago

The question says "after the file has been backed up using RMAN on the physical standby database", therefore, I think that we only have to do the part in the primary, that is: Connect the primary as target (answer F). Catalog the datafile to use in the primary (answer B). Apply it in the primary using RMAN SWITCH (answer D)

upvoted 2 times

...

Kamaelk

5 years ago

This is old fashioned method for 11g. From 12c we can use restore/recover from service. And i believe, this question would be absent in exam.

upvoted 2 times

...

Exam 1z0-066 All Questions

View all questions & answers for the 1z0-066 exam

Exam 1z0-066 topic 1 question 82 discussion

Comments

JESUSBB

Rogazan

Kamaelk

SY0-701