3 Replies Latest reply: Feb 12, 2013 11:09 AM by Osama_Mustafa RSS

    compressed issue

    864103
      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.