This discussion is archived
11 Replies Latest reply: May 9, 2012 3:32 AM by user106161 RSS

autobackup of controlfile

user106161 Newbie
Currently Being Moderated
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 Expert
    Currently Being Moderated
    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
    KuljeetPalSingh Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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

Legend

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