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?

Correct Answer for the Question – 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? is given below

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?(Choose three.)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 database2. (A) Connect to the primary database as the auxiliary database3. 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 client5. Start RMAN and connect to the primary database as target, and to the recovery catalog6. (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

Connect to the primary database as the AUXILIARY.

Catalog the data file copy for RMAN to use on the primary database for restore.

Back up the data file as copy on the standby host to a location on the standby host.

Switch to the data file copy using the RMAN SWITCH command.

Back up the data file as copy on the standby host to a location on the primary host.

Connect to the primary database as the TARGET.

Correct Answer

The Correct Answer for this Question is

Connect to the primary database as the AUXILIARY.
Catalog the data file copy for RMAN to use on the primary database for restore.
Switch to the data file copy using the RMAN SWITCH command.

The answers for the certifications of MNCs could be very tricky to understand. that’s why we have solved and pasted these exam answers here. The Question – 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? has been answered correctly and answers for various other similar questions could be found in the search box of this site.

More about these Exams

These Exam Questions and the order of these questions keep changing. but the answers are obviously same. so if you don’t find a question after another we suggest you search it in the search box and we are sure you’ll find it. you can bookmark this site for Quick access in future.

We hope you found it helpful don’t forget to leave a comment if you feel a need to correct or ask we’re always here to help.

you can find more here at mnccertified

Feel free to contact via comment or email.

Happy Learning

Cheers, Team MNCcertified

Leave a Comment