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

exeRCiSe 7.2 (continued)
5. Insert a record into the TSPITR table and commit:
SQL> insert into tspitr values (1,sysdate);
1 row created.
SQL> commit;
Commit complete.
SQL>
6. Wait a minute and insert another record into TSPITR . Commit the record:
SQL> insert into tspitr values (2,sysdate);
1 row created.
SQL> commit;
Commit complete.
SQL>
7. Select from the TSPITR table. Record the time/date of both records for a later step:
SQL> select * from tspitr;
ID THE_DATE
---------- -------------------
1 10/09/2013 22:09:02
1 10/09/2013 22:10:04
8. Exit SQL*Plus.
9. From the operating system, create a directory for the auxiliary database files In our
case, we are using c:\oracle\auxiliary .
c:>mkdir c:\oracle\auxiliary
10. Start RMAN. Connect to the target database:
C:\Documents and Settings\Robert>rman target=/
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: ORCL (DBID=1194923408)
RMAN>
11. Perform a tablespace point-in-time recovery of the USERS tablespace to a point in
time between insert #1 and insert #2.
RMAN> recover tablespace users
2> until time '10/09/2013:22:09:20' auxiliary destination 'c:\oracle\auxiliary';
< we have decided to remove the output here to save a few trees.>