6 Replies Latest reply: Nov 19, 2012 6:54 AM by Saurabh Gupta-OC RSS

    Backupsets not backing up in FRA backup

    Saurabh Gupta-OC
      Dear All,

      I am trying to backup flash recovery area but I noticed that FRA backup is backing up only Archivelogs and not backing up Backupsets which is also placed in FRA.

      SQL> show parameter recovery

      NAME TYPE VALUE
      ------------------------------------ ----------- ------------------------------
      db_recovery_file_dest string +RECO_EXP
      db_recovery_file_dest_size big integer 17000000M
      recovery_parallelism integer 0

      ASMCMD [+reco_exp/prod] > ls
      ARCHIVELOG/
      AUTOBACKUP/
      BACKUPSET/
      CONTROLFILE/
      ONLINELOG/


      ASMCMD [+reco_exp/prod/backupset] > ls
      2012_10_09/
      2012_10_10/
      2012_10_11/
      2012_10_12/
      2012_10_13/
      2012_10_14/
      2012_10_15/


      ASMCMD [+reco_exp/prod/backupset/2012_10_15] > ls
      nnndn1_INCR_DB_BKP_0.304.796732235
      nnndn1_INCR_DB_BKP_0.348.796732241
      nnndn1_INCR_DB_BKP_0.367.796732289
      nnndn1_INCR_DB_BKP_0.388.796732229

      I checked backup logs and found below message:

      rman-06744 specification does not match any datafile copy in the repository

      Would appreciate if you can assist me on this.

      Environment:
      Oracle 11.2.0.3
      Linux 5.3

      Thanks
      Saurabh

      Edited by: 877938 on Oct 15, 2012 3:35 AM
        • 2. Re: Backupsets not backing up in FRA backup
          Saurabh Gupta-OC
          any suggestion....
          • 3. Re: Backupsets not backing up in FRA backup
            Hemant K Chitale
            Show us your BACKUP DATABASE and BACKUP RECOVERY AREA commands.

            The message about a datafile copy indicates that something in your scripts is not as expected.

            Hemant K Chitale
            • 4. Re: Backupsets not backing up in FRA backup
              Saurabh Gupta-OC
              Please find below full backup & fra backup script:


              RECOVERY AREA BACKUP SCRIPTS FOR TAPE:

              run {
              allocate channel 'dev_0' type 'sbt_tape'
              parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=vivadw,OB2BARLIST=DBFL)';
              allocate channel 'dev_1' type 'sbt_tape'
              parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=vivadw,OB2BARLIST=DBFL)';
              allocate channel 'dev_2' type 'sbt_tape'
              parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=vivadw,OB2BARLIST=DBFL)';
              allocate channel 'dev_3' type 'sbt_tape'
              parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=vivadw,OB2BARLIST=DBFL)';
              backup
              format 'DBFL_FRA<prod_%s:%t:%p>.dbf'
              recovery area;
              }

              FULL BACKUP SCRIPT FOR DISK (FRA):

              #!/bin/ksh

              su - oracle <<EOF

              export ORACLE_HOME=/u01/app/oracle/product/11.2.0.3/dbhome_1

              export ORACLE_SID=prod1

              export PATH=$PATH:/u01/app/oracle/product/11.2.0.3/dbhome_1/bin

              export NLS_DATE_FORMAT='DD-MON-YY HH24:MI:SS'

              export DATE=$(date +%Y-%m-%d)

              rman target / msglog /home/oracle/db_scripts/rman_full_bkp.log <<EOF

              run
              {
              allocate channel c1 device type disk format '+RECO_EXP/%U';
              allocate channel c2 device type disk format '+RECO_EXP/%U';
              allocate channel c3 device type disk format '+RECO_EXP/%U';
              allocate channel c4 device type disk format '+RECO_EXP/%U';
              allocate channel c5 device type disk format '+RECO_EXP/%U';
              allocate channel c6 device type disk format '+RECO_EXP/%U';
              allocate channel c7 device type disk format '+RECO_EXP/%U';
              allocate channel c8 device type disk format '+RECO_EXP/%U';
              backup as compressed backupset incremental level 0 tag 'FULL_DB_BKP'
              format '+reco_exp/data_%d_%s_%p_%T' database;
              backup format '+reco_exp/data_%d_%s_%p_%T' archivelog all;
              crosscheck backup;
              delete noprompt obsolete device type disk;
              }
              exit;

              EOF


              Please suggest.
              • 5. Re: Backupsets not backing up in FRA backup
                Hemant K Chitale
                When you explicitly specify a FORMAT in your BACKUP command as
                allocate channel c1 device type disk format '+RECO_EXP/%U';
                you are NOT writing to the FRA but to a directory that is "similar" to the FRA. As far as Oracle is concerned, the backup is NOT going to the recovery area.
                Do NOT use a FORMAT if you want backups to be written to the FRA.

                Hemant K Chitale
                • 6. Re: Backupsets not backing up in FRA backup
                  Saurabh Gupta-OC
                  Okay Hemant.

                  Thanks for your update.

                  I was on off so couldnt reply and check your suggestion.

                  Let me test it out.

                  Regards
                  Saurabh