RMAN : Take backup of Tablespace

Backup Tablespace :

RMAN> backup tablespace USERS;

Starting backup at 03-JAN-18

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=/u01/app/oraclebase/oradata/testdb2/users01.dbf

channel ORA_DISK_1: starting piece 1 at 03-JAN-18

channel ORA_DISK_1: finished piece 1 at 03-JAN-18

piece handle=/u01/app/oraclebase/fast_recovery_area/TESTDB2/backupset/2018_01_03/o1_mf_nnndf_TAG20180103T195951_f4st6zcy_.bkp tag=TAG20180103T195951 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

Finished backup at 03-JAN-18

RMAN> list backup;

List of Backup Sets

===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

108     Full    3.29M      DISK        00:00:00     03-JAN-18      

        BP Key: 108   Status: AVAILABLE  Compressed: NO  Tag: TAG20180103T195951

        Piece Name: /u01/app/oraclebase/fast_recovery_area/TESTDB2/backupset/2018_01_03/o1_mf_nnndf_TAG20180103T195951_f4st6zcy_.bkp

  List of Datafiles in backup set 108

  File LV Type Ckp SCN    Ckp Time  Name

  ---- -- ---- ---------- --------- ----

  4       Full 1074979    03-JAN-18 /u01/app/oraclebase/oradata/testdb2/users01.dbf