3 Replies Latest reply: Aug 20, 2013 4:51 AM by DK2010 RSS

    RMAN_NETBACKUP

    User235837 -Oracle

      Hi All,

       

        We are taking Weekly backup for DB every sunday night to SBT_TAPE . i need to know all the RMAN configuration need to change to SBT_TAPE backup;

       

      for ex : i saw in some document they mentioned sbt instead of  +DISK, we are using asm.

       

      1. DO I NEED TO CHANGE or ADD any additional command for SBT_ backup.?

      2. controlfile autobackup is to +FRA01 do i need to change to SBT ?

      3. Do we need to set this parameter backup_tape_io_slaves =TRUE ?


       

       

      MY CONFIGURATION:

       

      RMAN configuration parameters for database with db_unique_name DVACT11I are:

      CONFIGURE RETENTION POLICY TO REDUNDANCY 1;

      CONFIGURE BACKUP OPTIMIZATION OFF;

      CONFIGURE DEFAULT DEVICE TYPE TO DISK;

      CONFIGURE CONTROLFILE AUTOBACKUP ON;

      CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '+FRA01/%F';    --------------- 2

      CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO COMPRESSED BACKUPSET;

      CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;

      CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;

      CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '+FRA01';     ------------------> to sbt_tape   -------------- 1

      CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT   '+FRA01';   ------------------ > to sbt_tape ---------------- 1

      CONFIGURE MAXSETSIZE TO UNLIMITED;

      CONFIGURE ENCRYPTION FOR DATABASE OFF;

      CONFIGURE ENCRYPTION ALGORITHM 'AES128';

      CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE;

      CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO DISK;

      CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_dvact11i.f';      ------------ 2

        • 1. Re: RMAN_NETBACKUP
          DK2010

          Hi

          >>1. DO I NEED TO CHANGE or ADD any additional command for SBT_ backup.?

          Yes, configuration should be something like

          CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=<tape Env>';      ==> configure tape Environment

          CONFIGURE DEFAULT DEVICE TYPE TO SBT;                          ==> Direct backup at tape                             

          CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 4;          ==> it will allocate Channels

           

          >>2. controlfile autobackup is to +FRA01 do i need to change to SBT ?

          Yes, if you want to take whole backup at tape control file backup should be with the backup set

           

          also check the link :7 Making Backups with RMAN: Advanced Topics

           

          HTH

          • 2. Re: RMAN_NETBACKUP
            User235837 -Oracle

            thanks for the DOC.. can you tell me how to check the validation of backup taken to SBT_TAPE ?

            • 3. Re: RMAN_NETBACKUP
              DK2010

              Hi,

               

              if i understand your question then  you  can run command like

               

              RMAN> LIST BACKUP SUMMARY;

              You can see there the  Device type would be SBT_TAPE

               

              Or you are talking about the Validation of backup set ?

              if yes you can use

              RMAN> VALIDATE BACKUPSET;

               

              HTH