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
No comments:
Post a Comment