9 Replies Latest reply: Oct 1, 2013 12:12 PM by EdStevens RSS

    Why RMAN not storing backups in "db_recovery_file_dest"?

    user130038

      Hi there

       

      select name, value from v$parameter

      where name ='db_recovery_file_dest'

       

      NAMEVALUE
      db_recovery_file_dest/ora_backup

       

      When I run the following commands, RMAN starts storing the backups in "$ORACLE_HOME/dbs":

       

      RMAN> backup incremental level 0 check logical

        format 'level0_%d_%t_%U'

        as compressed backupset database;

       

      My understanding is that RMAN should save backups under "/ora_backup".

       

      And when I issue the following command, RMAN stores backup under "/ora_backup":

       

      RMAN> backup database;

       

       

      Could someone please let me know what am I missing here?

       

      Here is RMAN config:

       

      RMAN> show all;

       

       

      RMAN configuration parameters are:

      CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;

      CONFIGURE BACKUP OPTIMIZATION OFF; # default

      CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

      CONFIGURE CONTROLFILE AUTOBACKUP ON;

      CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default

      CONFIGURE DEVICE TYPE DISK PARALLELISM 10 BACKUP TYPE TO BACKUPSET;

      CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

      CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

      CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 5 G;

      CONFIGURE MAXSETSIZE TO UNLIMITED; # default

      CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

      CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

      CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

      CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/app/oracle/product/10.2.0/dbee/dbs/snapcf_<SID>.f'; # default

      RMAN>

       

       

      Best regards