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

exeRCiSe 7.2 (continued)
12. Back up the USERS tablespace:
RMAN> backup tablespace users;
Starting backup at 10/09/2013 22:28:51
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00004
name=C:\ORACLE\ORADATA\ORCL\USERS01.DBF
channel ORA_DISK_1: starting piece 1 at 10/09/2013 22:28:58
channel ORA_DISK_1: finished piece 1 at 10/09/2013 22:28:59
piece handle=C:\ORACLE\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2013_10_09
\O1_MF_NNNDF_TAG20131009T222851_4GXPJB5V_.BKP
tag=TAG20131009T222851 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 10/09/2013 22:28:59
Starting Control File and SPFILE Autobackup at 10/09/2013 22:28:59
piece handle=C:\ORACLE\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2013_10_09
\O1_MF_S_667693739_4GXPJMNZ_.BKP comment=NONE
Finished Control File and SPFILE Autobackup at 10/09/2013 22:29:14.
13. Connect to SYS with SQL*Plus:
C:\Documents and Settings\Robert>sqlplus sys/robert as sysdba
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
14. Bring the USERS tablespace online:
SQL> alter tablespace users online;
Tablespace altered.
15. Select from the TSPITR table. Notice that only the first record is now in the table. This
concludes this exercise.
SQL> select * from tspitr;
ID THE_DATE
---------- -------------------
1 10/09/2013 22:09:02