3 Replies Latest reply: May 23, 2013 11:36 AM by jgarry RSS

    11g xe backup solutions?

    useruseruser
      Hi all
      I was installing oracle 11g express, before 2 years
      and set it to work on archive log mode, and I was making first backup.
      Now, theres lots of archive logs on /u01/app/oracle/flash_recovery_area/XE/archivelog/ date / *.arc
      from 2012-02-11 and all of then are biger then 30 Mbytes, multiple with thousand *.arc files.

      Could I try run from rman: delete archive log all completed before 'sysdate-10'; and be sure
      for sucsesfull backup scenario which constist 5 steps
      1) copy flash_recovery_area from old oracle database
      2) re- install oracle 11g express database
      3) make first backup and set it on archive log mode
      4) replace new flash_recovery_area with old and
      5) restore.
      os linux, 11g express 4.01 apex
      regards,
      Gordan

      Edited by: useruseruser on May 23, 2013 3:54 PM
        • 1. Re: 11g xe backup solutions?
          sybrand_b
          re-install Oracle XE with a new database id?
          This will render your backups useless!

          Proper solution would be
          shutdown immediate on the database
          rman target /
          startup mount
          backup database tag="cold backup"
          alter database open

          Now you can wipe the archive logs!

          -------
          Sybrand Bakker
          Senior Oracle DBA
          • 2. Re: 11g xe backup solutions?
            EdStevens
            useruseruser wrote:
            Hi all
            I was installing oracle 11g express, before 2 years
            and set it to work on archive log mode, and I was making first backup.
            Now, theres lots of archive logs on /u01/app/oracle/flash_recovery_area/XE/archivelog/ date / *.arc
            from 2012-02-11 and all of then are biger then 30 Mbytes, multiple with thousand *.arc files.

            Could I try run from rman: delete archive log all completed before 'sysdate-10'; and be sure
            for sucsesfull backup scenario which constist 5 steps
            1) copy flash_recovery_area from old oracle database
            2) re- install oracle 11g express database
            3) make first backup and set it on archive log mode
            4) replace new flash_recovery_area with old and
            5) restore.
            os linux, 11g express 4.01 apex
            regards,
            Gordan

            Edited by: useruseruser on May 23, 2013 3:54 PM
            The proper (and standard, text-book) way to manage that is to do regular periodic backups of the database AND archivelogs.

            Once per week, the following rman script
            crosscheck archivelog all;
            delete expired archivelog all;
            crosscheck backup;
            delete expired backup;
            backup incremental level 0 database ;
            sql "alter system archive log current";
            backup as compressed backupset archivelog all delete all input;
            delete obsolete;
            and the other 6 days:
            crosscheck archivelog all;
            delete expired archivelog all;
            crosscheck backup;
            delete expired backup;
            backup incremental level 0 database ;
            sql "alter system archive log current";
            backup as compressed backupset archivelog all delete all input;
            delete obsolete;
            To be implemented after you've followed Sybrand's instructions to clean up the current mess.
            • 3. Re: 11g xe backup solutions?
              jgarry
              Maybe you can just do 2 backups and have them automatically clean up your flash area? Assuming you have room, of course. http://docs.oracle.com/cd/E17781_01/server.112/e18804/backrest.htm