This discussion is archived
5 Replies Latest reply: Jul 3, 2013 7:19 PM by Hemant K Chitale RSS

RMAN Backup specially for tablespaces

David_Pasternak Newbie
Currently Being Moderated



we have a Oracle 11gR2 ( Server, based on RedHat 6, running in our company. For the Backups i'm using RMAN with a script. In that script this code specially creates the backup:


        run {
            allocate channel oem_backup_disk1 type disk;
            backup incremental level ${level} cumulative as COMPRESSED BACKUPSET tag '${tag}' database;
            backup as COMPRESSED BACKUPSET tag '${tag}' archivelog all not backed up;
            release channel oem_backup_disk1;


${level} is for 0 or 1, full backup or incremental backup. ${tag} is the name for the backup. This script is for the hole database. But now i want to change that script to tablespace level. We have some "test" tablespaces, where a backup is not needed. I just found that one:


backup tablespace TEST tag='BACKUP_TEST';


But now i'm not shure how i can implement that into my script.


Can you guys help me?


Thanks and best regards,



  • Correct Answers - 10 points
  • Helpful Answers - 5 points