Your database has a backup that was taken yesterday (Tuesday) between 13:00 and 15:00
hours. This is the only backup you have. You have lost all the archived redo logs generated
since the previous Monday, but you have archived redo logs available from the previous
Sunday and earlier. You now need to restore your backup due to database loss.
To which point can you restore your database?
A.
13:00 on Tuesday.
B.
15:00 on Tuesday.
C.
Up until the last available archived redo log on Sunday.
D.
To any point; all the redo should still be available in the online redo logs.
E.
The database is not recoverable.
Here’s the question: if I have a backup why is it not recoverable?
You need archivelogs to recover backup (to make database consistent), but you’ve lost it, that’s why db is not recoverable.
It is possible to do a closed database backup that does not require archive redo logs for it to be recoverable.
Think that this DB is production DB (running 24/7) so backup on Tuesday is hot backup – but all archive since Monday Was lost => So DB is unrecoverable.
True. Should it be B
The option is Incomplete Recovery. recover database until cancel.
So B is correct
I understand Cuco’s logic but B is not correct.
As the questions deals with an inconsistent backup, you will still need the archivelogs.
If you don’t have them anymore, no restore and recovery is possible.
Gentlemen,
this question says, and I quote
“a backup that was taken yesterday”
Notice that it does not say whether the database was shutdown or not while the backup was being taken.
If the database was shutdown during the backup then the backup is considered to be consistant i.e. no ARCHIVELOG files are required for recovery.
Otherwise the backup is inconsistent (i.e. it remained open) regardless of whether ARCHIVELOG files are available or not.
If ARCHIVELOG files are available then you can recover this inconsistent backup.
If ARCHIVELOG files are NOT available then you can’t.
However, if by some chance you also backed up your online redos while the database was open during the backup (I am certain this is possible if you ran a user managed backup, RMAN doesnt do this) and the amount of DML done on the database during the “time taken for the backup ” was not enough to fill all of your online redos.
As no ARCHIVELOG files are available then normally you would not be able to recover a backup of a database that was taken while OPEN.
THe question also does not mention whether we have a previous backup taken before the ARCHIVELOGs started to “dissapear”. If there was one, then it would be possible to recover it.