A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the
following
Error message:
Which is the recommended sequence of operations you need to perform for the query successfully?
A.
Drop the affected tablespace, re-create the tablespace, restore the datafiles, and the tablespace.
B.
Take the affected datafile offline (if not already offline), restore the damaged image of the datafile, and then
bring it online.
C.
Restart the database in MOUNT mode, restore the damaged datafile, recover the datafile and then open the
database with resetlogs.
D.
Put the database in RESTRICTED mode, restore all the datafiles in the affected datafile and recover the
tablespace, and then put the database in normal operational mode.