You need to restore your database back to 9/30/2008 at 18:00. In what order would you run
the following commands to compete this task?
A.
restore controlfile until time ’09/30/2008:18:00:00′;
b, d, e
B.
restore database until time ’09/30/2008:18:00:00′;
b, d, f
C.
restore spfile until time ’09/30/2008:18:00:00′;
c, a, b, d, e
D.
recover database until time ’09/30/2008:18:00:00′;
c, a, b, d, f
E.
alter database open resetlogs;
a, b, d, e
F.
alter database open;
A.
restore controlfile until time ’09/30/2008:18:00:00′;
b, d, e
B.
restore database until time ’09/30/2008:18:00:00′;
b, d, f
C.
restore spfile until time ’09/30/2008:18:00:00′;
c, a, b, d, e
D.
recover database until time ’09/30/2008:18:00:00′;
c, a, b, d, f
E.
alter database open resetlogs;
a, b, d, e
A. restore controlfile until time ’09/30/2008:18:00:00′;
B. restore database until time ’09/30/2008:18:00:00′;
C. restore spfile until time ’09/30/2008:18:00:00′;;
D. recover database until time ’09/30/2008:18:00:00′;
E. alter database open resetlogs;
F. alter database open;
A. b, d, e
B. b, d, f
C. c, a, b, d, e
D. c, a, b, d, f
E. a, b, d, e
Answer: A
Answer is A
i.e. steps b,d,e
see
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmflash.htm#BRADV84152
However I would guess that one could find situations where recovering older “backup control files” maybe required due to a different database structure at the time you need to recover to.
Here are some hyperlinks to internet sites that we link to mainly because we assume they are really worth visiting.