RMAN tablespace and datafile backup Script for Oracle Database

Following scripts will backup the tablespace and datafile present in Oracle Database.

First you need to list the schema with RMAN Report:


RMAN> report schema;

Report of database schema for database with db_unique_name XE

List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    910      SYSTEM               YES     C:\ORACLE\ORADATA\XE\SYSTEM01.DBF
3    660      SYSAUX               NO      C:\ORACLE\ORADATA\XE\SYSAUX01.DBF
4    65       UNDOTBS1             YES     C:\ORACLE\ORADATA\XE\UNDOTBS01.DBF
5    250      PDB$SEED:SYSTEM      NO      C:\ORACLE\ORADATA\XE\PDBSEED\SYSTEM01.DBF
6    370      PDB$SEED:SYSAUX      NO      C:\ORACLE\ORADATA\XE\PDBSEED\SYSAUX01.DBF
7    5        USERS                NO      C:\ORACLE\ORADATA\XE\USERS01.DBF
8    100      PDB$SEED:UNDOTBS1    NO      C:\ORACLE\ORADATA\XE\PDBSEED\UNDOTBS01.DBF
13   260      PDB1:SYSTEM          NO      C:\ORACLE\ORADATA\XE\PDB1\SYSTEM01.DBF
14   400      PDB1:SYSAUX          NO      C:\ORACLE\ORADATA\XE\PDB1\SYSAUX01.DBF
15   100      PDB1:UNDOTBS1        NO      C:\ORACLE\ORADATA\XE\PDB1\UNDOTBS01.DBF
16   5        PDB1:USERS           NO      C:\ORACLE\ORADATA\XE\PDB1\USERS01.DBF

List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    129      TEMP                 32767       C:\ORACLE\ORADATA\XE\TEMP01.DBF
2    62       PDB$SEED:TEMP        32767       C:\ORACLE\ORADATA\XE\PDBSEED\TEMP012019-09-18_15-38-03-475-PM.DBF
4    62       PDB1:TEMP            62          C:\ORACLE\ORADATA\XE\PDB1\TEMP012019-09-18_15-38-03-475-PM.DBF

RMAN Backup script for the tablespace

run
{ 
allocate channel c1 type disk format 'C:\archive\backup\%I-%Y%M%D-%U' maxpiecesize 5G;
allocate channel c2 type disk format 'C:\archive\backup\%I-%Y%M%D-%U' maxpiecesize 5G;
backup tablespace PDB1:USERS, USERS;
release channel c1 ;
release channel c2 ;
}

RMAN backup script for the datafiles

run
{ 
allocate channel c1 type disk format 'C:\archive\backup\%I-%Y%M%D-%U' maxpiecesize 5G;
allocate channel c2 type disk format 'C:\archive\backup\%I-%Y%M%D-%U' maxpiecesize 5G;
backup datafile 7,16;
release channel c1 ;
release channel c2 ;
}
This entry was posted in Oracle on by .
Unknown's avatar

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply