RMAN Backup of Single Datafile and List Backup

This post will discuss about taking backup of single datafile, provided database is in archive log mode.

Check if ARCHIVELOG mode is on

SQL> archive log list

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination            /u01/ASGARD/arch

Oldest online log sequence     404

Next log sequence to archive   406

Current log sequence           406

Take backup of datafile system_01.dbf

$ rman target / nocatalog

Recovery Manager: Release 11.2.0.4.0 - Production on Tue Nov 20 02:35:57 2018

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ASGARD (DBID=2227813556)

using target database control file instead of recovery catalog

RMAN> run

{

allocate channel ch1 type disk format '/u01/rman_backup/rman_datafile_backup_%U';

backup datafile '/u01/ASGARD/data/system_01.dbf';

release channel ch1;

}2> 3> 4> 5> 6>

allocated channel: ch1

channel ch1: SID=133 device type=DISK

Starting backup at 20-NOV-18

channel ch1: starting full datafile backup set

channel ch1: specifying datafile(s) in backup set

input datafile file number=00001 name=/u01/ASGARD/data/system_01.dbf

channel ch1: starting piece 1 at 20-NOV-18

channel ch1: finished piece 1 at 20-NOV-18

piece handle=/u01/rman_backup/rman_datafile_backup_vdtilht7_1_1 tag=TAG20181120T024247 comment=NONE

channel ch1: backup set complete, elapsed time: 00:00:07

channel ch1: starting full datafile backup set

channel ch1: specifying datafile(s) in backup set

including current control file in backup set

including current SPFILE in backup set

channel ch1: starting piece 1 at 20-NOV-18

channel ch1: finished piece 1 at 20-NOV-18

piece handle=/u01/rman_backup/rman_datafile_backup_vetilhte_1_1 tag=TAG20181120T024247 comment=NONE

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

Finished backup at 20-NOV-18

released channel: ch1

RMAN>

List/Report backup of above datafile

RMAN> list backup of datafile '/u01/ASGARD/data/system_01.dbf';

 List of Backup Sets

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

  List of Datafiles in backup set 19110

  File LV Type Ckp SCN    Ckp Time  Name

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

  1       Full 14718266653698 20-NOV-18 /u01/ASGARD/data/system_01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

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

19112   Full    405.02M    DISK        00:00:05     20-NOV-18

        BP Key: 19112   Status: AVAILABLE  Compressed: NO  Tag: TAG20181120T024247

        Piece Name: /u01/rman_backup/rman_datafile_backup_vdtilht7_1_1

  List of Datafiles in backup set 19112

  File LV Type Ckp SCN    Ckp Time  Name

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

  1       Full 14718266653802 20-NOV-18 /u01/ASGARD/data/system_01.dbf

you may also want to check this rman-disk-backup-and-list-or-report