This discussion is archived
6 Replies Latest reply: Nov 19, 2012 4:54 AM by Saurabh Gupta-OC RSS

Backupsets not backing up in FRA backup

Saurabh Gupta-OC Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    any suggestion....
  • 3. Re: Backupsets not backing up in FRA backup
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    Okay Hemant.

    Thanks for your update.

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

    Let me test it out.

    Regards
    Saurabh

Legend

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