View the Exhibit.
One of the important tables in the USERS tablespace was dropped and purged from the recycle bin at 9:00 a.m.You noticed this at 11:00 a.m. and you want to perform an incomplete recovery to recover the table.
Which statement is true?
Exhibit:
A.
You must recover all data files to the required system change number (SCN).
B.
You must recover all data files, except those that are offline, to the required SCN.
C.
You must recover all data files belonging to the USERS tablespace to the required SCN.
D.
You cannot recover all data files because segment space management is performed manually for the undo tablespace.
Explanation:
You must recover all data files to the same SCN. The only exception is if the data file is offline normal or read-only. You can bring files in read-only or offline normal tablespaces online after the RESETLOGS because there are no transactional changes for these files stored in the redo logs.
Ref.:
Oracle Database 10g: Administration Workshop II. Page: 5-20.