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.