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. 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
This is not a crash recover.
Sorry… this is not a disaster recover…
why need resetlogs?
because is an incomplete recover