5 Replies Latest reply on May 19, 2014 4:14 PM by J.A.

    RMAN backup on a RAC env

    946212

      We have a 2 node Oracle Database Appliance on version 11204 Linux Enterprise.

       

       

      Please can you advice as to why my RMAN backup still going to the default FRA, where as ive set the backup location as below?

       

       

      RMAN> show channel;

       

       

      RMAN configuration parameters for database with db_unique_name GEOHUBPR are:

      CONFIGURE CHANNEL 1 DEVICE TYPE DISK CONNECT '*';

      CONFIGURE CHANNEL 2 DEVICE TYPE DISK CONNECT '*';

      CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/mnt/san/odanfs/rman_backup/%D_%U.bak';

       

       

       

       

      run

      {

      BACKUP as COMPRESSED BACKUPSET TAG 'geohubpr_L0_db' INCREMENTAL LEVEL 0 DATABASE;

      BACKUP as COMPRESSED BACKUPSET TAG 'geohubpr_L0_arc' ARCHIVELOG ALL NOT BACKED UP;

      }

       

       

      Regards,

        • 1. Re: RMAN backup on a RAC env
          J.A.

          hi there

          Why do you want to take a backup outside of the FRA ?, its better to keep it inside.

           

          Anyway try this:

          configure controlfile autobackup format for device type disk to '/inst/BACKUP_DATABASE/controlfile/%F.ctl';

          run {

          allocate channel dup1 device type disk;

          sql "create pfile=''/inst/BACKUP_DATABASE/pfile/initpfile.ora'' from spfile";

          backup format '/inst/BACKUP_DATABASE/hot_db/hot_bkp_%U' database;

          release channel dup1;

          }

           

          OR

          backup incremental level 0 as compressed backupset format '/inst/BACKUP_DATABASE/hot_db/hot_bkp_%U' database plus archivelog delete all input;

           

          Change it to fulfill your requirement, this is only an example.

           

          I hope this help you

           

          Regards

          • 2. Re: RMAN backup on a RAC env
            946212

            We are only doing this to save space. Archive logs and every other auto backup with flashback logs are going to the FRA.. Getting an error?

             

             

             

             

             

             

             

            RMAN> backup incremental level 1 CUMULATIVE  as compressed backupset TAG 'geohubpr_L1_db' format  '/mnt/san/odanfs/rman_backup/%D_%U.bak';

             

             

            RMAN-00571: ===========================================================

            RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

            RMAN-00571: ===========================================================

            RMAN-00558: error encountered while parsing input commands

            RMAN-01009: syntax error: found ";": expecting one of: "archivelog, as, auxiliary, backupset, backup, channel, check, controlfilecopy, copies, copy, cumulative, current, database, datafilecopy, datafile, db_file_name_convert, db_recovery_file_dest, device, diskratio, duration, filesperset, force, format, for, from, full, incremental, keep, maxsetsize, nochecksum, noexclude, nokeep, not, pool, proxy, recovery, reuse, section, skip readonly, skip, spfile, tablespace, tag, to, validate, comma, ("

            RMAN-01007: at line 2 column 132 file: standard input

            • 3. Re: RMAN backup on a RAC env
              J.A.

              There is a sintaxis error, you  must add "database" word:

               

              RMAN> backup incremental level 1 CUMULATIVE  as compressed backupset TAG 'geohubpr_L1_db' format  '/mnt/san/odanfs/rman_backup/%D_%U.bak' DATABASE;

               

              Also include archives in your backup

               

              Regards

              • 4. Re: RMAN backup on a RAC env
                946212

                thanks

                 

                 

                BACKUP incremental level 1 CUMULATIVE  as compressed backupset TAG 'geohubpr_L1_db' format  '/mnt/san/odanfs/rman_backup/%D_%U.bak' database;

                BACKUP as COMPRESSED BACKUPSET TAG 'geohubpr_L1_arc' format  '/mnt/san/odanfs/rman_backup/%D_%U.bak'  ARCHIVELOG ALL NOT BACKED UP;

                • 5. Re: RMAN backup on a RAC env
                  J.A.

                  No problem

                   

                   

                   

                  If this information it was useful for you, mark it as correct so other people can use the same information

                   

                   

                   

                  Regards