Taking backup of a specific datafile :
RMAN> backup datafile 3; or backup datafile '/u01/app/oraclebase/oradata/testdb2/undotbs01.dbf';
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=00003 name=/u01/app/oraclebase/oradata/testdb2/undotbs01.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_TAG20180103T195356_f4ssvwlh_.bkp tag=TAG20180103T195356 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 03-JAN-18
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
106 Full 2.13M DISK 00:00:01 03-JAN-18
BP Key: 106 Status: AVAILABLE Compressed: NO Tag: TAG20180103T195356
Piece Name: /u01/app/oraclebase/fast_recovery_area/TESTDB2/backupset/2018_01_03/o1_mf_nnndf_TAG20180103T195356_f4ssvwlh_.bkp
List of Datafiles in backup set 106
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
3 Full 1074777 03-JAN-18 /u01/app/oraclebase/oradata/testdb2/undotbs01.dbf
RMAN> list backup of datafile 3;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
106 Full 2.13M DISK 00:00:01 03-JAN-18
BP Key: 106 Status: AVAILABLE Compressed: NO Tag: TAG20180103T195356
Piece Name: /u01/app/oraclebase/fast_recovery_area/TESTDB2/backupset/2018_01_03/o1_mf_nnndf_TAG20180103T195356_f4ssvwlh_.bkp
List of Datafiles in backup set 106
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
3 Full 1074777 03-JAN-18 /u01/app/oraclebase/oradata/testdb2/undotbs01.dbf
RMAN> backup datafile 3; or backup datafile '/u01/app/oraclebase/oradata/testdb2/undotbs01.dbf';
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=00003 name=/u01/app/oraclebase/oradata/testdb2/undotbs01.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_TAG20180103T195356_f4ssvwlh_.bkp tag=TAG20180103T195356 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 03-JAN-18
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
106 Full 2.13M DISK 00:00:01 03-JAN-18
BP Key: 106 Status: AVAILABLE Compressed: NO Tag: TAG20180103T195356
Piece Name: /u01/app/oraclebase/fast_recovery_area/TESTDB2/backupset/2018_01_03/o1_mf_nnndf_TAG20180103T195356_f4ssvwlh_.bkp
List of Datafiles in backup set 106
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
3 Full 1074777 03-JAN-18 /u01/app/oraclebase/oradata/testdb2/undotbs01.dbf
RMAN> list backup of datafile 3;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
106 Full 2.13M DISK 00:00:01 03-JAN-18
BP Key: 106 Status: AVAILABLE Compressed: NO Tag: TAG20180103T195356
Piece Name: /u01/app/oraclebase/fast_recovery_area/TESTDB2/backupset/2018_01_03/o1_mf_nnndf_TAG20180103T195356_f4ssvwlh_.bkp
List of Datafiles in backup set 106
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
3 Full 1074777 03-JAN-18 /u01/app/oraclebase/oradata/testdb2/undotbs01.dbf
No comments:
Post a Comment