what order would you run the following commands to compete this task?

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;

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



Leave a Reply 4

Your email address will not be published. Required fields are marked *


Helcio

Helcio

This is not a crash recover.

Helcio

Helcio

Sorry… this is not a disaster recover…

tmmk

tmmk

why need resetlogs?

angel

angel

because is an incomplete recover