What is the end result of the following commands?
recover tablespace users
until time 10/06/2008:22:42:00
auxiliary destination c:\oracle\auxiliary;
sql alter tablespace users online;
recover tablespace users
until time 10/06/2008:20:40:00
auxiliary destination c:\oracle\auxiliary;
sql alter tablespace users online;
A.
The commands will be successful. The USERS tablespace will be recovered until 10/06/2008 at
20:40.
B.
The first recover tablespace command will fail because the syntax is incorrect.
C.
The first alter tablespace users online command will fail because the tablespace will already be
online after the recover command.
D.
The second recover tablespace command will fail because it will be unable to complete the
recovery.
E.
The second alter tablespace users online command will fail because you cannot perform two
TSPITRs in a row without backing up the database between the first and the last recovery.