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.
I think A is the correct answer, because you will have to perform complete recovery.
how will you perform complete recovery, if you don’t have online redo logs, including current (not archived) ? 😉
incomplete stands for point in time recovery (in opposition to complete meaning to recover to the most recent scn)
Answer is A
@marcin and @ola are right, incomplete stands for point in time recovery which is not what we are doing here.
@dcdba mentions that we
“don’t have online redo logs, including current (not archived)”
this is true, but exactly because these files do not exist means that we do not have to worry about them, we just do a complete restore of everything we do have, from the last backup.
(although because we restore a “backup control file” this does mean that we also require a ALTER DATABASE OPEN RESETLOGS;
hey, do you remember where you put your “backup control file”? eh!!)
The answer is A not be because the incomplete recovery stands for point in time recovery related with SCN
We lost the online redo logs, so we cannot perform instance recovery, which is necessary for a complete recovery. So the answer is B.
You will need to use backup controlfile and reset logs, both of which constitutue as incomplete recovery.