If you lost your entire database, including the database spfile, control files, online redo logs, and database datafiles, what kind of recovery would be required with RMAN?
A.
Complete database recovery.
B.
Incomplete database recovery.
C.
Approximate database recovery.
D.
Archived database recovery.
E.
The database could not be recovered with RMAN.
Pay attention: ARCHIVE_LAG_TARGET limits the amount of data that can be lost.
is this answer really true? i think A is the perfect one
@Helcio, I advise you to read the documentation.
@Nzaramba Deo, Incomplete database recovery. This is because you probably will not recover the database up until the last archive log created, remember you also lost all archive redo logs. So you restore and recover the database, however if you are using RMAN then it is advised that you do an OPEN RESETLOGS (hence incomplete) so that your database doesn’t get mixed up with the archive logs if the previously lost archive redo logs suddenly reappear, and then you do a RESET DATABASE so RMAN is aware of why your database now has a different SCN, log sequence etc. If you don’t use RMAN then these commands don’t hurt you anyway.
Another reason to use “Incomplete database recovery” is because OPEN RESETLOGS is also required after restoring the control file, which was also lost remember.