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?()
- ADrop the affected tablespace, re-create the tablespace, restore the datafiles, and the tablespace.
- BTake the affected datafile offline (if not already offline), restore the damaged image of the datafile, and then bring it online.
- CRestart the database in MOUNT mode, restore the damaged datafile, recover the datafile and then open the database with resetlogs.
- DPut 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.&e