Dell-EMC
E20-818 · Question #102
A customer is using Oracle 11g with flashback functionality enabled with a retention period of 24 hours. A TimeFinder/BCV copy of the database is taken every evening at midnight. The customer…
The correct answer is A. Make a new replica of the production database, start the database from the new replica on a secondary. See the full explanation below for the reasoning.
Question
A customer is using Oracle 11g with flashback functionality enabled with a retention period of 24 hours. A TimeFinder/BCV copy of the database is taken every evening at midnight. The customer becomes aware of a transactional corruption in the database at 3:00 P.M. A plan to fix the database needs to be presented for approval. The plan must specify which changes need to occur with the database to recover as much of the data as possible. How can the customer identify the exact point of corruption?
Options
- AMake a new replica of the production database, start the database from the new replica on a secondary
- BStart the database from the midnight BCV replica on a secondary host and use flash forward to discover
- CMake a new replica of the production database, start the database from the new replica on a secondary
- DStart the database from the midnight BCV replica on a secondary host and use flashback to discover
How the community answered
(24 responses)- A71% (17)
- B17% (4)
- C8% (2)
- D4% (1)
Community Discussion
No community discussion yet for this question.