Let’s have look on the steps we use for “RMAN Particular Datafile Backup” Check the datafile SQL> select file_id,tablespace_name,file_name from dba_data_files; FILE_ID TABLESPACE_NAME FILE_NAME —————————————————————————————- 4 USERS D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA01\USERS01.DBF 3 SYSAUX D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA01\SYSAUX01.DBF 2 UNDOTBS1 D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA01\UNDOTBS01.DBF 1 SYSTEM D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA01\SYSTEM01.DBF 6 CHEC D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA01\CHECK01.DBF 5 TEST D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA01\TEST02.DBF 6 rows selected Create a dummy table and insert some records. SQL> […]