RMAN Backup. Example of backup log

RMAN Backup. Example of backup log

backup /cygdrive/p/backup/ora_online/20151118_1714

Recovery Manager: Release 11.1.0.7.0 - Production on Wed Nov 18 17:14:41 2015

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: IGT (DBID=933592012)

RMAN> run {
2>   configure controlfile autobackup on;
3>   configure backup optimization on;
4>   set controlfile autobackup format for device type disk to 'p:\backup\ora_online\20151118_1714\%F';
5>   allocate channel 'dev_0' type disk format = 'p:\backup\ora_online\20151118_1714\dbf_%d_%T_%U';
6>   backup full database;
7>   backup archivelog from time = 'sysdate-10/1440' format 'p:\backup\ora_online\20151118_1714\arch_%d_%T_%U';
8>   release channel 'dev_0';
9> }
10> 
using target database control file instead of recovery catalog
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 BACKUP OPTIMIZATION ON;
new RMAN configuration parameters:
CONFIGURE BACKUP OPTIMIZATION ON;
new RMAN configuration parameters are successfully stored

executing command: SET CONTROLFILE AUTOBACKUP FORMAT

allocated channel: dev_0
channel dev_0: SID=271 device type=DISK

Starting backup at 18-NOV-15
channel dev_0: starting full datafile backup set
channel dev_0: specifying datafile(s) in backup set
input datafile file number=00006 name=D:\ORACLE_DB\DB1\DB_IGT\ORA_IGT_TABLE_01.DBF
input datafile file number=00005 name=D:\ORACLE_DB\DB1\DB_IGT\ORA_GININDEX_01.DBF
input datafile file number=00004 name=D:\ORACLE_DB\DB1\DB_IGT\ORA_GIN_01.DBF
input datafile file number=00003 name=D:\ORACLE_DB\DB1\DB_IGT\ORA_UNDOTBS_01.DBF
input datafile file number=00007 name=D:\ORACLE_DB\DB1\DB_IGT\ORA_IGT_INDEX_01.DBF
input datafile file number=00002 name=D:\ORACLE_DB\DB1\DB_IGT\ORA_SYSAUX_01.DBF
input datafile file number=00001 name=D:\ORACLE_DB\DB1\DB_IGT\ORA_SYSTEM_01.DBF
input datafile file number=00008 name=D:\ORACLE_DB\DB1\DB_IGT\ORA_WORKAREA_01.DBF
input datafile file number=00009 name=D:\ORACLE_DB\DB1\DB_IGT\ORA_DWH_TABLE_01.DBF
input datafile file number=00010 name=D:\ORACLE_DB\DB1\DB_IGT\ORA_DWH_INDEX_01.DBF
channel dev_0: starting piece 1 at 18-NOV-15
channel dev_0: finished piece 1 at 18-NOV-15
piece handle=P:\BACKUP\ORA_ONLINE\20151118_1714\DBF_IGT_20151118_GSQMJ9O6_1_1 tag=TAG20151118T171445 comment=NONE
channel dev_0: backup set complete, elapsed time: 00:06:45
Finished backup at 18-NOV-15

Starting backup at 18-NOV-15
current log archived
channel dev_0: starting archived log backup set
channel dev_0: specifying archived log(s) in backup set
input archived log thread=1 sequence=143097 RECID=143087 STAMP=896116533
input archived log thread=1 sequence=143098 RECID=143088 STAMP=896116892
channel dev_0: starting piece 1 at 18-NOV-15
channel dev_0: finished piece 1 at 18-NOV-15
piece handle=P:\BACKUP\ORA_ONLINE\20151118_1714\ARCH_IGT_20151118_GTQMJA4T_1_1 tag=TAG20151118T172133 comment=NONE
channel dev_0: backup set complete, elapsed time: 00:00:07
Finished backup at 18-NOV-15

