6 Replies Latest reply on Nov 19, 2012 12:54 PM by Saurabh Gupta-OC

    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
        • 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