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.