11 Replies Latest reply: May 9, 2012 5:32 AM by user106161 RSS

    autobackup of controlfile

    user106161
      Hi All,

      O/S: Windows 2003 server
      DB: 10.2.0.4.0

      I have FRA configured. Every evening my script takes backup of database and archivelogs. The script is as follows:

      SQL "ALTER SYSTEM ARCHIVE LOG CURRENT"; 
      backup database TAG 'FULL_BACKUP_20120503' plus archivelog ; 
      SQL "alter database backup controlfile to trace as ''D:\oracle\flash_recovery_area\efin\EFIN_TRACE\\CTrl_Bkp_Trace.trc''"; 
      crosscheck backup ; 
      crosscheck archivelog all; 
      report obsolete; 
      DELETE NOPROMPT FORCE OBSOLETE DEVICE TYPE DISK; 
      exit
      My RMAN parameters are:
      RMAN> show all;
       
      RMAN configuration parameters are:
      CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 3 DAYS;
      CONFIGURE BACKUP OPTIMIZATION OFF;
      CONFIGURE DEFAULT DEVICE TYPE TO DISK;
      CONFIGURE CONTROLFILE AUTOBACKUP ON;
      CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F';
      CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO COMPRESSED BACKUPSET;
      CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
      CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
      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 'C:\ORACLE\10.2.0\DATABASE\SNCFEFIN.ORA'; # default
      When I take backup of database or the controlfile I expect my controlfile and spfile backedup in AUTOBACKUP folder (FRA) but it goes to my 'C:\ORACLE\10.2.0\DATABASE\' folder. For eg see below:

      RMAN> backup current controlfile;
       
      Starting backup at 03-MAY-12
      allocated channel: ORA_DISK_1
      channel ORA_DISK_1: sid=301 devtype=DISK
      channel ORA_DISK_1: starting compressed full datafile backupset
      channel ORA_DISK_1: specifying datafile(s) in backupset
      including current control file in backupset
      channel ORA_DISK_1: starting piece 1 at 03-MAY-12
      channel ORA_DISK_1: finished piece 1 at 03-MAY-12
      piece handle=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\BACKUPSET\2012_05_03\O1_MF_NCNNF_TAG20120503T091556_7T4HOWVX_.BKP tag=TA
      G20120503T091556 comment=NONE
      channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
      Finished backup at 03-MAY-12
       
      Starting Control File and SPFILE Autobackup at 03-MAY-12
      piece handle=C:\ORACLE\10.2.0\DATABASE\C-3295381608-20120503-02 comment=NONE
      Finished Control File and SPFILE Autobackup at 03-MAY-12 
      (contd: from autobackup of controlfile
        • 1. Re: autobackup of controlfile
          tychos
          Hi,
          Please try to unconfigure the 'autobackup format' setting.
          Than run a test backup and post the results.
          rgds,
          Tycho
          • 2. Re: autobackup of controlfile
            415289
            give full path inplace of just %F
            CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'D:\oracle\flash_recovery_area\%F';
            • 3. Re: autobackup of controlfile
              user106161
              Hi Tychos,

              I unconfigure the 'autobackup format' setting ran the backup from windows scheduler.
              The backup
              RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF;
              
              old RMAN configuration parameters:
              CONFIGURE CONTROLFILE AUTOBACKUP ON;
              new RMAN configuration parameters:
              CONFIGURE CONTROLFILE AUTOBACKUP OFF;
              new RMAN configuration parameters are successfully stored
              
              RMAN> show all;
              
              RMAN configuration parameters are:
              CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 3 DAYS;
              CONFIGURE BACKUP OPTIMIZATION OFF;
              CONFIGURE DEFAULT DEVICE TYPE TO DISK;
              CONFIGURE CONTROLFILE AUTOBACKUP OFF;
              CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F';
              CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO COMPRESSED BACKUPSET;
              CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
              CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
              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 'C:\ORACLE\10.2.0\DATABASE\SNCFEFIN.ORA'; # default
              The following is from RMAN.log
              Recovery Manager: Release 10.2.0.4.0 - Production on Thu May 3 12:26:25 2012
              
              Copyright (c) 1982, 2007, Oracle.  All rights reserved.
              
              connected to target database: EFIN (DBID=3295381608)
              using target database control file instead of recovery catalog
              
              RMAN> SQL "ALTER SYSTEM ARCHIVE LOG CURRENT"; 
              2> backup database TAG 'FULL_BACKUP_20120503' plus archivelog ; 
              3> SQL "alter database backup controlfile to trace as ''D:\oracle\flash_recovery_area\efin\EFIN_TRACE\\CTrl_Bkp_Trace.trc''"; 
              4> crosscheck backup ; 
              5> crosscheck archivelog all; 
              6> report obsolete; 
              7> DELETE NOPROMPT FORCE OBSOLETE DEVICE TYPE DISK; 
              8> exit;
              sql statement: ALTER SYSTEM ARCHIVE LOG CURRENT
              
              
              Starting backup at 03-MAY-12
              current log archived
              allocated channel: ORA_DISK_1
              channel ORA_DISK_1: sid=337 devtype=DISK
              channel ORA_DISK_1: starting compressed archive log backupset
              channel ORA_DISK_1: specifying archive log(s) in backup set
              input archive log thread=1 sequence=24021 recid=23886 stamp=782297649
              input archive log thread=1 sequence=24022 recid=23887 stamp=782297902
              input archive log thread=1 sequence=24023 recid=23888 stamp=782297904
              input archive log thread=1 sequence=24024 recid=23889 stamp=782298064
              input archive log thread=1 sequence=24025 recid=23890 stamp=782298248
              input archive log thread=1 sequence=24026 recid=23891 stamp=782298251
              input archive log thread=1 sequence=24027 recid=23892 stamp=782298410
              input archive log thread=1 sequence=24028 recid=23893 stamp=782301600
              input archive log thread=1 sequence=24029 recid=23894 stamp=782303400
              input archive log thread=1 sequence=24030 recid=23895 stamp=782305200
              input archive log thread=1 sequence=24031 recid=23896 stamp=782307000
              input archive log thread=1 sequence=24032 recid=23897 stamp=782308802
              input archive log thread=1 sequence=24033 recid=23898 stamp=782309751
              input archive log thread=1 sequence=24034 recid=23899 stamp=782309751
              input archive log thread=1 sequence=24035 recid=23900 stamp=782309913
              input archive log thread=1 sequence=24036 recid=23901 stamp=782309963
              input archive log thread=1 sequence=24037 recid=23902 stamp=782309966
              input archive log thread=1 sequence=24038 recid=23903 stamp=782310125
              input archive log thread=1 sequence=24039 recid=23904 stamp=782310386
              input archive log thread=1 sequence=24040 recid=23905 stamp=782310389
              channel ORA_DISK_1: starting piece 1 at 03-MAY-12
              channel ORA_DISK_1: finished piece 1 at 03-MAY-12
              piece handle=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\BACKUPSET\2012_05_03\O1_MF_ANNNN_TAG20120503T122629_7T4TV6M4_.BKP tag=TAG20120503T122629 comment=NONE
              channel ORA_DISK_1: backup set complete, elapsed time: 00:00:04
              Finished backup at 03-MAY-12
              
              Starting backup at 03-MAY-12
              using channel ORA_DISK_1
              channel ORA_DISK_1: starting compressed full datafile backupset
              channel ORA_DISK_1: specifying datafile(s) in backupset
              input datafile fno=00006 name=I:\ORACLE\ORADATA\EFIN\EFINLIVE_DTS01.DBF
              input datafile fno=00005 name=H:\ORACLE\ORADATA\EFIN\EFINLIVE_ITS01.DBF
              input datafile fno=00003 name=H:\ORACLE\ORADATA\EFIN\SYSAUX01.DBF
              input datafile fno=00001 name=H:\ORACLE\ORADATA\EFIN\SYSTEM01.DBF
              input datafile fno=00002 name=G:\ORACLE\ORADATA\EFIN\UNDOTBS01.DBF
              input datafile fno=00007 name=I:\ORACLE\ORADATA\EFIN\EFINLIVE_RTS01.DBF
              input datafile fno=00008 name=I:\ORACLE\ORADATA\EFIN\BO_REP01.DBF
              input datafile fno=00009 name=C:\ORACLE\10.2.0\DATABASE\CMS_DTS.DBF
              input datafile fno=00010 name=I:\ORACLE\ORADATA\EFIN\PCRLIVE_DTS01.DBF
              input datafile fno=00004 name=H:\ORACLE\ORADATA\EFIN\USERS01.DBF
              channel ORA_DISK_1: starting piece 1 at 03-MAY-12
              channel ORA_DISK_1: finished piece 1 at 03-MAY-12
              piece handle=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\BACKUPSET\2012_05_03\O1_MF_NNNDF_FULL_BACKUP_20120503_7T4TV9SZ_.BKP tag=FULL_BACKUP_20120503 comment=NONE
              channel ORA_DISK_1: backup set complete, elapsed time: 00:02:35
              channel ORA_DISK_1: starting compressed full datafile backupset
              channel ORA_DISK_1: specifying datafile(s) in backupset
              including current control file in backupset
              including current SPFILE in backupset
              channel ORA_DISK_1: starting piece 1 at 03-MAY-12
              channel ORA_DISK_1: finished piece 1 at 03-MAY-12
              piece handle=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\BACKUPSET\2012_05_03\O1_MF_NCSNF_FULL_BACKUP_20120503_7T4V060H_.BKP tag=FULL_BACKUP_20120503 comment=NONE
              channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
              Finished backup at 03-MAY-12
              
              Starting backup at 03-MAY-12
              current log archived
              using channel ORA_DISK_1
              channel ORA_DISK_1: starting compressed archive log backupset
              channel ORA_DISK_1: specifying archive log(s) in backup set
              input archive log thread=1 sequence=24041 recid=23906 stamp=782310551
              channel ORA_DISK_1: starting piece 1 at 03-MAY-12
              channel ORA_DISK_1: finished piece 1 at 03-MAY-12
              piece handle=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\BACKUPSET\2012_05_03\O1_MF_ANNNN_TAG20120503T122911_7T4V085V_.BKP tag=TAG20120503T122911 comment=NONE
              channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
              Finished backup at 03-MAY-12
              
              sql statement: alter database backup controlfile to trace as ''D:\oracle\flash_recovery_area\efin\EFIN_TRACE\\CTrl_Bkp_Trace.trc'' 
              
              using channel ORA_DISK_1
              crosschecked backup piece: found to be 'AVAILABLE'
              backup piece handle=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\BACKUPSET\2012_04_29\O1_MF_NNNDF_FULL_BACKUP_20120429_7SV25H1N_.BKP recid=6926 stamp=781903807
              crosschecked backup piece: found to be 'AVAILABLE'
              backup piece handle=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\BACKUPSET\2012_04_29\O1_MF_ANNNN_TAG20120429T193242_7SV2BC6X_.BKP recid=6927 stamp=781903963
              crosschecked backup piece: found to be 'AVAILABLE'
              backup piece handle=C:\ORACLE\10.2.0\DATABASE\C-3295381608-20120429-00 recid=6928 stamp=781903964
              crosschecked backup piece: found to be 'AVAILABLE'
              backup piece handle=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\BACKUPSET\2012_04_30\O1_MF_ANNNN_TAG20120430T193002_7SXPKCKB_.BKP recid=6929 stamp=781990203
              crosschecked backup piece: found to be 'AVAILABLE'
              backup piece handle=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\BACKUPSET\2012_04_30\O1_MF_NNNDF_FULL_BACKUP_20120430_7SXPKLT3_.BKP recid=6930 stamp=781990210
              crosschecked backup piece: found to be 'AVAILABLE'
              backup piece handle=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\BACKUPSET\2012_04_30\O1_MF_ANNNN_TAG20120430T193245_7SXPPH04_.BKP recid=6931 stamp=781990367
              crosschecked backup piece: found to be 'AVAILABLE'
              backup piece handle=C:\ORACLE\10.2.0\DATABASE\C-3295381608-20120430-00 recid=6932 stamp=781990368
              crosschecked backup piece: found to be 'AVAILABLE'
              backup piece handle=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\BACKUPSET\2012_05_01\O1_MF_ANNNN_TAG20120501T193002_7T0BXCKW_.BKP recid=6937 stamp=782163003
              crosschecked backup piece: found to be 'AVAILABLE'
              backup piece handle=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\BACKUPSET\2012_05_01\O1_MF_NNNDF_FULL_BACKUP_20120501_7T0BXLTO_.BKP recid=6938 stamp=782163010
              crosschecked backup piece: found to be 'AVAILABLE'
              backup piece handle=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\BACKUPSET\2012_05_01\O1_MF_ANNNN_TAG20120501T193245_7T0C2H15_.BKP recid=6939 stamp=782163167
              crosschecked backup piece: found to be 'AVAILABLE'
              backup piece handle=C:\ORACLE\10.2.0\DATABASE\C-3295381608-20120501-00 recid=6940 stamp=782163168
              crosschecked backup piece: found to be 'AVAILABLE'
              backup piece handle=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\BACKUPSET\2012_05_02\O1_MF_ANNNN_TAG20120502T193002_7T2Z9CRC_.BKP recid=6945 stamp=782249403
              crosschecked backup piece: found to be 'AVAILABLE'
              backup piece handle=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\BACKUPSET\2012_05_02\O1_MF_NNNDF_FULL_BACKUP_20120502_7T2Z9M1W_.BKP recid=6946 stamp=782249411
              crosschecked backup piece: found to be 'AVAILABLE'
              backup piece handle=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\BACKUPSET\2012_05_02\O1_MF_ANNNN_TAG20120502T193246_7T2ZGH75_.BKP recid=6947 stamp=782249567
              crosschecked backup piece: found to be 'AVAILABLE'
              backup piece handle=C:\ORACLE\10.2.0\DATABASE\C-3295381608-20120502-00 recid=6948 stamp=782249568
              crosschecked backup piece: found to be 'AVAILABLE'
              backup piece handle=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\BACKUPSET\2012_05_03\O1_MF_ANNNN_TAG20120503T085824_7T4GO1O7_.BKP recid=6953 stamp=782297905
              crosschecked backup piece: found to be 'AVAILABLE'
              backup piece handle=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\BACKUPSET\2012_05_03\O1_MF_NNNDF_FULL_BACKUP_20120503_7T4GO4XJ_.BKP recid=6954 stamp=782297908
              crosschecked backup piece: found to be 'AVAILABLE'
              backup piece handle=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\BACKUPSET\2012_05_03\O1_MF_ANNNN_TAG20120503T090104_7T4GT15J_.BKP recid=6955 stamp=782298065
              crosschecked backup piece: found to be 'AVAILABLE'
              backup piece handle=C:\ORACLE\10.2.0\DATABASE\C-3295381608-20120503-00 recid=6956 stamp=782298066
              crosschecked backup piece: found to be 'AVAILABLE'
              backup piece handle=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\BACKUPSET\2012_05_03\O1_MF_ANNNN_TAG20120503T090411_7T4GZWL2_.BKP recid=6957 stamp=782298252
              crosschecked backup piece: found to be 'AVAILABLE'
              backup piece handle=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\BACKUPSET\2012_05_03\O1_MF_NNNDF_FULL_BACKUP_20120503_7T4GZZRX_.BKP recid=6958 stamp=782298255
              crosschecked backup piece: found to be 'AVAILABLE'
              backup piece handle=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\BACKUPSET\2012_05_03\O1_MF_ANNNN_TAG20120503T090650_7T4H4VY6_.BKP recid=6959 stamp=782298411
              crosschecked backup piece: found to be 'AVAILABLE'
              backup piece handle=C:\ORACLE\10.2.0\DATABASE\C-3295381608-20120503-01 recid=6960 stamp=782298413
              crosschecked backup piece: found to be 'AVAILABLE'
              backup piece handle=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\BACKUPSET\2012_05_03\O1_MF_NCNNF_TAG20120503T091556_7T4HOWVX_.BKP recid=6961 stamp=782298956
              crosschecked backup piece: found to be 'AVAILABLE'
              backup piece handle=C:\ORACLE\10.2.0\DATABASE\C-3295381608-20120503-02 recid=6962 stamp=782298958
              crosschecked backup piece: found to be 'AVAILABLE'
              backup piece handle=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\BACKUPSET\2012_05_03\O1_MF_ANNNN_TAG20120503T121551_7T4T790H_.BKP recid=6963 stamp=782309753
              crosschecked backup piece: found to be 'AVAILABLE'
              backup piece handle=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\BACKUPSET\2012_05_03\O1_MF_NNNDF_FULL_BACKUP_20120503_7T4T7D99_.BKP recid=6964 stamp=782309756
              crosschecked backup piece: found to be 'AVAILABLE'
              backup piece handle=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\BACKUPSET\2012_05_03\O1_MF_NCSNF_FULL_BACKUP_20120503_7T4TD8H1_.BKP recid=6965 stamp=782309912
              crosschecked backup piece: found to be 'AVAILABLE'
              backup piece handle=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\BACKUPSET\2012_05_03\O1_MF_ANNNN_TAG20120503T121833_7T4TDBNF_.BKP recid=6966 stamp=782309914
              crosschecked backup piece: found to be 'AVAILABLE'
              backup piece handle=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\BACKUPSET\2012_05_03\O1_MF_ANNNN_TAG20120503T121926_7T4TFZKG_.BKP recid=6967 stamp=782309967
              crosschecked backup piece: found to be 'AVAILABLE'
              backup piece handle=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\BACKUPSET\2012_05_03\O1_MF_NNNDF_FULL_BACKUP_20120503_7T4TG2RR_.BKP recid=6968 stamp=782309970
              crosschecked backup piece: found to be 'AVAILABLE'
              backup piece handle=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\BACKUPSET\2012_05_03\O1_MF_ANNNN_TAG20120503T122205_7T4TLYYK_.BKP recid=6969 stamp=782310126
              crosschecked backup piece: found to be 'AVAILABLE'
              backup piece handle=C:\ORACLE\10.2.0\DATABASE\C-3295381608-20120503-03 recid=6970 stamp=782310128
              crosschecked backup piece: found to be 'AVAILABLE'
              backup piece handle=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\BACKUPSET\2012_05_03\O1_MF_ANNNN_TAG20120503T122629_7T4TV6M4_.BKP recid=6971 stamp=782310390
              crosschecked backup piece: found to be 'AVAILABLE'
              backup piece handle=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\BACKUPSET\2012_05_03\O1_MF_NNNDF_FULL_BACKUP_20120503_7T4TV9SZ_.BKP recid=6972 stamp=782310393
              crosschecked backup piece: found to be 'AVAILABLE'
              backup piece handle=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\BACKUPSET\2012_05_03\O1_MF_NCSNF_FULL_BACKUP_20120503_7T4V060H_.BKP recid=6973 stamp=782310550
              crosschecked backup piece: found to be 'AVAILABLE'
              backup piece handle=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\BACKUPSET\2012_05_03\O1_MF_ANNNN_TAG20120503T122911_7T4V085V_.BKP recid=6974 stamp=782310552
              Crosschecked 37 objects
              
              
              released channel: ORA_DISK_1
              allocated channel: ORA_DISK_1
              channel ORA_DISK_1: sid=337 devtype=DISK
              validation succeeded for archived log
              archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\ARCHIVELOG\2012_05_03\O1_MF_1_24021_7T4GF0OD_.ARC recid=23886 stamp=782297649
              validation succeeded for archived log
              archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\ARCHIVELOG\2012_05_03\O1_MF_1_24022_7T4GNY3N_.ARC recid=23887 stamp=782297902
              validation succeeded for archived log
              archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\ARCHIVELOG\2012_05_03\O1_MF_1_24023_7T4GO081_.ARC recid=23888 stamp=782297904
              validation succeeded for archived log
              archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\ARCHIVELOG\2012_05_03\O1_MF_1_24024_7T4GSZYW_.ARC recid=23889 stamp=782298064
              validation succeeded for archived log
              archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\ARCHIVELOG\2012_05_03\O1_MF_1_24025_7T4GZRNJ_.ARC recid=23890 stamp=782298248
              validation succeeded for archived log
              archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\ARCHIVELOG\2012_05_03\O1_MF_1_24026_7T4GZV5W_.ARC recid=23891 stamp=782298251
              validation succeeded for archived log
              archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\ARCHIVELOG\2012_05_03\O1_MF_1_24027_7T4H4TT9_.ARC recid=23892 stamp=782298410
              validation succeeded for archived log
              archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\ARCHIVELOG\2012_05_03\O1_MF_1_24028_7T4L8JFN_.ARC recid=23893 stamp=782301600
              validation succeeded for archived log
              archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\ARCHIVELOG\2012_05_03\O1_MF_1_24029_7T4N0RCL_.ARC recid=23894 stamp=782303400
              validation succeeded for archived log
              archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\ARCHIVELOG\2012_05_03\O1_MF_1_24030_7T4OS0DY_.ARC recid=23895 stamp=782305200
              validation succeeded for archived log
              archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\ARCHIVELOG\2012_05_03\O1_MF_1_24031_7T4QK86H_.ARC recid=23896 stamp=782307000
              validation succeeded for archived log
              archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\ARCHIVELOG\2012_05_03\O1_MF_1_24032_7T4S9L20_.ARC recid=23897 stamp=782308802
              validation succeeded for archived log
              archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\ARCHIVELOG\2012_05_03\O1_MF_1_24033_7T4T777T_.ARC recid=23898 stamp=782309751
              validation succeeded for archived log
              archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\ARCHIVELOG\2012_05_03\O1_MF_1_24034_7T4T77F6_.ARC recid=23899 stamp=782309751
              validation succeeded for archived log
              archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\ARCHIVELOG\2012_05_03\O1_MF_1_24035_7T4TD9JZ_.ARC recid=23900 stamp=782309913
              validation succeeded for archived log
              archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\ARCHIVELOG\2012_05_03\O1_MF_1_24036_7T4TFVBM_.ARC recid=23901 stamp=782309963
              validation succeeded for archived log
              archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\ARCHIVELOG\2012_05_03\O1_MF_1_24037_7T4TFY39_.ARC recid=23902 stamp=782309966
              validation succeeded for archived log
              archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\ARCHIVELOG\2012_05_03\O1_MF_1_24038_7T4TLXT4_.ARC recid=23903 stamp=782310125
              validation succeeded for archived log
              archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\ARCHIVELOG\2012_05_03\O1_MF_1_24039_7T4TV2WF_.ARC recid=23904 stamp=782310386
              validation succeeded for archived log
              archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\ARCHIVELOG\2012_05_03\O1_MF_1_24040_7T4TV531_.ARC recid=23905 stamp=782310389
              validation succeeded for archived log
              archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\EFIN\ARCHIVELOG\2012_05_03\O1_MF_1_24041_7T4V072G_.ARC recid=23906 stamp=782310551
              Crosschecked 21 objects
              
              
              RMAN retention policy will be applied to the command
              RMAN retention policy is set to recovery window of 3 days
              Report of obsolete backups and copies
              Type                 Key    Completion Time    Filename/Handle
              -------------------- ------ ------------------ --------------------
              Backup Set           6777   09-APR-12         
                Backup Piece       6777   09-APR-12          EFIN_k0n81bbr_1_1
              Backup Set           6778   09-APR-12         
                Backup Piece       6778   09-APR-12          EFIN_k1n81bcc_1_1
              Backup Set           6779   09-APR-12         
                Backup Piece       6779   09-APR-12          EFIN_k2n81bed_1_1
              Backup Set           6780   09-APR-12         
                Backup Piece       6780   09-APR-12          CONTROLFILE.EFIN.c-3295381608-20120409-01
              Backup Set           6785   10-APR-12         
                Backup Piece       6785   10-APR-12          EFIN_k8n8400g_1_1
              Backup Set           6786   10-APR-12         
                Backup Piece       6786   10-APR-12          EFIN_k9n84010_1_1
              Backup Set           6787   10-APR-12         
                Backup Piece       6787   10-APR-12          EFIN_kan8402o_1_1
              Backup Set           6788   10-APR-12         
                Backup Piece       6788   10-APR-12          CONTROLFILE.EFIN.c-3295381608-20120410-01
              Backup Set           6793   11-APR-12         
                Backup Piece       6793   11-APR-12          EFIN_kgn86k1u_1_1
              Backup Set           6794   11-APR-12         
                Backup Piece       6794   11-APR-12          EFIN_khn86k2f_1_1
              Backup Set           6795   11-APR-12         
                Backup Piece       6795   11-APR-12          EFIN_kin86k4g_1_1
              Backup Set           6796   11-APR-12         
                Backup Piece       6796   11-APR-12          CONTROLFILE.EFIN.c-3295381608-20120411-01
              Backup Set           6801   12-APR-12         
                Backup Piece       6801   12-APR-12          EFIN_kon898e1_1_1
              Backup Set           6802   12-APR-12         
                Backup Piece       6802   12-APR-12          EFIN_kpn898ei_1_1
              Backup Set           6803   12-APR-12         
                Backup Piece       6803   12-APR-12          EFIN_kqn898g9_1_1
              Backup Set           6804   12-APR-12         
                Backup Piece       6804   12-APR-12          CONTROLFILE.EFIN.c-3295381608-20120412-01
              Backup Set           6809   13-APR-12         
                Backup Piece       6809   13-APR-12          EFIN_l0n8bspr_1_1
              Backup Set           6810   13-APR-12         
                Backup Piece       6810   13-APR-12          EFIN_l1n8bsqc_1_1
              Backup Set           6811   13-APR-12         
                Backup Piece       6811   13-APR-12          EFIN_l2n8bssn_1_1
              Backup Set           6812   13-APR-12         
                Backup Piece       6812   13-APR-12          CONTROLFILE.EFIN.c-3295381608-20120413-01
              Backup Set           6817   14-APR-12         
                Backup Piece       6817   14-APR-12          EFIN_l8n8ehfa_1_1
              Backup Set           6818   14-APR-12         
                Backup Piece       6818   14-APR-12          EFIN_l9n8ehfj_1_1
              Backup Set           6819   14-APR-12         
                Backup Piece       6819   14-APR-12          EFIN_lan8ehha_1_1
              Backup Set           6820   14-APR-12         
                Backup Piece       6820   14-APR-12          CONTROLFILE.EFIN.c-3295381608-20120414-01
              Backup Set           6829   16-APR-12         
                Backup Piece       6829   16-APR-12          EFIN_lkn8jpvo_1_1
              Backup Set           6830   16-APR-12         
                Backup Piece       6830   16-APR-12          EFIN_lln8jq09_1_1
              Backup Set           6831   16-APR-12         
                Backup Piece       6831   16-APR-12          EFIN_lmn8jq20_1_1
              Backup Set           6832   16-APR-12         
                Backup Piece       6832   16-APR-12          CONTROLFILE.EFIN.c-3295381608-20120416-01
              Backup Set           6837   17-APR-12         
                Backup Piece       6837   17-APR-12          EFIN_lsn8memc_1_1
              Backup Set           6838   17-APR-12         
                Backup Piece       6838   17-APR-12          EFIN_ltn8mems_1_1
              Backup Set           6839   17-APR-12         
                Backup Piece       6839   17-APR-12          EFIN_lun8meok_1_1
              Backup Set           6840   17-APR-12         
                Backup Piece       6840   17-APR-12          CONTROLFILE.EFIN.c-3295381608-20120417-01
              Backup Set           6845   18-APR-12         
                Backup Piece       6845   18-APR-12          EFIN_m4n8p2p8_1_1
              Backup Set           6846   18-APR-12         
                Backup Piece       6846   18-APR-12          EFIN_m5n8p2pp_1_1
              Backup Set           6847   18-APR-12         
                Backup Piece       6847   18-APR-12          EFIN_m6n8p2rq_1_1
              Backup Set           6848   18-APR-12         
                Backup Piece       6848   18-APR-12          CONTROLFILE.EFIN.c-3295381608-20120418-01
              Backup Set           6853   19-APR-12         
                Backup Piece       6853   19-APR-12          EFIN_mcn8rndr_1_1
              Backup Set           6854   19-APR-12         
                Backup Piece       6854   19-APR-12          EFIN_mdn8rne3_1_1
              Backup Set           6855   19-APR-12         
                Backup Piece       6855   19-APR-12          EFIN_men8rng4_1_1
              Backup Set           6856   19-APR-12         
                Backup Piece       6856   19-APR-12          CONTROLFILE.EFIN.c-3295381608-20120419-01
              Backup Set           6861   20-APR-12         
                Backup Piece       6861   20-APR-12          EFIN_mkn8ubfl_1_1
              Backup Set           6862   20-APR-12         
                Backup Piece       6862   20-APR-12          EFIN_mln8ubg5_1_1
              Backup Set           6863   20-APR-12         
                Backup Piece       6863   20-APR-12          EFIN_mmn8ubht_1_1
              Backup Set           6864   20-APR-12         
                Backup Piece       6864   20-APR-12          CONTROLFILE.EFIN.c-3295381608-20120420-01
              Backup Set           6869   21-APR-12         
                Backup Piece       6869   21-APR-12          EFIN_msn90vrk_1_1
              Backup Set           6870   21-APR-12         
                Backup Piece       6870   21-APR-12          EFIN_mtn90vs4_1_1
              Backup Set           6871   21-APR-12         
                Backup Piece       6871   21-APR-12          EFIN_mun90vts_1_1
              Backup Set           6872   21-APR-12         
                Backup Piece       6872   21-APR-12          CONTROLFILE.EFIN.c-3295381608-20120421-01
              Backup Set           6881   23-APR-12         
                Backup Piece       6881   23-APR-12          EFIN_n8n968jk_1_1
              Backup Set           6882   23-APR-12         
                Backup Piece       6882   23-APR-12          EFIN_n9n968k5_1_1
              Backup Set           6883   23-APR-12         
                Backup Piece       6883   23-APR-12          EFIN_nan968m6_1_1
              Backup Set           6884   23-APR-12         
                Backup Piece       6884   23-APR-12          CONTROLFILE.EFIN.c-3295381608-20120423-01
              Backup Set           6889   24-APR-12         
                Backup Piece       6889   24-APR-12          EFIN_ngn98ta2_1_1
              Backup Set           6890   24-APR-12         
                Backup Piece       6890   24-APR-12          EFIN_nhn98taj_1_1
              Backup Set           6891   24-APR-12         
                Backup Piece       6891   24-APR-12          EFIN_nin98tck_1_1
              Backup Set           6892   24-APR-12         
                Backup Piece       6892   24-APR-12          CONTROLFILE.EFIN.c-3295381608-20120424-01
              Backup Set           6897   25-APR-12         
                Backup Piece       6897   25-APR-12          EFIN_non9bhbj_1_1
              Backup Set           6898   25-APR-12         
                Backup Piece       6898   25-APR-12          EFIN_npn9bhc4_1_1
              Backup Set           6899   25-APR-12         
                Backup Piece       6899   25-APR-12          EFIN_nqn9bhe5_1_1
              Backup Set           6900   25-APR-12         
                Backup Piece       6900   25-APR-12          CONTROLFILE.EFIN.c-3295381608-20120425-01
              Backup Set           6905   26-APR-12         
                Backup Piece       6905   26-APR-12          EFIN_o0n9e5nj_1_1
              Backup Set           6906   26-APR-12         
                Backup Piece       6906   26-APR-12          EFIN_o1n9e5o3_1_1
              Backup Set           6907   26-APR-12         
                Backup Piece       6907   26-APR-12          EFIN_o2n9e5q5_1_1
              Backup Set           6908   26-APR-12         
                Backup Piece       6908   26-APR-12          CONTROLFILE.EFIN.c-3295381608-20120426-01
              Backup Set           6913   27-APR-12         
                Backup Piece       6913   27-APR-12          EFIN_o8n9gq3i_1_1
              Backup Set           6914   27-APR-12         
                Backup Piece       6914   27-APR-12          EFIN_o9n9gq3q_1_1
              Backup Set           6915   27-APR-12         
                Backup Piece       6915   27-APR-12          EFIN_oan9gq5i_1_1
              Backup Set           6916   27-APR-12         
                Backup Piece       6916   27-APR-12          CONTROLFILE.EFIN.c-3295381608-20120427-01
              Backup Set           6921   28-APR-12         
                Backup Piece       6921   28-APR-12          EFIN_ogn9jefg_1_1
              Backup Set           6922   28-APR-12         
                Backup Piece       6922   28-APR-12          EFIN_ohn9jefp_1_1
              Backup Set           6923   28-APR-12         
                Backup Piece       6923   28-APR-12          EFIN_oin9jehg_1_1
              Backup Set           6924   28-APR-12         
                Backup Piece       6924   28-APR-12          CONTROLFILE.EFIN.c-3295381608-20120428-01
              
              RMAN retention policy will be applied to the command
              RMAN retention policy is set to recovery window of 3 days
              released channel: ORA_DISK_1
              allocated channel: ORA_DISK_1
              channel ORA_DISK_1: sid=337 devtype=DISK
              no obsolete backups found
              
              Recovery Manager complete.
              • 4. Re: autobackup of controlfile
                621100
                you have to give the full name of the file (location + file name ) in the configure command ,for autobackup to take the location.

                CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO <full path/file name>
                • 5. Re: autobackup of controlfile
                  user106161
                  Hi,
                  Thanks for your response.
                  I have another database on the same server.Both have same RMAN config. The other one takes backup to FRA(without setting CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO <full path/file name>).

                  In my view setting below parameter should be good enough to take backup of controlfile to FRA
                  CONFIGURE CONTROLFILE AUTOBACKUP ON;

                  Regards
                  • 6. Re: autobackup of controlfile
                    Shivananda Rao
                    Please try this.
                    RMAN>configure controlfile autobackup format for device type disk clear;
                    RMAN>configure controlfile autobackup on;
                    By default, RMAN places the autoabackup of the controlfile to the FRA if configured. If you require a location other than FRA, then you need to specify the controlfile backup format to the location you require.
                    • 7. Re: autobackup of controlfile
                      user106161
                      Hi,
                      Thats what I want. I want RMAN to place the autobackup of controlfile in FRA.
                      Every time I take a backup it goes to some other location which I didnot even configure.

                      My RMAN configuration
                      CONFIGURE CONTROLFILE AUTOBACKUP ON;
                      CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default 
                      • 8. Re: autobackup of controlfile
                        tychos
                        Hi user12951692,

                        Okay, I am with you now.
                        This is the plan.
                        Set all but the 'controfile autobackup' back to the default value.
                        CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK CLEAR;
                        CONFIGURE DEVICE TYPE DISK CLEAR;
                        CONFIGURE BACKUP OPTIMIZATION CLEAR;
                        CONFIGURE DEFAULT DEVICE TYPE CLEAR;
                        CONFIGURE RETENTION POLICY CLEAR;
                        Check with show all to confirm only:
                        CONFIGURE CONTROLFILE AUTOBACKUP ON;
                        is none default.
                        Run a small backup.
                        backup spfile;
                        This should backup to FRA.
                        Now bring in a setting like:
                        CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 3 DAYS;
                        Again run a backup of the spfile.
                        Repeat the process with the other none default settings until the controlfile autobackup swithes to a none FRA location.
                        Regards,
                        Tycho
                        • 9. Re: autobackup of controlfile
                          726263
                          I am pretty sure RMAN uses this backup of the control file during the backup as temporary.
                          There is a backup in the FRA as well when done.
                          These will be delete when you run delete obsolete copies.

                          Regards,
                          KDSDBA
                          • 10. Re: autobackup of controlfile
                            Levi Pereira
                            Hi,
                            Thats what I want. I want RMAN to place the autobackup of controlfile in FRA.
                            Every time I take a backup it goes to some other location which I didnot even configure.
                            I've helped others with this issue before, see why this happens:
                            {message:id=10196105}

                            Regards,
                            Levi Pereira
                            • 11. Re: autobackup of controlfile
                              user106161
                              Hi All;

                              Thanks for your replies. Sorry for my late response as I was not in the office.

                              @tychos :

                              I did what you suggested. It seems to work now. :)
                              Thanks for your help.

                              @Levi Pereira :

                              Thanks for your link. It was helpful :)

                              Regards