Discuss Nutanix NCP-DB Exam Topic 3 Question 35

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?

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.

Suggested Answer: B

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.

Option A (Fail the Oracle cluster over to a surviving RAC node) is incorrect because RAC failover is for HA, not corruption recovery via snapshots.

Option B is correct as it uses Time Machine to create a clone from a valid snapshot, addressing the corruption.

Option C (Use Time Machine to create a clone from file-level database backup) is incorrect because NDB primarily uses snapshots, not file-level backups, for cloning.

Option D (Provision a new Oracle DB and perform log catch-up) is incorrect because provisioning a new DB is more complex and unnecessary when a snapshot-based clone suffices.

This method ensures rapid recovery with minimal disruption.

Nutanix Database Service (NDB) User Guide, Chapter 5: Configuring Time Machines, Section: Restoring and Cloning from Snapshots

Nutanix Support & Insights, Knowledge Base Article: 'Recovering from Database Corruption in NDB'

Nutanix Certified Professional - Database Automation (NCP-DB) v6.5 Blueprint, Section 5: Protect Databases Using Time Machine

Get Premium NCP-DB Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

23 comments · newest first

Tu 9 months ago

A is definitely not the right choice here.

Tamra 10 months ago

I disagree, I think D is the way to go.

Mendy 10 months ago

Option B sounds like a solid plan!

Isabella 10 months ago

C seems like the safest bet for recovery.

Dolores 10 months ago

Wait, can you really use Time Machine for this?

Lucille 11 months ago

I’m a bit confused about the log catch-up option; I thought that was more for restoring from a backup rather than creating a new DB.

Lili 11 months ago

I practiced a similar question where we had to choose between snapshots and backups, and I feel like creating a clone from a file-level backup might be the safest bet.

Salena 11 months ago

I think failing over to a surviving RAC node could be a good option, but I need to double-check if that would actually help in this case.

Marsha 11 months ago

I remember we discussed the importance of using snapshots for recovery, but I'm not sure if Time Machine is the right tool for this situation.

Ben 11 months ago

This seems straightforward. The DBA corrupted the database, so we need to create a new copy from the latest snapshot. Option B is the clear choice here.

Hoa 12 months ago

I'm not too familiar with NDB, so I'll need to make sure I understand how that fits into the scenario. But I think I can narrow it down to a couple of options.

Antonio 12 months ago

Okay, I think I've got this. The key is to create a copy of the database using the latest available snapshot. Option B looks like the way to go.

Noble 12 months ago

Hmm, I'm a bit confused by the mention of Time Machine. That's not an Oracle feature, is it? I'll have to double-check that.

Quentin 1 year ago

This seems like a tricky one. I'll need to carefully read through the options and think about the context of the question.

Gayla 1 year ago

I disagree with Kaycee, I believe provisioning a new Oracle DB and performing log catch-up is the way to go.

Kaycee 1 year ago

I think we should use Time Machine to create a clone from file-level database backup instead.

Asuncion 1 year ago

I agree with Chanel, failing over to a surviving RAC node seems like the best option.

Lindsey 1 year ago

Hmm, let's see... Failing over to a RAC node doesn't sound like the right move here. I'm leaning towards option C - using Time Machine for a file-level backup. Sounds like the safest bet to me.

Elenor 1 year ago

Whoa, this is a tricky one! Gotta love those Oracle database disasters, am I right? I'm going with option D - time to provision a new DB and catch up on those logs. Yee-haw!

Chantell 1 year ago

↳ replying to Elenor

User 3: I agree with Chantell, let's provision a new Oracle DB and perform log catch-up.

Noble 1 year ago

↳ replying to Elenor

User 2: Nah, I believe we should use Time Machine to create a clone from file-level database backup.

Teddy 1 year ago

↳ replying to Elenor

User 1: I think we should fail over to a surviving RAC node.

Chanel 1 year ago

I think we should fail the Oracle cluster over to a surviving RAC node.

Nutanix NCP-DB Exam - Topic 3 Question 35 Discussion