5 Replies Latest reply: Nov 21, 2012 2:53 AM by Hemant K Chitale RSS

    Control File issue

    user11982706
      Hi All,

      11.2.0.1 on AIX 7.1 and Level 0 happens on every SATURDAY and L1 backup run every day.

      We are using following script for level0 RMAN backup:
      RUN {
      SHOW ALL;
      CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 4;
      CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
      ALLOCATE CHANNEL ch1 TYPE DISK;
      ALLOCATE CHANNEL ch2 TYPE DISK;
      ALLOCATE CHANNEL ch3 TYPE DISK;
      ALLOCATE CHANNEL ch4 TYPE DISK;
       BACKUP FORMAT '/oraclebackup/HFM11PROD/DF_L0_%d_%D%M%Y_%u_%s_%p' INCREMENTAL LEVEL 0 AS COMPRESSED BACKUPSET DATABASE TAG='LEVEL0';
       BACKUP FORMAT '/oraclebackup/HFM11PROD/ARC_L0_%d_%D%M%Y_%u_%s_%p'   ARCHIVELOG ALL NOT BACKED UP 2 TIMES TAG='LEVEL0';
       BACKUP FORMAT '/oraclebackup/HFM11PROD/CF_L0_%d_%D%M%Y_%u_%s_%p' CURRENT CONTROLFILE TAG='LEVEL0';
       BACKUP FORMAT '/oraclebackup/HFM11PROD/SP_L0_%d_%D%M%Y_%u_%s_%p' SPFILE TAG='LEVEL0';
       CROSSCHECK ARCHIVELOG ALL;
       DELETE NOPROMPT OBSOLETE;
      RELEASE CHANNEL ch1;
      RELEASE CHANNEL ch2;
      RELEASE CHANNEL ch3;
      RELEASE CHANNEL ch4;
      }
      Now backup logs shows that we have backup of control file in two backup pieces : One implicitly in a backup piece DF_L0_HFM11PRD_10112012_l8npv5b6_13992_1
      and other one is explicitly in CF_L0_HFM11PRD_10112012_lhnpv62e_14001_1 .
      RMAN> RUN {
      2> SHOW ALL;
      3> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 4;
      4> CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
      5> ALLOCATE CHANNEL ch1 TYPE DISK;
      6> ALLOCATE CHANNEL ch2 TYPE DISK;
      7> ALLOCATE CHANNEL ch3 TYPE DISK;
      8> ALLOCATE CHANNEL ch4 TYPE DISK;
      9> BACKUP FORMAT '/oraclebackup/HFM11PROD/DF_L0_%d_%D%M%Y_%u_%s_%p' INCREMENTAL LEVEL 0 AS COMPRESSED BACKUPSET DATABASE TAG='LEVEL0';
      10> BACKUP FORMAT '/oraclebackup/HFM11PROD/ARC_L0_%d_%D%M%Y_%u_%s_%p'   ARCHIVELOG ALL NOT BACKED UP 2 TIMES TAG='LEVEL0';
      11> BACKUP FORMAT '/oraclebackup/HFM11PROD/CF_L0_%d_%D%M%Y_%u_%s_%p' CURRENT CONTROLFILE TAG='LEVEL0';
      12> BACKUP FORMAT '/oraclebackup/HFM11PROD/SP_L0_%d_%D%M%Y_%u_%s_%p' SPFILE TAG='LEVEL0';
      13> CROSSCHECK ARCHIVELOG ALL;
      14> DELETE NOPROMPT OBSOLETE;
      15> RELEASE CHANNEL ch1;
      16> RELEASE CHANNEL ch2;
      17> RELEASE CHANNEL ch3;
      18> RELEASE CHANNEL ch4;
      19> }
      RMAN configuration parameters for database with db_unique_name HFM11PRD are:
      CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
      CONFIGURE BACKUP OPTIMIZATION OFF; # default
      CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
      CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
      CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
      CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 4;
      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 COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
      CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
      CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/orahyp_p/product/11.2/dbs/snapcf_HFM11PRD.f'; # default
      
      old RMAN configuration parameters:
      CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 4;
      new RMAN configuration parameters:
      CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 4;
      new RMAN configuration parameters are successfully stored
      starting full resync of recovery catalog
      full resync complete
      
      old RMAN configuration parameters:
      CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
      new RMAN configuration parameters:
      CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
      new RMAN configuration parameters are successfully stored
      starting full resync of recovery catalog
      full resync complete
      
      allocated channel: ch1
      channel ch1: SID=1210 device type=DISK
      
      allocated channel: ch2
      channel ch2: SID=1477 device type=DISK
      
      allocated channel: ch3
      channel ch3: SID=66 device type=DISK
      
      allocated channel: ch4
      channel ch4: SID=1156 device type=DISK
      
      Starting backup at 10-NOV-12
      channel ch1: starting compressed incremental level 0 datafile backup set
      channel ch1: specifying datafile(s) in backup set
      input datafile file number=00001 name=/u04/oradata/HFM11PRD/system01.dbf
      input datafile file number=00008 name=/u04/oradata/HFM11PRD/EPM_HFM4.DBF
      input datafile file number=00012 name=/u04/oradata/HFM11PRD/EPM_HFM8.DBF
      input datafile file number=00017 name=/u04/oradata/HFM11PRD/EPM_HFM12.DBF
      input datafile file number=00004 name=/u04/oradata/HFM11PRD/EPM_HSS1.DBF
      input datafile file number=00020 name=/u04/oradata/HFM11PRD/EPM_HFM3.DBF
      channel ch1: starting piece 1 at 10-NOV-12
      channel ch2: starting compressed incremental level 0 datafile backup set
      channel ch2: specifying datafile(s) in backup set
      input datafile file number=00003 name=/u04/oradata/HFM11PRD/undots01.dbf
      input datafile file number=00009 name=/u04/oradata/HFM11PRD/EPM_HFM5.DBF
      input datafile file number=00013 name=/u04/oradata/HFM11PRD/EPM_HFM9.DBF
      input datafile file number=00018 name=/u04/oradata/HFM11PRD/EPM_HFM13.DBF
      input datafile file number=00005 name=/u04/oradata/HFM11PRD/EPM_BI1.DBF
      input datafile file number=00021 name=/u04/oradata/HFM11PRD/EPM_HFM15.DBF
      channel ch2: starting piece 1 at 10-NOV-12
      channel ch3: starting compressed incremental level 0 datafile backup set
      channel ch3: specifying datafile(s) in backup set
      input datafile file number=00007 name=/u04/oradata/HFM11PRD/EPM_HFM2.DBF
      input datafile file number=00011 name=/u04/oradata/HFM11PRD/EPM_HFM7.DBF
      input datafile file number=00016 name=/u04/oradata/HFM11PRD/EPM_HFM11.DBF
      input datafile file number=00002 name=/u04/oradata/HFM11PRD/sysaux01.dbf
      input datafile file number=00022 name=/u04/oradata/HFM11PRD/EPM_HSS_new1.DBF
      channel ch3: starting piece 1 at 10-NOV-12
      channel ch4: starting compressed incremental level 0 datafile backup set
      channel ch4: specifying datafile(s) in backup set
      input datafile file number=00006 name=/u04/oradata/HFM11PRD/EPM_HFM1.DBF
      input datafile file number=00010 name=/u04/oradata/HFM11PRD/EPM_HFM6.DBF
      input datafile file number=00015 name=/u04/oradata/HFM11PRD/EPM_HFM10.DBF
      input datafile file number=00019 name=/u04/oradata/HFM11PRD/EPM_HFM14.DBF
      input datafile file number=00014 name=/u04/oradata/HFM11PRD/userdata01.dbf
      channel ch4: starting piece 1 at 10-NOV-12
      channel ch2: finished piece 1 at 10-NOV-12
      _*piece handle=/oraclebackup/HFM11PROD/DF_L0_HFM11PRD_10112012_l8npv5b6_13992_1 tag=LEVEL0 comment=NONE*_
      channel ch2: backup set complete, elapsed time: 00:10:46
      channel ch2: starting compressed incremental level 0 datafile backup set
      channel ch2: specifying datafile(s) in backup set
      _*including current control file in backup set*channel ch2: starting piece 1 at 10-NOV-12_
      channel ch2: finished piece 1 at 10-NOV-12
      piece handle=/oraclebackup/HFM11PROD/DF_L0_HFM11PRD_10112012_lbnpv5vc_13995_1 tag=LEVEL0 comment=NONE
      channel ch2: backup set complete, elapsed time: 00:00:01
      channel ch2: starting compressed incremental level 0 datafile backup set
      channel ch2: specifying datafile(s) in backup set
      including current SPFILE in backup set
      channel ch2: starting piece 1 at 10-NOV-12
      channel ch2: finished piece 1 at 10-NOV-12
      piece handle=/oraclebackup/HFM11PROD/DF_L0_HFM11PRD_10112012_lcnpv5ve_13996_1 tag=LEVEL0 comment=NONE
      channel ch2: backup set complete, elapsed time: 00:00:01
      channel ch1: finished piece 1 at 10-NOV-12
      piece handle=/oraclebackup/HFM11PROD/DF_L0_HFM11PRD_10112012_l7npv5b6_13991_1 tag=LEVEL0 comment=NONE
      channel ch1: backup set complete, elapsed time: 00:11:03
      channel ch4: finished piece 1 at 10-NOV-12
      piece handle=/oraclebackup/HFM11PROD/DF_L0_HFM11PRD_10112012_lanpv5b7_13994_1 tag=LEVEL0 comment=NONE
      channel ch4: backup set complete, elapsed time: 00:11:32
      channel ch3: finished piece 1 at 10-NOV-12
      piece handle=/oraclebackup/HFM11PROD/DF_L0_HFM11PRD_10112012_l9npv5b6_13993_1 tag=LEVEL0 comment=NONE
      channel ch3: backup set complete, elapsed time: 00:11:52
      Finished backup at 10-NOV-12
      
      Starting backup at 10-NOV-12
      current log archived
      channel ch1: starting compressed archived log backup set
      channel ch1: specifying archived log(s) in backup set
      input archived log thread=1 sequence=40007 RECID=40001 STAMP=798971664
      input archived log thread=1 sequence=40008 RECID=40002 STAMP=798972711
      input archived log thread=1 sequence=40009 RECID=40003 STAMP=798973470
      input archived log thread=1 sequence=40010 RECID=40004 STAMP=798974835
      input archived log thread=1 sequence=40011 RECID=40005 STAMP=798975943
      channel ch1: starting piece 1 at 10-NOV-12
      channel ch2: starting compressed archived log backup set
      channel ch2: specifying archived log(s) in backup set
      input archived log thread=1 sequence=40012 RECID=40006 STAMP=798976804
      input archived log thread=1 sequence=40013 RECID=40007 STAMP=798977866
      input archived log thread=1 sequence=40014 RECID=40008 STAMP=798978754
      input archived log thread=1 sequence=40015 RECID=40009 STAMP=798980083
      input archived log thread=1 sequence=40016 RECID=40010 STAMP=798981194
      channel ch2: starting piece 1 at 10-NOV-12
      channel ch3: starting compressed archived log backup set
      channel ch3: specifying archived log(s) in backup set
      input archived log thread=1 sequence=40017 RECID=40011 STAMP=798982283
      input archived log thread=1 sequence=40018 RECID=40012 STAMP=798983171
      input archived log thread=1 sequence=40019 RECID=40013 STAMP=798984077
      input archived log thread=1 sequence=40020 RECID=40014 STAMP=798985146
      input archived log thread=1 sequence=40021 RECID=40015 STAMP=798985212
      channel ch3: starting piece 1 at 10-NOV-12
      channel ch4: starting compressed archived log backup set
      channel ch4: specifying archived log(s) in backup set
      input archived log thread=1 sequence=40022 RECID=40016 STAMP=798985214
      input archived log thread=1 sequence=40023 RECID=40017 STAMP=798985992
      input archived log thread=1 sequence=40024 RECID=40018 STAMP=798987561
      input archived log thread=1 sequence=40025 RECID=40019 STAMP=798988338
      channel ch4: starting piece 1 at 10-NOV-12
      channel ch4: finished piece 1 at 10-NOV-12
      piece handle=/oraclebackup/HFM11PROD/ARC_L0_HFM11PRD_10112012_lgnpv61k_14000_1 tag=LEVEL0 comment=NONE
      channel ch4: backup set complete, elapsed time: 00:00:15
      channel ch1: finished piece 1 at 10-NOV-12
      piece handle=/oraclebackup/HFM11PROD/ARC_L0_HFM11PRD_10112012_ldnpv61j_13997_1 tag=LEVEL0 comment=NONE
      channel ch1: backup set complete, elapsed time: 00:00:26
      channel ch2: finished piece 1 at 10-NOV-12
      piece handle=/oraclebackup/HFM11PROD/ARC_L0_HFM11PRD_10112012_lenpv61j_13998_1 tag=LEVEL0 comment=NONE
      channel ch2: backup set complete, elapsed time: 00:00:26
      channel ch3: finished piece 1 at 10-NOV-12
      piece handle=/oraclebackup/HFM11PROD/ARC_L0_HFM11PRD_10112012_lfnpv61j_13999_1 tag=LEVEL0 comment=NONE
      channel ch3: backup set complete, elapsed time: 00:00:25
      Finished backup at 10-NOV-12
      
      Starting backup at 10-NOV-12
      channel ch1: starting compressed full datafile backup set
      channel ch1: specifying datafile(s) in backup set
      _*including current control file in backup set*_
      channel ch1: starting piece 1 at 10-NOV-12
      channel ch1: finished piece 1 at 10-NOV-12
      _*piece handle=/oraclebackup/HFM11PROD/CF_L0_HFM11PRD_10112012_lhnpv62e_14001_1 tag=LEVEL0 comment=NONE*_channel ch1: backup set complete, elapsed time: 00:00:01
      Finished backup at 10-NOV-12
      
      Starting backup at 10-NOV-12
      channel ch1: starting compressed full datafile backup set
      channel ch1: specifying datafile(s) in backup set
      including current SPFILE in backup set
      channel ch1: starting piece 1 at 10-NOV-12
      channel ch1: finished piece 1 at 10-NOV-12
      piece handle=/oraclebackup/HFM11PROD/SP_L0_HFM11PRD_10112012_linpv62i_14002_1 tag=LEVEL0 comment=NONE
      channel ch1: backup set complete, elapsed time: 00:00:01
      Finished backup at 10-NOV-12
      Following is the script of Leve 1 RMAN backup.
      RUN {
       SHOW ALL;
      CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 4;
      ALLOCATE CHANNEL ch1 TYPE DISK;
      ALLOCATE CHANNEL ch2 TYPE DISK;
      ALLOCATE CHANNEL ch3 TYPE DISK;
      ALLOCATE CHANNEL ch4 TYPE DISK;
      BACKUP FORMAT '/oraclebackup/HFM11PROD/DF_L1_%d_%D%M%Y_%u_%s_%p' INCREMENTAL LEVEL 1 AS COMPRESSED BACKUPSET DATABASE TAG='LEVEL1';
      BACKUP FORMAT '/oraclebackup/HFM11PROD/ARC_L1_%d_%D%M%Y_%u_%s_%p'   ARCHIVELOG ALL NOT BACKED UP 2 TIMES TAG='LEVEL1';
      CROSSCHECK ARCHIVELOG ALL;
      DELETE NOPROMPT OBSOLETE;
      RELEASE CHANNEL ch1;
      RELEASE CHANNEL ch2;
      RELEASE CHANNEL ch3;
      RELEASE CHANNEL ch4;
      }
      Following is the log from Level 1 backup which shows that it has marked the backup of control file in backup piece CF_L0_HFM11PRD_10112012_lhnpv62e_14001_1 as obsolete and deleted.
      RMAN> RUN {
      2> SHOW ALL;
      3> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 4;
      4> ALLOCATE CHANNEL ch1 TYPE DISK;
      5> ALLOCATE CHANNEL ch2 TYPE DISK;
      6> ALLOCATE CHANNEL ch3 TYPE DISK;
      7> ALLOCATE CHANNEL ch4 TYPE DISK;
      8> BACKUP FORMAT '/oraclebackup/HFM11PROD/DF_L1_%d_%D%M%Y_%u_%s_%p' INCREMENTAL LEVEL 1 AS COMPRESSED BACKUPSET DATABASE TAG='LEVEL1';
      9> BACKUP FORMAT '/oraclebackup/HFM11PROD/ARC_L1_%d_%D%M%Y_%u_%s_%p'   ARCHIVELOG ALL NOT BACKED UP 2 TIMES TAG='LEVEL1';
      10> CROSSCHECK ARCHIVELOG ALL;
      11> DELETE NOPROMPT OBSOLETE;
      12> RELEASE CHANNEL ch1;
      13> RELEASE CHANNEL ch2;
      14> RELEASE CHANNEL ch3;
      15> RELEASE CHANNEL ch4;
      16> }
      RMAN configuration parameters for database with db_unique_name HFM11PRD are:
      CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
      CONFIGURE BACKUP OPTIMIZATION OFF; # default
      CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
      CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
      CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
      CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 4;
      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 COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
      CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
      CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/orahyp_p/product/11.2/dbs/snapcf_HFM11PRD.f'; # default
      
      old RMAN configuration parameters:
      CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 4;
      new RMAN configuration parameters:
      CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 4;
      new RMAN configuration parameters are successfully stored
      starting full resync of recovery catalog
      full resync complete
      
      allocated channel: ch1
      channel ch1: SID=1718 device type=DISK
      
      allocated channel: ch2
      channel ch2: SID=1499 device type=DISK
      
      allocated channel: ch3
      channel ch3: SID=119 device type=DISK
      
      allocated channel: ch4
      channel ch4: SID=1166 device type=DISK
      
      Starting backup at 12-NOV-12
      channel ch1: starting compressed incremental level 1 datafile backup set
      channel ch1: specifying datafile(s) in backup set
      input datafile file number=00001 name=/u04/oradata/HFM11PRD/system01.dbf
      input datafile file number=00008 name=/u04/oradata/HFM11PRD/EPM_HFM4.DBF
      input datafile file number=00012 name=/u04/oradata/HFM11PRD/EPM_HFM8.DBF
      input datafile file number=00017 name=/u04/oradata/HFM11PRD/EPM_HFM12.DBF
      input datafile file number=00004 name=/u04/oradata/HFM11PRD/EPM_HSS1.DBF
      input datafile file number=00020 name=/u04/oradata/HFM11PRD/EPM_HFM3.DBF
      channel ch1: starting piece 1 at 12-NOV-12
      channel ch2: starting compressed incremental level 1 datafile backup set
      channel ch2: specifying datafile(s) in backup set
      input datafile file number=00003 name=/u04/oradata/HFM11PRD/undots01.dbf
      input datafile file number=00009 name=/u04/oradata/HFM11PRD/EPM_HFM5.DBF
      input datafile file number=00013 name=/u04/oradata/HFM11PRD/EPM_HFM9.DBF
      input datafile file number=00018 name=/u04/oradata/HFM11PRD/EPM_HFM13.DBF
      input datafile file number=00005 name=/u04/oradata/HFM11PRD/EPM_BI1.DBF
      input datafile file number=00021 name=/u04/oradata/HFM11PRD/EPM_HFM15.DBF
      channel ch2: starting piece 1 at 12-NOV-12
      channel ch3: starting compressed incremental level 1 datafile backup set
      channel ch3: specifying datafile(s) in backup set
      input datafile file number=00007 name=/u04/oradata/HFM11PRD/EPM_HFM2.DBF
      input datafile file number=00011 name=/u04/oradata/HFM11PRD/EPM_HFM7.DBF
      input datafile file number=00016 name=/u04/oradata/HFM11PRD/EPM_HFM11.DBF
      input datafile file number=00002 name=/u04/oradata/HFM11PRD/sysaux01.dbf
      input datafile file number=00022 name=/u04/oradata/HFM11PRD/EPM_HSS_new1.DBF
      channel ch3: starting piece 1 at 12-NOV-12
      channel ch4: starting compressed incremental level 1 datafile backup set
      channel ch4: specifying datafile(s) in backup set
      input datafile file number=00006 name=/u04/oradata/HFM11PRD/EPM_HFM1.DBF
      input datafile file number=00010 name=/u04/oradata/HFM11PRD/EPM_HFM6.DBF
      input datafile file number=00015 name=/u04/oradata/HFM11PRD/EPM_HFM10.DBF
      input datafile file number=00019 name=/u04/oradata/HFM11PRD/EPM_HFM14.DBF
      input datafile file number=00014 name=/u04/oradata/HFM11PRD/userdata01.dbf
      channel ch4: starting piece 1 at 12-NOV-12
      channel ch1: finished piece 1 at 12-NOV-12
      piece handle=/oraclebackup/HFM11PROD/DF_L1_HFM11PRD_12112012_lvnq4e3a_14015_1 tag=LEVEL1 comment=NONE
      channel ch1: backup set complete, elapsed time: 00:01:36
      channel ch1: starting compressed incremental level 1 datafile backup set
      channel ch1: specifying datafile(s) in backup set
      channel ch4: finished piece 1 at 12-NOV-12
      piece handle=/oraclebackup/HFM11PROD/DF_L1_HFM11PRD_12112012_m2nq4e3a_14018_1 tag=LEVEL1 comment=NONE
      channel ch4: backup set complete, elapsed time: 00:01:35
      channel ch4: starting compressed incremental level 1 datafile backup set
      channel ch4: specifying datafile(s) in backup set
      including current SPFILE in backup set
      channel ch4: starting piece 1 at 12-NOV-12
      including current control file in backup set
      channel ch1: starting piece 1 at 12-NOV-12
      channel ch1: finished piece 1 at 12-NOV-12
      piece handle=/oraclebackup/HFM11PROD/DF_L1_HFM11PRD_12112012_m3nq4e6a_14019_1 tag=LEVEL1 comment=NONE
      channel ch1: backup set complete, elapsed time: 00:00:01
      channel ch4: finished piece 1 at 12-NOV-12
      piece handle=/oraclebackup/HFM11PROD/DF_L1_HFM11PRD_12112012_m4nq4e6a_14020_1 tag=LEVEL1 comment=NONE
      channel ch4: backup set complete, elapsed time: 00:00:01
      channel ch3: finished piece 1 at 12-NOV-12
      piece handle=/oraclebackup/HFM11PROD/DF_L1_HFM11PRD_12112012_m1nq4e3a_14017_1 tag=LEVEL1 comment=NONE
      channel ch3: backup set complete, elapsed time: 00:01:39
      channel ch2: finished piece 1 at 12-NOV-12
      piece handle=/oraclebackup/HFM11PROD/DF_L1_HFM11PRD_12112012_m0nq4e3a_14016_1 tag=LEVEL1 comment=NONE
      channel ch2: backup set complete, elapsed time: 00:02:41
      Finished backup at 12-NOV-12
      
      Starting backup at 12-NOV-12
      current log archived
      channel ch1: starting compressed archived log backup set
      channel ch1: specifying archived log(s) in backup set
      input archived log thread=1 sequence=40201 RECID=40195 STAMP=799144567
      input archived log thread=1 sequence=40202 RECID=40196 STAMP=799145383
      input archived log thread=1 sequence=40203 RECID=40197 STAMP=799146296
      input archived log thread=1 sequence=40204 RECID=40198 STAMP=799147040
      input archived log thread=1 sequence=40205 RECID=40199 STAMP=799147640
      input archived log thread=1 sequence=40206 RECID=40200 STAMP=799148271
      channel ch1: starting piece 1 at 12-NOV-12
      channel ch2: starting compressed archived log backup set
      channel ch2: specifying archived log(s) in backup set
      input archived log thread=1 sequence=40207 RECID=40201 STAMP=799149018
      input archived log thread=1 sequence=40208 RECID=40202 STAMP=799150009
      input archived log thread=1 sequence=40209 RECID=40203 STAMP=799150549
      input archived log thread=1 sequence=40210 RECID=40204 STAMP=799151041
      input archived log thread=1 sequence=40211 RECID=40205 STAMP=799151860
      input archived log thread=1 sequence=40212 RECID=40206 STAMP=799152535
      channel ch2: starting piece 1 at 12-NOV-12
      channel ch3: starting compressed archived log backup set
      channel ch3: specifying archived log(s) in backup set
      input archived log thread=1 sequence=40213 RECID=40207 STAMP=799153553
      input archived log thread=1 sequence=40214 RECID=40208 STAMP=799153980
      input archived log thread=1 sequence=40215 RECID=40209 STAMP=799154283
      input archived log thread=1 sequence=40216 RECID=40210 STAMP=799155243
      input archived log thread=1 sequence=40217 RECID=40211 STAMP=799155964
      input archived log thread=1 sequence=40218 RECID=40212 STAMP=799156899
      channel ch3: starting piece 1 at 12-NOV-12
      channel ch4: starting compressed archived log backup set
      channel ch4: specifying archived log(s) in backup set
      input archived log thread=1 sequence=40219 RECID=40213 STAMP=799157722
      input archived log thread=1 sequence=40220 RECID=40214 STAMP=799158015
      input archived log thread=1 sequence=40221 RECID=40215 STAMP=799158018
      input archived log thread=1 sequence=40222 RECID=40216 STAMP=799158847
      input archived log thread=1 sequence=40223 RECID=40217 STAMP=799159640
      input archived log thread=1 sequence=40224 RECID=40218 STAMP=799160590
      channel ch4: starting piece 1 at 12-NOV-12
      channel ch4: finished piece 1 at 12-NOV-12
      piece handle=/oraclebackup/HFM11PROD/ARC_L1_HFM11PRD_12112012_m8nq4e8h_14024_1 tag=LEVEL1 comment=NONE
      channel ch4: backup set complete, elapsed time: 00:00:25
      channel ch1: finished piece 1 at 12-NOV-12
      piece handle=/oraclebackup/HFM11PROD/ARC_L1_HFM11PRD_12112012_m5nq4e8g_14021_1 tag=LEVEL1 comment=NONE
      channel ch1: backup set complete, elapsed time: 00:00:36
      channel ch2: finished piece 1 at 12-NOV-12
      piece handle=/oraclebackup/HFM11PROD/ARC_L1_HFM11PRD_12112012_m6nq4e8g_14022_1 tag=LEVEL1 comment=NONE
      channel ch2: backup set complete, elapsed time: 00:00:36
      channel ch3: finished piece 1 at 12-NOV-12
      piece handle=/oraclebackup/HFM11PROD/ARC_L1_HFM11PRD_12112012_m7nq4e8g_14023_1 tag=LEVEL1 comment=NONE
      channel ch3: backup set complete, elapsed time: 00:00:35
      Finished backup at 12-NOV-12
      
      validation succeeded for archived log
      archived log file name=/u05/oradata/HFM11PRD/HFM11PRD_402011737949656.ARC RECID=40195 STAMP=799144567
      validation succeeded for archived log
      archived log file name=/u05/oradata/HFM11PRD/HFM11PRD_402021737949656.ARC RECID=40196 STAMP=799145383
      validation succeeded for archived log
      archived log file name=/u05/oradata/HFM11PRD/HFM11PRD_402031737949656.ARC RECID=40197 STAMP=799146296
      validation succeeded for archived log
      archived log file name=/u05/oradata/HFM11PRD/HFM11PRD_402041737949656.ARC RECID=40198 STAMP=799147040
      validation succeeded for archived log
      archived log file name=/u05/oradata/HFM11PRD/HFM11PRD_402051737949656.ARC RECID=40199 STAMP=799147640
      validation succeeded for archived log
      archived log file name=/u05/oradata/HFM11PRD/HFM11PRD_402061737949656.ARC RECID=40200 STAMP=799148271
      validation succeeded for archived log
      archived log file name=/u05/oradata/HFM11PRD/HFM11PRD_402071737949656.ARC RECID=40201 STAMP=799149018
      validation succeeded for archived log
      archived log file name=/u05/oradata/HFM11PRD/HFM11PRD_402081737949656.ARC RECID=40202 STAMP=799150009
      validation succeeded for archived log
      archived log file name=/u05/oradata/HFM11PRD/HFM11PRD_402091737949656.ARC RECID=40203 STAMP=799150549
      validation succeeded for archived log
      archived log file name=/u05/oradata/HFM11PRD/HFM11PRD_402101737949656.ARC RECID=40204 STAMP=799151041
      validation succeeded for archived log
      archived log file name=/u05/oradata/HFM11PRD/HFM11PRD_402111737949656.ARC RECID=40205 STAMP=799151860
      validation succeeded for archived log
      archived log file name=/u05/oradata/HFM11PRD/HFM11PRD_402121737949656.ARC RECID=40206 STAMP=799152535
      validation succeeded for archived log
      archived log file name=/u05/oradata/HFM11PRD/HFM11PRD_402131737949656.ARC RECID=40207 STAMP=799153553
      validation succeeded for archived log
      archived log file name=/u05/oradata/HFM11PRD/HFM11PRD_402141737949656.ARC RECID=40208 STAMP=799153980
      validation succeeded for archived log
      archived log file name=/u05/oradata/HFM11PRD/HFM11PRD_402151737949656.ARC RECID=40209 STAMP=799154283
      validation succeeded for archived log
      archived log file name=/u05/oradata/HFM11PRD/HFM11PRD_402161737949656.ARC RECID=40210 STAMP=799155243
      validation succeeded for archived log
      archived log file name=/u05/oradata/HFM11PRD/HFM11PRD_402171737949656.ARC RECID=40211 STAMP=799155964
      validation succeeded for archived log
      archived log file name=/u05/oradata/HFM11PRD/HFM11PRD_402181737949656.ARC RECID=40212 STAMP=799156899
      validation succeeded for archived log
      archived log file name=/u05/oradata/HFM11PRD/HFM11PRD_402191737949656.ARC RECID=40213 STAMP=799157722
      validation succeeded for archived log
      archived log file name=/u05/oradata/HFM11PRD/HFM11PRD_402201737949656.ARC RECID=40214 STAMP=799158015
      validation succeeded for archived log
      archived log file name=/u05/oradata/HFM11PRD/HFM11PRD_402211737949656.ARC RECID=40215 STAMP=799158018
      validation succeeded for archived log
      archived log file name=/u05/oradata/HFM11PRD/HFM11PRD_402221737949656.ARC RECID=40216 STAMP=799158847
      validation succeeded for archived log
      archived log file name=/u05/oradata/HFM11PRD/HFM11PRD_402231737949656.ARC RECID=40217 STAMP=799159640
      validation succeeded for archived log
      archived log file name=/u05/oradata/HFM11PRD/HFM11PRD_402241737949656.ARC RECID=40218 STAMP=799160590
      Crosschecked 24 objects
      
      
      RMAN retention policy will be applied to the command
      RMAN retention policy is set to redundancy 1
      Deleting the following obsolete backups and copies:
      Type                 Key    Completion Time    Filename/Handle
      -------------------- ------ ------------------ --------------------
      Backup Set           18521832 10-NOV-12         
        Backup Piece       18521838 10-NOV-12          /oraclebackup/HFM11PROD/CF_L0_HFM11PRD_10112012_lhnpv62e_14001_1
      Backup Set           18521846 10-NOV-12         
        Backup Piece       18521848 10-NOV-12          /oraclebackup/HFM11PROD/SP_L0_HFM11PRD_10112012_linpv62i_14002_1
      deleted backup piece
      backup piece handle=/oraclebackup/HFM11PROD/CF_L0_HFM11PRD_10112012_lhnpv62e_14001_1 RECID=14000 STAMP=798988367
      deleted backup piece
      backup piece handle=/oraclebackup/HFM11PROD/SP_L0_HFM11PRD_10112012_linpv62i_14002_1 RECID=14001 STAMP=798988370
      Deleted 2 objects
      
      
      released channel: ch1
      
      released channel: ch2
      
      released channel: ch3
      
      released channel: ch4
      
      
      RMAN> exit;
      Now, on Friday when i am trying to do a restore for this database on another server i am getting error as below. Restore script is as below.
      run 
      {
      allocate AUXILIARY channel c1 device type disk;
      allocate AUXILIARY channel c2 device type disk;
      allocate AUXILIARY channel c3 device type disk;
      allocate AUXILIARY channel c4 device type disk;
      set until scn 699575816; 
      duplicate target database to HFM11TMP;
      release channel c1;
      release channel c2;
      release channel c3;
      release channel c4;
      }
      Error is as:
         sql clone "alter system set  db_unique_name =
       ''HFM11TMP'' comment=
       ''Modified by RMAN duplicate'' scope=spfile";
         shutdown clone immediate;
         startup clone force nomount
         restore clone primary controlfile;
         alter clone database mount;
      }
      executing Memory Script
      
      executing command: SET until clause
      
      sql statement: alter system set  db_name =  ''HFM11PRD'' comment= ''Modified by RMAN duplicate'' scope=spfile
      
      sql statement: alter system set  db_unique_name =  ''HFM11TMP'' comment= ''Modified by RMAN duplicate'' scope=spfile
      
      Oracle instance shut down
      
      Oracle instance started
      
      Total System Global Area    4275781632 bytes
      
      Fixed Size                     2213632 bytes
      Variable Size               2298480896 bytes
      Database Buffers            1962934272 bytes
      Redo Buffers                  12152832 bytes
      allocated channel: c1
      channel c1: SID=112 device type=DISK
      
      Starting restore at 06-NOV-12
      
      released channel: c1
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of Duplicate Db command at 11/06/2012 15:13:32
      RMAN-03015: error occurred in stored script Memory Script
      RMAN-06026: some targets not found - aborting restore
      RMAN-06024: no backup or copy of the control file found to restore
      RMAN is searching for backup of controlfile in backup piece CF_L0_HFM11PRD_10112012_lhnpv62e_14001_1. But this has been already obsolete.

      Now, if it not possible to get above backup piece back, then how to proceed with restore with backup piece DF_L0_HFM11PRD_10112012_l8npv5b6_13992_1 as it also has control file backup and available on disk, not obsolete. I can understand the reason for marking CF* file as obsolete because of redundency 1. But how to proceed with restore with available backup ?
        • 1. Re: Control File issue
          mseberg
          Hello;

          I would change my configure for one :
          RMAN>CONFIGURE CONTROLFILE AUTOBACKUP ON;
          Would use this to check :
          list backup of controlfile completed before <date>
          And would catalog everything again just to be sure before starting the restore.

          You may have to catalog use the control file piece to avoid the error.
          RMAN> catalog backuppiece ...
          Another idea is to test the restore using something like this :
          RMAN> run {
                  set until time "to_date('2012 NOV 17 07:00','YYYY MON DD HH24:MI')";
                  restore controlfile preview;
                }
          Best Regards

          mseberg

          Edited by: mseberg on Nov 16, 2012 10:12 AM

          Edited by: mseberg on Nov 16, 2012 11:13 AM
          • 2. Re: Control File issue
            Shivananda Rao
            Hello,

            Take a look at this http://databaseninja.blogspot.in/2011/12/rman-06026-some-targets-not-found-rman.html
            Might help you out !!
            • 3. Re: Control File issue
              rajeysh
              refer:- http://oracleinstance.blogspot.in/2010/08/disaster-recovery-using-rman-demo.html
              http://oracleinstance.blogspot.in/2010/08/restore-lost-control-file-using-rman.html
              • 4. Re: Control File issue
                975255
                When restoring, you have four auxiliary channels, but you don't any channels to the target (source) database.
                You should be also connected to the target database if you are duplicating it.

                Regards

                P
                • 5. Re: Control File issue
                  Hemant K Chitale
                  Without an RMAN Catalog you must either

                  a. Use CONTROLFILE AUTOBACKUP

                  b. Explicitly Restore the controlfile manually


                  Hemant K Chitale