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.
The correct answer is B, because the datafile isn’t critical datafile (SYSTEM – UNDO).
Answer B is correct.
First of all the question is about ‘recommended’ scenario.
The another thing is in B you get old SCN in the datafile. Bringing it only online is not enough- you lost all data since the image copy was made.
If you have image copy and incremental backups then you need to apply archive logs since the last incremental backup yet.
Justyna – are you saying “recover the datafile” is missing in answer B ?
the datafile needs to be recovered in B.
B is right answer!