3 Replies Latest reply: Jul 10, 2013 4:09 PM by 0342dbb0-4cc6-4004-b32d-3130bb64b9ee RSS

    Why backup is so big ?

    0342dbb0-4cc6-4004-b32d-3130bb64b9ee

      Hello!

       

           I've migrated some simple application from MySQL to Oracle XE. Application works fine, but backups created with backup.sh script are huge!

      MySQL database backup was less than 2MB, but Oracle XE backup of the same database is about 1GB: 500 times more.

      Is there any way to make smaller backups ? I need something simple like output from pg_dump or mysqldump.

       

      best regards

      Jarek

        • 1. Re: Why backup is so big ?
          Paul M.
          MySQL database backup was less than 2MB, but Oracle XE backup of the same database is about 1GB

          I don't know if the two backups are comparable, but with backup.sh script you won't ever have a so small backup : it makes a full RMAN backup, and to reduce the backup size you have two choices :

           

          1. Modify the script so that it does a compressed backup

           

          2. Create your own script.

           

          Said that I obviously prefer #2, if you want to modify the script, you can change all lines with "backup as backupset device type disk database;" to "backup as compressed backupset device type disk database;"

           

          FYI, the difference, for my XE database, is as follows :

           

          Normal :

          -rw-r----- 1 oracle dba 790650880  6 lug 15:25 XE_07oe2pan_1_1.bck

          -rw-r----- 1 oracle dba   9830400  6 lug 15:25 XE_08oe2pb6_1_1.bck

          Compressed :

          -rw-r----- 1 oracle dba 176455680  6 lug 15:32 XE_comp_09oe2pnl_1_1.bck

          -rw-r----- 1 oracle dba   1097728  6 lug 15:32 XE_comp_0aoe2poo_1_1.bck

          • 2. Re: Why backup is so big ?
            jsqfel

            Backup only tablespace with user data, default script backup all database.

            • 3. Re: Why backup is so big ?
              0342dbb0-4cc6-4004-b32d-3130bb64b9ee

              How can I do it ? Can you provide some example ?

              Thank you it advance!