Starting Control File and SPFILE Autobackup at 18-NOV-15
piece handle=P:\BACKUP\ORA_ONLINE\20151118_1714\C-933592012-20151118-00 comment=NONE
Finished Control File and SPFILE Autobackup at 18-NOV-15

released channel: dev_0

Recovery Manager complete.
fullRmanBackup: 18-11-2015 17:21:45 INFO- rman target backup has finished

Recovery Manager: Release 11.1.0.7.0 - Production on Wed Nov 18 17:21:45 2015

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: IGT (DBID=933592012)

RMAN> 
using target database control file instead of recovery catalog
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           6500   09-NOV-15         
  Backup Piece       6500   09-NOV-15          P:\BACKUP\ORA_ONLINE\20151109_0300\DBF_IGT_20151109_FJQLQ09U_1_1
Backup Set           6501   09-NOV-15         
  Backup Piece       6501   09-NOV-15          P:\BACKUP\ORA_ONLINE\20151109_0300\ARCH_IGT_20151109_FKQLQ0M0_1_1
Archive Log          142553 09-NOV-15          M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_142563_695307596.ARC
Backup Set           6502   09-NOV-15         
  Backup Piece       6502   09-NOV-15          
P:\BACKUP\ORA_ONLINE\20151109_0300\C-933592012-20151109-00
Archive Log          142554 09-NOV-15          M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_142564_695307596.ARC
Archive Log          142555 09-NOV-15          M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_142565_695307596.ARC
Archive Log          142556 09-NOV-15          M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_142566_695307596.ARC
Archive Log          142557 09-NOV-15          M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_142567_695307596.ARC
Archive Log          142558 09-NOV-15          M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_142568_695307596.ARC
Archive Log          142559 09-NOV-15          M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_142569_695307596.ARC
Archive Log          142560 09-NOV-15          M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_142570_695307596.ARC
Archive Log          142561 09-NOV-15          M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_142571_695307596.ARC
Archive Log          142562 09-NOV-15          M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_142572_695307596.ARC
Archive Log          142563 09-NOV-15          M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_142573_695307596.ARC
Archive Log          142564 09-NOV-15          M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_142574_695307596.ARC
Archive Log          142565 09-NOV-15          M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_142575_695307596.ARC
Archive Log          142566 09-NOV-15          M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_142576_695307596.ARC
Archive Log          142567 09-NOV-15          M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_142577_695307596.ARC
Archive Log          142568 09-NOV-15          M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_142578_695307596.ARC
Archive Log          142569 09-NOV-15          M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_142579_695307596.ARC
Archive Log          142570 09-NOV-15          M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_142580_695307596.ARC
Archive Log          142571 09-NOV-15          M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_142581_695307596.ARC
Archive Log          142572 09-NOV-15          M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_142582_695307596.ARC
Archive Log          142573 09-NOV-15          M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_142583_695307596.ARC
Archive Log          142574 09-NOV-15          M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_142584_695307596.ARC
Archive Log          142575 09-NOV-15          M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_142585_695307596.ARC
Archive Log          142576 09-NOV-15          M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_142586_695307596.ARC
Archive Log          142577 09-NOV-15          M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_142587_695307596.ARC
Archive Log          142578 09-NOV-15          M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_142588_695307596.ARC
Archive Log          142579 09-NOV-15          M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_142589_695307596.ARC
Archive Log          142580 09-NOV-15          M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_142590_695307596.ARC


RMAN> 

Recovery Manager complete.
fullRmanBackup: 18-11-2015 17:21:53 INFO- setting acls
fullRmanBackup: 18-11-2015 17:21:53 INFO- deleting obsolete backup sets

Recovery Manager: Release 11.1.0.7.0 - Production on Wed Nov 18 17:21:53 2015

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: IGT (DBID=933592012)

RMAN> 
using target database control file instead of recovery catalog
allocated channel: ORA_MAINT_DISK_1
channel ORA_MAINT_DISK_1: SID=238 device type=DISK

RMAN> 
List of Archived Log Copies for database with db_unique_name IGT
=====================================================================

