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

Hi@everybody,

 

we have a Oracle 11gR2 (11.2.0.3.0) 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,

David

Legend

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