Recovery Manager: Release 11.2.0.1.0 - Production on Sun Mar 5 09:00:02 2017 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. connected to target database: EMERALITPRD (DBID=2214550130) using target database control file instead of recovery catalog RMAN> configure snapshot controlfile name to '/u03/backup/emeralitprd_snapshot.ctl'; 2> configure retention policy to recovery window of 10 days; 3> configure controlfile autobackup on; 4> configure controlfile autobackup format for device type disk to '/u03/backup/%F.ctl'; 5> 6> run 7> { 8> sql "alter system archive log current"; 9> allocate channel c1 device type disk format '/u03/backup/lev_0_%d_t%t_s%s_p%p'; 10> BACKUP Incremental level 0 DATABASE; 11> } 12> 13> crosscheck backup of database completed before 'sysdate - 10'; 14> crosscheck archivelog all completed before 'sysdate - 10'; 15> crosscheck backup of controlfile completed before 'sysdate - 10'; 16> 17> delete noprompt backup completed before 'sysdate - 10'; 18> delete noprompt archivelog all completed before 'sysdate - 3/24'; 19> delete force backup of controlfile completed before 'sysdate - 10'; 20> 21> backup archivelog all; 22> 23> crosscheck backup of database completed before 'sysdate - 10'; 24> crosscheck archivelog all completed before 'sysdate - 10'; 25> crosscheck backup of controlfile completed before 'sysdate - 10'; 26> 27> exit; old RMAN configuration parameters: CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u03/backup/emeralitprd_snapshot.ctl'; new RMAN configuration parameters: CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u03/backup/emeralitprd_snapshot.ctl'; new RMAN configuration parameters are successfully stored old RMAN configuration parameters: CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 10 DAYS; new RMAN configuration parameters: CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 10 DAYS; new RMAN configuration parameters are successfully stored old RMAN configuration parameters: CONFIGURE CONTROLFILE AUTOBACKUP ON; new RMAN configuration parameters: CONFIGURE CONTROLFILE AUTOBACKUP ON; new RMAN configuration parameters are successfully stored old RMAN configuration parameters: CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u03/backup/%F.ctl'; new RMAN configuration parameters: CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u03/backup/%F.ctl'; new RMAN configuration parameters are successfully stored sql statement: alter system archive log current allocated channel: c1 channel c1: SID=1166 device type=DISK Starting backup at 05-MAR-17 channel c1: starting incremental level 0 datafile backup set channel c1: specifying datafile(s) in backup set input datafile file number=00007 name=/u02/oradata/dms/emeralit_data00.dbf input datafile file number=00006 name=/u03/oradata/rdms/emeralitprd_data00.dbf input datafile file number=00010 name=/u01/oradata/emeralitprd/users02.dbf input datafile file number=00012 name=/u01/oradata/emeralitprd/TSD_PERFSTAT03.dbf input datafile file number=00013 name=/u01/oradata/emeralitprd/emeralit_data01.dbf input datafile file number=00011 name=/u01/oradata/emeralitprd/system02.dbf input datafile file number=00003 name=/u02/oradata/emeralitprd/undotbs01.dbf channel c1: starting piece 1 at 05-MAR-17 channel c1: finished piece 1 at 05-MAR-17 piece handle=/u03/backup/lev_0_EMERALITPRD_t937818005_s8715_p1 tag=TAG20170305T090005 comment=NONE channel c1: backup set complete, elapsed time: 00:20:46 channel c1: starting incremental level 0 datafile backup set channel c1: specifying datafile(s) in backup set input datafile file number=00004 name=/u02/oradata/emeralitprd/users01.dbf input datafile file number=00014 name=/u03/oradata/rdms/ADTRACK_DATA01.DBF input datafile file number=00009 name=/u02/oradata/emeralitprd/TSD_PERFSTAT02.dbf channel c1: starting piece 1 at 05-MAR-17 channel c1: finished piece 1 at 05-MAR-17 piece handle=/u03/backup/lev_0_EMERALITPRD_t937819251_s8716_p1 tag=TAG20170305T090005 comment=NONE channel c1: backup set complete, elapsed time: 00:07:16 channel c1: starting incremental level 0 datafile backup set channel c1: specifying datafile(s) in backup set input datafile file number=00002 name=/u02/oradata/emeralitprd/sysaux01.dbf channel c1: starting piece 1 at 05-MAR-17 channel c1: finished piece 1 at 05-MAR-17 piece handle=/u03/backup/lev_0_EMERALITPRD_t937819687_s8717_p1 tag=TAG20170305T090005 comment=NONE channel c1: backup set complete, elapsed time: 00:02:15 channel c1: starting incremental level 0 datafile backup set channel c1: specifying datafile(s) in backup set input datafile file number=00015 name=/u02/oradata/dms/ADTRACK_INDX01.DBF input datafile file number=00008 name=/u02/oradata/emeralitprd/TSD_PERFSTAT.dbf input datafile file number=00001 name=/u02/oradata/emeralitprd/system01.dbf input datafile file number=00005 name=/u02/oradata/emeralitprd/example01.dbf channel c1: starting piece 1 at 05-MAR-17 channel c1: finished piece 1 at 05-MAR-17 piece handle=/u03/backup/lev_0_EMERALITPRD_t937819822_s8718_p1 tag=TAG20170305T090005 comment=NONE channel c1: backup set complete, elapsed time: 00:01:15 Finished backup at 05-MAR-17 Starting Control File Autobackup at 05-MAR-17 piece handle=/u03/backup/c-2214550130-20170305-00.ctl comment=NONE Finished Control File Autobackup at 05-MAR-17 released channel: c1 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=1166 device type=DISK crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u03/backup/level_1_EMERALITPRD_t936639007_s8644_p1 RECID=8632 STAMP=936639015 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u03/backup/level_1_EMERALITPRD_t936639892_s8645_p1 RECID=8633 STAMP=936639892 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u03/backup/level_1_EMERALITPRD_t936640008_s8646_p1 RECID=8634 STAMP=936640008 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u03/backup/level_1_EMERALITPRD_t936640113_s8647_p1 RECID=8635 STAMP=936640113 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u03/backup/level_1_EMERALITPRD_t936640208_s8648_p1 RECID=8636 STAMP=936640208 Crosschecked 5 objects released channel: ORA_DISK_1 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=1166 device type=DISK using channel ORA_DISK_1 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u03/backup/c-2214550130-20170222-00.ctl RECID=8637 STAMP=936640224 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u03/backup/c-2214550130-20170222-01.ctl RECID=8639 STAMP=936640246 Crosschecked 2 objects using channel ORA_DISK_1 deleted backup piece backup piece handle=/u03/backup/level_1_EMERALITPRD_t936639007_s8644_p1 RECID=8632 STAMP=936639015 deleted backup piece backup piece handle=/u03/backup/level_1_EMERALITPRD_t936639892_s8645_p1 RECID=8633 STAMP=936639892 deleted backup piece backup piece handle=/u03/backup/level_1_EMERALITPRD_t936640008_s8646_p1 RECID=8634 STAMP=936640008 deleted backup piece backup piece handle=/u03/backup/level_1_EMERALITPRD_t936640113_s8647_p1 RECID=8635 STAMP=936640113 deleted backup piece backup piece handle=/u03/backup/level_1_EMERALITPRD_t936640208_s8648_p1 RECID=8636 STAMP=936640208 deleted backup piece backup piece handle=/u03/backup/c-2214550130-20170222-00.ctl RECID=8637 STAMP=936640224 deleted backup piece backup piece handle=/u03/flash_recovery_area/EMERALITPRD/backupset/2017_02_22/o1_mf_annnn_TAG20170222T175042_dbw5g30o_.bkp RECID=8638 STAMP=936640243 deleted backup piece backup piece handle=/u03/backup/c-2214550130-20170222-01.ctl RECID=8639 STAMP=936640246 Deleted 8 objects released channel: ORA_DISK_1 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=1166 device type=DISK deleted archived log archived log file name=/u03/flash_recovery_area/EMERALITPRD/archivelog/2017_03_03/o1_mf_1_47177_dcmm22kt_.arc RECID=102056 STAMP=937667058 deleted archived log archived log file name=/u03/flash_recovery_area/EMERALITPRD/archivelog/2017_03_03/o1_mf_1_47178_dcmvmds0_.arc RECID=102057 STAMP=937675804 deleted archived log archived log file name=/u03/flash_recovery_area/EMERALITPRD/archivelog/2017_03_03/o1_mf_1_47179_dcmwtr9q_.arc RECID=102058 STAMP=937677064 deleted archived log archived log file name=/u03/flash_recovery_area/EMERALITPRD/archivelog/2017_03_03/o1_mf_1_47180_dcmxh11q_.arc RECID=102059 STAMP=937677713 deleted archived log archived log file name=/u03/flash_recovery_area/EMERALITPRD/archivelog/2017_03_03/o1_mf_1_47181_dcmyjq1v_.arc RECID=102060 STAMP=937678791 deleted archived log archived log file name=/u03/flash_recovery_area/EMERALITPRD/archivelog/2017_03_03/o1_mf_1_47182_dcmyjx7q_.arc RECID=102061 STAMP=937678797 deleted archived log archived log file name=/u03/flash_recovery_area/EMERALITPRD/archivelog/2017_03_03/o1_mf_1_47183_dcmyk3hy_.arc RECID=102062 STAMP=937678803 deleted archived log archived log file name=/u03/flash_recovery_area/EMERALITPRD/archivelog/2017_03_03/o1_mf_1_47184_dcmyk9jb_.arc RECID=102063 STAMP=937678809 deleted archived log archived log file name=/u03/flash_recovery_area/EMERALITPRD/archivelog/2017_03_03/o1_mf_1_47185_dcmykjw1_.arc RECID=102064 STAMP=937678817 deleted archived log archived log file name=/u03/flash_recovery_area/EMERALITPRD/archivelog/2017_03_03/o1_mf_1_47186_dcn4dq8q_.arc RECID=102065 STAMP=937684807 deleted archived log archived log file name=/u03/flash_recovery_area/EMERALITPRD/archivelog/2017_03_03/o1_mf_1_47187_dcngy8bc_.arc RECID=102066 STAMP=937695608 deleted archived log archived log file name=/u03/flash_recovery_area/EMERALITPRD/archivelog/2017_03_04/o1_mf_1_47188_dco5s8ph_.arc RECID=102067 STAMP=937719001 deleted archived log archived log file name=/u03/flash_recovery_area/EMERALITPRD/archivelog/2017_03_04/o1_mf_1_47189_dco7lmg4_.arc RECID=102068 STAMP=937720835 deleted archived log archived log file name=/u03/flash_recovery_area/EMERALITPRD/archivelog/2017_03_04/o1_mf_1_47190_dcownptm_.arc RECID=102069 STAMP=937742407 deleted archived log archived log file name=/u03/flash_recovery_area/EMERALITPRD/archivelog/2017_03_04/o1_mf_1_47191_dcpl3hgw_.arc RECID=102070 STAMP=937764383 deleted archived log archived log file name=/u03/flash_recovery_area/EMERALITPRD/archivelog/2017_03_04/o1_mf_1_47192_dcpoxdsx_.arc RECID=102071 STAMP=937768285 deleted archived log archived log file name=/u03/flash_recovery_area/EMERALITPRD/archivelog/2017_03_05/o1_mf_1_47193_dcq6tmwk_.arc RECID=102072 STAMP=937785604 deleted archived log archived log file name=/u03/flash_recovery_area/EMERALITPRD/archivelog/2017_03_05/o1_mf_1_47194_dcqt595c_.arc RECID=102073 STAMP=937805401 Deleted 18 objects using channel ORA_DISK_1 specification does not match any backup in the repository Starting backup at 05-MAR-17 current log archived using channel ORA_DISK_1 channel ORA_DISK_1: starting archived log backup set channel ORA_DISK_1: specifying archived log(s) in backup set input archived log thread=1 sequence=47195 RECID=102074 STAMP=937811806 input archived log thread=1 sequence=47196 RECID=102075 STAMP=937818004 input archived log thread=1 sequence=47197 RECID=102076 STAMP=937819904 channel ORA_DISK_1: starting piece 1 at 05-MAR-17 channel ORA_DISK_1: finished piece 1 at 05-MAR-17 piece handle=/u03/flash_recovery_area/EMERALITPRD/backupset/2017_03_05/o1_mf_annnn_TAG20170305T093144_dcr8bj7n_.bkp tag=TAG20170305T093144 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 Finished backup at 05-MAR-17 Starting Control File Autobackup at 05-MAR-17 piece handle=/u03/backup/c-2214550130-20170305-01.ctl comment=NONE Finished Control File Autobackup at 05-MAR-17 using channel ORA_DISK_1 specification does not match any backup in the repository released channel: ORA_DISK_1 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=1166 device type=DISK using channel ORA_DISK_1 specification does not match any backup in the repository Recovery Manager complete.
Your Comments