Oracle Exam 1Z0-497 Topic 3 Question 73 Discussion

Actual exam question for Oracle's 1Z0-497 exam

Question #: 73
Topic #: 3

A standby database is in mounted state and you are required to perform a failover to the physical standby. Which solution is best suited forthis scenario?

AALTER DATABASE RECOVER MANAGED STANDBY DATABASE statement with the FINISH keyword

BALTER DATABASE PREPARE TO SWITCHOVER and ALTER DATABASE COMMIT TO SWITCHOVER statements

CALTER DATABASE RECOVER TO STANDBY DATABASE statement with the FINISH keyword

DD) ALTER DATABASE PREPARE SWITCHOVER and ALTER DATABASE COMMIT TO SWITCHOVER Statements

Show Suggested Answer

Suggested Answer: A

https://docs.oracle.com/database/121/GSMUG/trouble.htm#GSMUG706

by Luisa at Mar 30, 2023, 07:55 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-497 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Lai

3 days ago

I'm not entirely sure, but I think option C might be the right choice as it mentions the RECOVER TO STANDBY DATABASE statement, which sounds relevant for a failover scenario.

upvoted 0 times

...

Option B seems to be the correct solution since it involves the PREPARE TO SWITCHOVER and COMMIT TO SWITCHOVER statements, which are specifically designed for performing a failover to a physical standby database.

upvoted 0 times

...

Camellia

19 days ago

I'm not sure, but I think option A) ALTER DATABASE RECOVER MANAGED STANDBY DATABASE statement with the FINISH keyword could also work.

upvoted 0 times

...

Carma

22 days ago

I agree with Kate. Those statements are specifically designed for switching over to a physical standby.

upvoted 0 times

...

Kate

25 days ago

I think the best solution is B) ALTER DATABASE PREPARE TO SWITCHOVER and ALTER DATABASE COMMIT TO SWITCHOVER statements.

upvoted 0 times

...

Oracle Exam 1Z0-497 Topic 3 Question 73 Discussion

Contribute your Thoughts:

Lai

Clarinda

Camellia

Carma

Kate