Performing Oracle Advanced Recovery - OCP: Oracle Database 12c Administrator Certified Professional - page 300

Setting the NLS_DATE_FORMAT
For the UNTIL TIME commands shown in this chapter, we set NLS_DATE_FORMAT at the
Windows OS level to a value of mm/dd/yyyy hh24:mi:ss, as shown in this example:
Set nls_date_format=mm/dd/yyyy hh24:mi:ss
How you set the NLS_DATE_FORMAT OS LEVEL parameter will vary by platform.
If you are using a different date format, you will need to change the date/time in the com-
mands to that format. You can also use the to_date function to format the date, as shown
in this example:
recover tablespace users
until time “to_date('10/06/2013:22:42:00','mm/dd/yyyy:hh24:mi:ss')”
auxiliary destination 'c:\oracle\auxiliary';
TSPITR Overview
RMAN provides the ability to do a full TSPITR on a given tablespace or set of tablespaces
with minimal user interaction. This is known as fully automated TSPITR. You may want
to exercise more granular control over TSPITR, in which case you might want to choose to
perform customized RMAN TSPITR where you have more control over the creation of the
auxiliary instance and other aspects of the operation. For the purposes of this topic, we will
be concerned with only fully automated TSPITR.
1. Before starting TSPITR, decide on the location of the files associated with the database.
Since TSPITR creates an auxiliary-instance database, it needs to know where you
want to put the files associated with that database. For automated TSPITR, you are
going to use the AUXILIARY DESTINATION parameter of the RECOVER TABLESPACE
command (discussed shortly); then you will need to create the directory associated
with the auxiliary destination before executing the TSPITR.
2. Start TSPITR.
You will start TSPITR using the RMAN command RECOVER TABLESPACE . Special syn-
tax (which we will cover shortly) that you will include in the body of the command will
indicate to RMAN that this is a tablespace TSPITR rather than a normal tablespace
recovery. Here is an example of the use of the RECOVER TABLESPACE command to start
a TSPITR recovery:
recover tablespace users
until time '10/06/2013:22:42:00'
auxiliary destination 'c:\oracle\auxiliary';