Oracle Exam 1Z0-908 Topic 8 Question 91 Discussion

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

Question #: 91
Topic #: 8

[All 1Z0-908 Questions]

A clean shutdown was performed with innodb_fast_shutdown=0.

While you were manipulating files, all files were accidentally deleted from the top-level data directory.

Which two files must be restored from backup to allow the DB to restart cleanly? (Choose two.)

Aibtmp1

Bundo_001

Cib_buffer_pool

Dibdata1

Emysql.ibd

Fib_logfile0

Show Suggested Answer

Suggested Answer: C, E

by Jesusita at Sep 13, 2024, 08:38 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Paola

2 months ago

I'd say D) ibdata1 and F) ib_logfile0. Gotta get those essential files back in order to restart the database cleanly.

upvoted 0 times

...

Tori

2 months ago

Haha, imagine if the answer was just A) ibtmp1. The database would be like, 'Sorry, guys, no can do - that one file is just too important!'

upvoted 0 times

Devora

1 months ago

User 3: Phew, good thing it's not just A) ibtmp1 that needs to be restored. That would have been a nightmare!

upvoted 0 times

...

Leonie

2 months ago

Agreed, those are the crucial files for a clean restart after a clean shutdown.

upvoted 0 times

...

Paola

2 months ago

Definitely need to restore D) ibdata1 and F) ib_logfile0 to get the DB back up and running.

upvoted 0 times

...

Tuyet

2 months ago

But what about undo_001? Shouldn't we restore that as well?

upvoted 0 times

...

Gretchen

2 months ago

I agree with Brittni, those two files are crucial for the DB to restart cleanly.

upvoted 0 times

...

Tarra

2 months ago

I'd go with D) ibdata1 and E) mysql.ibd. Those are the main data files, right?

upvoted 0 times

...

Ira

3 months ago

Hmm, I think the answer is D) ibdata1 and F) ib_logfile0. Those are the core data and log files that need to be restored.

upvoted 0 times

Shawna

1 months ago

Let's make sure to restore those files from the backup to avoid any issues.

upvoted 0 times

...

Tegan

1 months ago

Yes, those are the essential files for a clean restart.

upvoted 0 times

...

Gwen

2 months ago

I agree, we need to restore ibdata1 and ib_logfile0 to restart the DB.

upvoted 0 times

...

Brittni

3 months ago

I think we need to restore ibdata1 and ib_logfile0.

upvoted 0 times

...