Oracle Datafile Backups

How to Backup Oracle Datafiles?

Oracle Doc for reference:

https://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup003.htm

1. List tablespaces and datafiles from RAMN:

RMAN> report schema;

2. Backup datafiles:

RMAN> backup datafile 1;

RMAN> backup datafile 1,2;

RMAN> backup datafile '/u01/app/oracle/oradata/ORA12C/datafile/o1_mf_system_k2mxt6gl_.dbf';

1. List tablespaces and datafiles from RAMN:

RMAN> report schema;

using target database control file instead of recovery catalog

Report of database schema for database with db_unique_name ORA12C

List of Permanent Datafiles

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

File Size(MB) Tablespace           RB segs Datafile Name

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

1    840      SYSTEM               YES     /u01/app/oracle/oradata/ORA12C/datafile/o1_mf_system_k2mxt6gl_.dbf

2    100      TEST1                NO      /u01/app/oracle/oradata/ORA12C/datafile/o1_mf_test1_k42sw8b8_.dbf

3    1640     SYSAUX               NO      /u01/app/oracle/oradata/ORA12C/datafile/o1_mf_sysaux_k2mxtfh3_.dbf

4    205      UNDOTBS1             YES     /u01/app/oracle/oradata/ORA12C/datafile/o1_mf_undotbs1_k2mxtwjd_.dbf

5    100      TEST1                NO      /u01/app/oracle/oradata/ORA12C/datafile/o1_mf_test1_k434jtr1_.dbf

7    5        USERS                NO      /u01/app/oracle/oradata/ORA12C/datafile/o1_mf_users_k2mxtxky_.dbf

List of Temporary Files

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

File Size(MB) Tablespace           Maxsize(MB) Tempfile Name

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

1    20       TEMP                 32767       /u01/app/oracle/oradata/ORA12C/datafile/o1_mf_temp_k2mzy54o_.tmp

RMAN>

2. Backup Datafiles:

RMAN> backup datafile 1;

Starting backup at 04-JUL-22

using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile copy

input datafile file number=00001 name=/u01/app/oracle/oradata/ORA12C/datafile/o1_mf_system_k2mxt6gl_.dbf

output file name=/u01/app/oracle/fast_recovery_area/ORA12C/ORA12C/datafile/o1_mf_system_kd5gdlmx_.dbf tag=TAG20220704T152738 RECID=555 STAMP=1109172463

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07

Finished backup at 04-JUL-22

Starting Control File and SPFILE Autobackup at 04-JUL-22

piece handle=/u01/app/oracle/fast_recovery_area/ORA12C/ORA12C/autobackup/2022_07_04/o1_mf_s_1109172465_kd5gdsth_.bkp comment=NONE

Finished Control File and SPFILE Autobackup at 04-JUL-22

RMAN> backup datafile '/u01/app/oracle/oradata/ORA12C/datafile/o1_mf_system_k2mxt6gl_.dbf';

Starting backup at 04-JUL-22

using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile copy

input datafile file number=00001 name=/u01/app/oracle/oradata/ORA12C/datafile/o1_mf_system_k2mxt6gl_.dbf

output file name=/u01/app/oracle/fast_recovery_area/ORA12C/ORA12C/datafile/o1_mf_system_kd5gf774_.dbf tag=TAG20220704T152759 RECID=556 STAMP=1109172483

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07

Finished backup at 04-JUL-22

Starting Control File and SPFILE Autobackup at 04-JUL-22

piece handle=/u01/app/oracle/fast_recovery_area/ORA12C/ORA12C/autobackup/2022_07_04/o1_mf_s_1109172486_kd5gfgfx_.bkp comment=NONE

Finished Control File and SPFILE Autobackup at 04-JUL-22

RMAN> 

Regards,

Mallik