Which answer properly describes the order of the steps that you would use to recover from this error?

Prev Question
Next Question

Your database has experienced a loss of datafile users_01.dbf, which is associated with a tablespace called
USERS. The database is still running.
Which answer properly describes the order of the steps that you would use to recover from this error?
1. Shut down the database.
2. Take the users_01.dbf datafile offline with the alter database command.
3. Restore the users_01.dbf datafile from backup media with the required archived redo logs.
4. Restore all users tablespace-related datafiles from backup media.
5. Issue the recover tablespace users command.
6. Issue the recover datafile users_01.dbf command.
7. Start up the database.
8. Bring the users_01.dbf datafile online with the alter database command.

A.
1, 3, 6, 7

B.
2, 3, 6, 8

C.
1, 2, 3, 6, 7

D.
1, 2, 3, 6, 7, 8

E.
2, 3, 6, 5, 7

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *