A DBA executed a script which corrupted an Oracle DB managed by NDB. After few minutes, the NDB administrator has been asked to create a copy of the DB using the latest available snapshot. Which…

The correct answer is B. Select the snapshot from Time Machine and create a new clone. After a DBA's script corrupts an Oracle DB managed by NDB, the administrator needs to restore a clean copy using the latest available snapshot. The most straightforward action is to use the NDB Time Machine feature to select the most recent uncorrupted snapshot and create a new…

Perform Database Administration

Question

A DBA executed a script which corrupted an Oracle DB managed by NDB. After few minutes, the NDB administrator has been asked to create a copy of the DB using the latest available snapshot. Which actions should be taken?

Options

AFail the Oracle cluster over to a surviving RAC node.
BSelect the snapshot from Time Machine and create a new clone.
CUse Time Machine to create a clone from file-level database backup.
DProvision a new Oracle DB and perform log catch-up.

How the community answered

(25 responses)

A
4% (1)
B
72% (18)
C
16% (4)
D
8% (2)

Explanation

After a DBA's script corrupts an Oracle DB managed by NDB, the administrator needs to restore a clean copy using the latest available snapshot. The most straightforward action is to use the NDB Time Machine feature to select the most recent uncorrupted snapshot and create a new clone. This clone can serve as a restored version of the database, bypassing the corrupted data while leveraging existing snapshots for efficiency.

Topics

#Oracle#snapshot#clone#Time Machine

Community Discussion

No community discussion yet for this question.

Full NCP-DB-6.10 Practice