ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-066 All Questions

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

Exam 1z0-066 topic 1 question 14 discussion

Actual exam question from Oracle's 1z0-066
Question #: 14
Topic #: 1
[All 1z0-066 Questions]

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?

  • A. Recover the datafile by using the RMAN RECOVER DATAFILE command
  • B. Restart the redo apply.
  • C. Restore the datafile by using the RMAN RESTORE DATAFILE command.
  • D. Stop the redo apply.
  • E. Recover the database by using the RMAN RECOVER DATABASE command.
Show Suggested Answer Hide Answer
Suggested Answer: CDE 🗳️
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
by Kamaelk at Oct. 14, 2019, 11:01 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Kamaelk
Highly Voted 5 years, 3 months ago
Right answer is D,C,B. RECOVER DATABASE;-- Not nead to do this
upvoted 6 times
...
hilaire
Most Recent 1 year, 2 months ago
BCD correct
upvoted 1 times
...
ScottL
1 year, 3 months ago
Selected Answer: BCD
Answer B,C,D
upvoted 1 times
...
JESUSBB
2 years, 5 months ago
Answer: B, C y D
upvoted 3 times
...
Sugar
3 years, 3 months ago
yes i agree. as per Oracle data guard best pratices, when it comes to datafile only, there is no need to recover database.
upvoted 1 times
Sugar
3 years, 3 months ago
actually this should be 4 steps 1. stop redo 2. recover datafile 3. restore datafile 4. start redo or restart redo
upvoted 1 times
...
...
ra2020
4 years, 8 months ago
E is not required, only you need is stop, restore and start to apply the redolog shipped to the standby. Right answare: B, C & D
upvoted 3 times
...
SaguSe7en
5 years, 2 months ago
Agreed with Kamaelk, As per Oracle 12c, we only need to stop Redo Apply , restart db in mount state and connect to RMAN catalog, restore data file and then restart redo apply.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago