I repeated the test from the previous post but this time I tried to compress the backup. At this stage I need your help. I believe I have used the free compression which does not require an extra licence. If somebody who knows more about this than me could add a comment below, telling me if I am right or wrong, that would be very helpful. I backed up the database as before:
C:\Users\AJ0294094>rman nocatalog target=andrew/reid
Recovery Manager: Release 11.2.0.1.0 - Production on Fri Mar 11 19:19:38 2016
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: DEBELDV2 (DBID=4080010922, not open)
using target database control file instead of recovery catalog
RMAN> backup as compressed backupset database;
Starting backup at 11-MAR-16
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=156 device type=DISK
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=E:\ORACLE\ORADATA\DEBELDV2\SYSTEM01.DBF
input datafile file number=00003 name=E:\ORACLE\ORADATA\DEBELDV2\UNDOTBS01.DBF
input datafile file number=00002 name=E:\ORACLE\ORADATA\DEBELDV2\SYSAUX01.DBF
input datafile file number=00004 name=E:\ORACLE\ORADATA\DEBELDV2\USERS01.DBF
channel ORA_DISK_1: starting piece 1 at 11-MAR-16
channel ORA_DISK_1: finished piece 1 at 11-MAR-16
piece handle=E:\ORACLE\FLASH_RECOVERY_AREA\DEBELDV2\DEBELDV2\BACKUPSET\2016_03_1
1\O1_MF_NNNDF_TAG20160311T192012_CG632XB5_.BKP tag=TAG20160311T192012 comment=NO
NE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:15
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 11-MAR-16
channel ORA_DISK_1: finished piece 1 at 11-MAR-16
piece handle=E:\ORACLE\FLASH_RECOVERY_AREA\DEBELDV2\DEBELDV2\BACKUPSET\2016_03_1
1\O1_MF_NCSNF_TAG20160311T192012_CG6359MJ_.BKP tag=TAG20160311T192012 comment=NO
NE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 11-MAR-16
RMAN> exit
Recovery Manager complete.
C:\Users\AJ0294094>
... and when I checked the size of the backup on disk, it was roughly a quarter of the size of the backup I did before:
E:\oracle\flash_recovery_area\DEBELDV2\DEBELDV2\BACKUPSET\2016_03_11>dir
Volume in drive E is Seagate Backup Plus Drive
Volume Serial Number is 6E45-7AAF
Directory of E:\oracle\flash_recovery_area\DEBELDV2\DEBELDV2\BACKUPSET\2016_03_
11
03/11/2016 07:21 PM <DIR> .
03/11/2016 07:21 PM <DIR> ..
03/11/2016 07:21 PM 1,097,728 O1_MF_NCSNF_TAG20160311T192012_CG6359MJ_.
BKP
03/11/2016 07:21 PM 235,659,264 O1_MF_NNNDF_TAG20160311T192012_CG632XB5_.
BKP
2 File(s) 236,756,992 bytes
2 Dir(s) 579,868,397,568 bytes free
E:\oracle\flash_recovery_area\DEBELDV2\DEBELDV2\BACKUPSET\2016_03_11>
No comments:
Post a Comment