This discussion is archived
3 Replies Latest reply: Feb 12, 2013 9:09 AM by Osama_Mustafa RSS

compressed issue

864103 Newbie
Currently Being Moderated
Hi all ,

oracle database 11g.2 ASM with RAC under RHEL 5

we have 2 database both of them is RAC and ASM and use TAPE drive for backed up

database x size 290 GB
database y size 80 GB

when i check the backed up status from OEM to check the status i found the input size for x database is 272.12 GB
but the output is 233.61
the input for y database is 79.11 GB but the output is 20.11 GB

i check it in rman i found all the backed up is not compressed
Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
4201    B  0  A SBT_TAPE    04-FEB-13       1       1       NO         TAG201302
but i have the below configuration in rman :
RMAN> show all
2> ;

RMAN configuration parameters for database with db_unique_name MEDI are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 31 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/backup01/oracle/FRA/%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE TAPE TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO COMPRESSED BACKUPSET;
CONFIGURE DEVICE TYPE 'TAPE' BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 1;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE TAPE TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/backup01/oracle/FRA/MEDI%TAG%U';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/home/app/oracle/product/11.2.0/dbs/snapcf_MEDI1.f'; # default
can anyone telll me how can i comressed the backup in TAPE drive.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points