Tuning and Monitoring RMAN and the Automatic Diagnostic Workflow - OCP: Oracle Database 12c Administrator Certified Professional - page 246

exeRCiSe 6.1 (continued)
4. See what backups in the database have become obsolete because they do not meet
the retention criteria. To do so, you will use the REPORT OBSOLETE command:
RMAN> report obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of obsolete backups and copies
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Archive Log 926 18-OCT-13
C:\ORACLE\PRODUCT\11.1.0\DB_1\RDBMS\ARC00022_0667833490.001
Backup Set 978 18-OCT-13
Backup Piece 980 18-OCT-13
C:\ORACLE\FAST_RECOVERY_AREA\ORCL\AUTOBACKUP\2013_10_18
\O1_MF_S_668446569_4HNOPMRF_.BKP
Backup Set 1252 18-OCT-13
Backup Piece 1260 18-OCT-13 C:\ORACLE\FAST_RECOVERY_AREA\
ORCL\BACKUPSET\2013_10_18
\O1_MF_ANNNN_TAG20131018T153543_4HNOP6OH_.BKP.OLD
Backup Set 1253 18-OCT-13
Backup Piece 1261 18-OCT-13 C:\ORACLE\FAST_RECOVERY_AREA\
ORCL\BACKUPSET\2013_10_18\
O1_MF_NNNDF_TAG20131018T152908_4HNO9DX9_.BKP.OLD
5. Log out of RMAN and log into the database with SQL*Plus:
RMAN> quit
Recovery Manager complete.
C:\Documents and Settings\Robert>sqlplus "/ 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
SQL>
6. Add a tablespace to the database, and then log out of SQL*Plus. You may want to put
your tablespace in a different location; this is fine
SQL> create tablespace testtbs
2 datafile 'c:\oracle\oradata\orcl\testtbs.dbf' size 20m;
Tablespace created.