RMAN Particular Datafile Backup

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> […]

Read More