you need to perform a point-in-time restore operation on in order to complete this task? (Choose all that apply.)

You have a database with the following tablespaces: SYSTEM, SYSAUX, UNDO, USERS, TEMP.
You want toroll back the data in the USERS tablespace to the way it looked yesterday. Which
tablespaces do you need to perform a point-in-time restore operation on in order to complete this
task? (Choose all that apply.)

You have a database with the following tablespaces: SYSTEM, SYSAUX, UNDO, USERS, TEMP.
You want toroll back the data in the USERS tablespace to the way it looked yesterday. Which
tablespaces do you need to perform a point-in-time restore operation on in order to complete this
task? (Choose all that apply.)

A.
SYSTEM

B.
SYSAUX

C.
UNDO

D.
USERS

E.
TEMP

F.
This restore is not possible.



Leave a Reply 2

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


Helcio

Helcio

There are four other important terms related to TSPITR, which will be used in the rest of this discussion:

The target time, the point in time or SCN that the tablespace will be left at after TSPITR

The recovery set, which consists of the datafiles containing the tablespaces to be recovered;

The auxiliary set, which includes datafiles required for TSPITR of the recovery set which are not themselves part of the recovery set. The auxiliary set typically includes:

A copy of the SYSTEM tablespace

Datafiles containing rollback or undo segments from the target instance

In some cases, a temporary tablespace, used during the export of database objects from the auxiliary instance

The auxiliary instance has other files associated with it, such as a control file, parameter file, and online logs, but they are not part of the auxiliary set.

The auxiliary destination, an optional location on disk which can be used to store any of the auxiliary set datafiles, control files and online logs of the auxiliary instance during TSPITR. Files stored here can be deleted after TSPITR is complete.

eamon

eamon

Yes the TEMP tablespace is used in TSPITR.
However I suggest reading …
http://oracle.su/docs/11g/backup.112/e10642/rcmtspit.htm
it says …
Tempfiles are considered part of the auxiliary set for your database. When the auxiliary instance is instantiated, RMAN re-creates the temporary tablespaces of the target database (Note, it does not copy them) and generates their names by means of the regular rules for the auxiliary datafile names.