How to Backup Oracle Tablespace?
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 Tablespaces:
RMAN> BACKUP TABLESPACE USERS;
RMAN> BACKUP TABLESPACE USERS,SYSTEM;
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 Tablespaces:
RMAN> BACKUP TABLESPACE USERS;
RMAN> BACKUP TABLESPACE USERS,SYSTEM;
RMAN> BACKUP TABLESPACE USERS;
Starting backup at 04-JUL-22
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=273 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00007 name=/u01/app/oracle/oradata/ORA12C/datafile/o1_mf_users_k2mxtxky_.dbf
output file name=/u01/app/oracle/fast_recovery_area/ORA12C/ORA12C/datafile/o1_mf_users_kd5d4ckq_.dbf tag=TAG20220704T144907 RECID=552 STAMP=1109170147
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
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_1109170148_kd5d4dvq_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 04-JUL-22
RMAN> BACKUP TABLESPACE USERS,SYSTEM;
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_kd5d4lrx_.dbf tag=TAG20220704T144914 RECID=553 STAMP=1109170158
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile file number=00007 name=/u01/app/oracle/oradata/ORA12C/datafile/o1_mf_users_k2mxtxky_.dbf
output file name=/u01/app/oracle/fast_recovery_area/ORA12C/ORA12C/datafile/o1_mf_users_kd5d4svw_.dbf tag=TAG20220704T144914 RECID=554 STAMP=1109170161
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
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_1109170162_kd5d4v32_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 04-JUL-22
RMAN>
Regards,
Mallik
