2 Replies Latest reply: Dec 5, 2012 4:01 AM by 977852 RSS

    long-term  retention backup strategy for Oracle 10g

    977852
      Hello,
      I need design a Archivelog, Level 0 and Level 1 long-term retention backup strategy for Oracle 10g, It must be based in Rman with tapes.

      ¿Somebody could tell me what it's the best option to configure long-term retention backups in Oracle?, "CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1825 DAYS;" It's posibble ?

      Regards and thanks in advance
        • 1. Re: long-term  retention backup strategy for Oracle 10g
          mseberg
          Hello;

          RECOVERY WINDOW is an integer so yes its possible. Does it make sense?

          Later My bad, this is Oracle 11 only ( the gavinsoorma link ) . Getting harder and harder to think about 10. Don't think I would use RECOVERY WINDOW.

          I would let the tape backup system handle the retention of your rman backups.

          Using crosscheck and delete expired commands you can keep the catalog current with the available backups on tape.

          Oracle 10

          Keeping a Long-Term Backup: Example

          http://docs.oracle.com/cd/B19306_01/backup.102/b14191/rcmbackp.htm#i1006840



          http://web.njit.edu/info/oracle/DOC/backup.102/b14191/advmaint005.htm


          Oracle 11

          If you want to keep 5 years worth of backups I might just use KEEP specific date using the UNTIL TIME clause :
          keep until time 'sysdate+1825'
          More info :

          RMAN KEEP FOREVER, KEEP UNTIL TIME and FORCE commands

          http://gavinsoorma.com/2010/04/rman-keep-forever-keep-until-time-and-force-commands/

          Best Regards

          mseberg

          Edited by: mseberg on Dec 4, 2012 7:20 AM
          • 2. Re: long-term  retention backup strategy for Oracle 10g
            977852
            Thank you very much!, I have been receiving constant negative with reference to that the only way is to use "Keep Until" in Oracle 10g and I needed the opinion of an expert.