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

PL/SQL procedure successfully completed.
SQL>commit;
Now you will create a table based on the UNRECOVER_TABLE . You will make the operation
an unrecoverable operation:
SQL> Create table test_norecover nologging as select * from unrecover_table;
The RMAN REPORT UNRECOVERABLE command indicates that your USERS tablespace
needs a backup:
RMAN> report unrecoverable database;
Report of files that need backup due to unrecoverable operations
File Type of Backup Required Name
---- ----------------------- -----------------------------------
4 full or incremental C:\ORACLE\ORADATA\ORCL\USERS01.DBF
To fix this problem, you back up the USERS tablespace, as shown here:
RMAN> backup tablespace users;
Starting backup at 18-OCT-13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=134 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=C:\ORACLE\ORADATA\ORCL\USERS01.DBF
output file name=C:\ORACLE\FAST_RECOVERY_AREA\ORCL\DATAFILE\
O1_MF_USERS_4HM3CGQX_.DBF tag=TAG20131018T011646 RECID=1
STAMP=668395023
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 18-OCT-13
Starting Control File and SPFILE Autobackup at 18-OCT-13
piece handle=C:\ORACLE\FAST_RECOVERY_AREA\ORCL\AUTOBACKUP\2013_10_18\
O1_MF_S_668395027_4HM3CWNZ_.BKP comment=NONE
Finished Control File and SPFILE Autobackup at 18-OCT-13
RMAN> report unrecoverable database;
Report of files that need backup due to unrecoverable operations
File Type of Backup Required Name
---- ----------------------- -----------------------------------
In Exercise 6.1, you will get to experiment with the REPORT command.