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

Once a TSPITR is complete, you will not be able to run another TSPITR on that
tablespace to any time before the point to which you restored the tablespace.

■

Once a TSPITR is complete, you will not be able to use the control file to restore
any part of the database to any point in time before the time that you restored the
tablespaces to during the TSPITR.
In Exercise 7.2, you'll perform a tablespace point-in-time recovery with RMAN.

■

exeRCiSe 7.2

Performing a Tablespace Point-in-Time Recovery

In this exercise, you will perform a tablespace point-in-time recovery of the USERS
tablespace.

1. Log into the scott account in the database with SQL*Plus:

C:\Documents and Settings\Robert>set oracle_sid=orcl
C:\Documents and Settings\Robert>sqlplus scott/tiger
SQL*Plus: Release 12.1.0.1.0 Production on Sat Jan 4 20:05:34 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics
and Real Application Testing options
SQL>

2. Create a table called TSPITR for this exercise. It will be created in the USERS
tablespace (create the USERS tablespace if required):

SQL> create table tspitr (id number, the_date date) tablespace users;
Table created.

3. Exit SQL*Plus and start RMAN. Back up the database with RMAN:

RMAN> backup as compressed backupset database plus archivelog delete input;

4. Exit RMAN and connect to the scott schema again with SQL*Plus:

RMAN> exit
Recovery Manager complete.
C:\Documents and Settings\Robert>sqlplus scott/tiger
Recovery Manager: Release 12.1.0.1.0 -
Production on Sat Jan 4 20:01:34 2014
Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.
connected to target database
SQL>