Wednesday, October 12, 2016

Oracle RMAN backup compression full and incremental

Full backup compression scripts :

backup AS COMPRESSED BACKUPSET INCREMENTAL LEVEL 0 database tag ORCL_FULL format '+RMAN_BACKUP/rman_bkp_df2_%d_%t_%s_%p_%U';

Incremental backup compression scripts :

backup AS COMPRESSED BACKUPSET INCREMENTAL LEVEL 1 database tag ORCL_FULL format '+RMAN_BACKUP/rman_bkp_inc_%d_%t_%s_%p_%U';

Log:


[oracle@OEL564ASMN1 scripts]$ rman target/

Recovery Manager: Release 11.2.0.3.0 - Production on Wed Oct 12 14:50:09 2016

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ASMDB (DBID=624768357)

RMAN> backup AS COMPRESSED BACKUPSET INCREMENTAL LEVEL 0 database tag ORCL_FULL format '+RMAN_BACKUP/rman_bkp_df2_%d_%t_%s_%p_%U';

Starting backup at 12-OCT-16
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=57 device type=DISK
channel ORA_DISK_1: starting compressed incremental level 0 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/asmdb/datafile/system.256.880569463
input datafile file number=00002 name=+DATA/asmdb/datafile/sysaux.257.880569467
input datafile file number=00005 name=+DATA/asmdb/datafile/example.265.880569629
input datafile file number=00006 name=+DATA/asmdb/datafile/test_tbs.267.881349853
input datafile file number=00003 name=+DATA/asmdb/datafile/undotbs1.258.880569467
input datafile file number=00004 name=+DATA/asmdb/datafile/users.259.880569471
input datafile file number=00007 name=+DATA/asmdb/datafile/tbs_user_data_1.268.882462007
input datafile file number=00008 name=+DATA/asmdb/datafile/tbs_user_data_1.269.882458361
channel ORA_DISK_1: starting piece 1 at 12-OCT-16
channel ORA_DISK_1: finished piece 1 at 12-OCT-16
piece handle=+RMAN_BACKUP/rman_bkp_df2_asmdb_925051814_18_1_0iri6at6_1_1 tag=ORCL_FULL comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:35
Finished backup at 12-OCT-16

Starting Control File and SPFILE Autobackup at 12-OCT-16
piece handle=+FRA/asmdb/autobackup/2016_10_12/s_925051911.360.925051913 comment=NONE
Finished Control File and SPFILE Autobackup at 12-OCT-16

RMAN>
RMAN> backup AS COMPRESSED BACKUPSET INCREMENTAL LEVEL 1 database tag ORCL_FULL format '+RMAN_BACKUP/rman_bkp_inc_%d_%t_%s_%p_%U';

Starting backup at 12-OCT-16
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed incremental level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/asmdb/datafile/system.256.880569463
input datafile file number=00002 name=+DATA/asmdb/datafile/sysaux.257.880569467
input datafile file number=00005 name=+DATA/asmdb/datafile/example.265.880569629
input datafile file number=00006 name=+DATA/asmdb/datafile/test_tbs.267.881349853
input datafile file number=00003 name=+DATA/asmdb/datafile/undotbs1.258.880569467
input datafile file number=00004 name=+DATA/asmdb/datafile/users.259.880569471
input datafile file number=00007 name=+DATA/asmdb/datafile/tbs_user_data_1.268.882462007
input datafile file number=00008 name=+DATA/asmdb/datafile/tbs_user_data_1.269.882458361
channel ORA_DISK_1: starting piece 1 at 12-OCT-16
channel ORA_DISK_1: finished piece 1 at 12-OCT-16
piece handle=+RMAN_BACKUP/rman_bkp_inc_asmdb_925052081_22_1_0mri6b5h_1_1 tag=ORCL_FULL comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:05
Finished backup at 12-OCT-16

Starting Control File and SPFILE Autobackup at 12-OCT-16
piece handle=+FRA/asmdb/autobackup/2016_10_12/s_925052147.359.925052147 comment=NONE
Finished Control File and SPFILE Autobackup at 12-OCT-16

RMAN> exit


Recovery Manager complete.

[oracle@OEL564ASMN1 scripts]$

No comments:

Post a Comment