Key     Thrd Seq     S Low Time 
------- ---- ------- - ---------
143087  1    143097  A 18-NOV-15
        Name: M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_143097_695307596.ARC

143088  1    143098  A 18-NOV-15
        Name: M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_143098_695307596.ARC

deleted archived log
archived log file name=M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_143097_695307596.ARC RECID=143087 STAMP=896116533
deleted archived log
archived log file name=M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_143098_695307596.ARC RECID=143088 STAMP=896116892
Deleted 2 objects


RMAN> 

RMAN> 
Deleting the following obsolete backups and copies:
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           6500   09-NOV-15         
  Backup Piece       6500   09-NOV-15          P:\BACKUP\ORA_ONLINE\20151109_0300\DBF_IGT_20151109_FJQLQ09U_1_1
Backup Set           6501   09-NOV-15         
  Backup Piece       6501   09-NOV-15          P:\BACKUP\ORA_ONLINE\20151109_0300\ARCH_IGT_20151109_FKQLQ0M0_1_1
Archive Log          142553 09-NOV-15          M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_142563_695307596.ARC
Backup Set           6502   09-NOV-15         
  Backup Piece       6502   09-NOV-15          
P:\BACKUP\ORA_ONLINE\20151109_0300\C-933592012-20151109-00
Archive Log          142554 09-NOV-15          M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_142564_695307596.ARC
Archive Log          142555 09-NOV-15          M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_142565_695307596.ARC
Archive Log          142556 09-NOV-15          M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_142566_695307596.ARC
Archive Log          142557 09-NOV-15          M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_142567_695307596.ARC
Archive Log          142558 09-NOV-15          M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_142568_695307596.ARC
Archive Log          142559 09-NOV-15          M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_142569_695307596.ARC
Archive Log          142560 09-NOV-15          M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_142570_695307596.ARC
Archive Log          142561 09-NOV-15          M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_142571_695307596.ARC
Archive Log          142562 09-NOV-15          M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_142572_695307596.ARC
Archive Log          142563 09-NOV-15          M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_142573_695307596.ARC
Archive Log          142564 09-NOV-15          M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_142574_695307596.ARC
Archive Log          142565 09-NOV-15          M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_142575_695307596.ARC
Archive Log          142566 09-NOV-15          M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_142576_695307596.ARC
Archive Log          142567 09-NOV-15          M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_142577_695307596.ARC
Archive Log          142568 09-NOV-15          M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_142578_695307596.ARC
Archive Log          142569 09-NOV-15          M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_142579_695307596.ARC
Archive Log          142570 09-NOV-15          M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_142580_695307596.ARC


deleted backup piece
backup piece handle=P:\BACKUP\ORA_ONLINE\20151109_0300\DBF_IGT_20151109_FJQLQ09U_1_1 RECID=6500 STAMP=895287616
deleted backup piece
backup piece handle=P:\BACKUP\ORA_ONLINE\20151109_0300\ARCH_IGT_20151109_FKQLQ0M0_1_1 RECID=6501 STAMP=895288000
deleted archived log
archived log file name=M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_142563_695307596.ARC RECID=142553 STAMP=895289800
deleted backup piece
backup piece handle=P:\BACKUP\ORA_ONLINE\20151109_0300\C-933592012-20151109-00 RECID=6502 STAMP=895288009
deleted archived log
archived log file name=M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_142564_695307596.ARC RECID=142554 STAMP=895291599
deleted archived log
archived log file name=M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_142565_695307596.ARC RECID=142555 STAMP=895293401
deleted archived log
archived log file name=M:\ORACLE_DB\DB2\DB_IGT\ARCH\ARCH001_142566_695307596.ARC RECID=142556 STAMP=895295201

Deleted 102 objects


RMAN> 
released channel: ORA_MAINT_DISK_1

RMAN> 

Recovery Manager complete.
fullRmanBackup: 18-11-2015 17:23:47 INFO- removing empty directories