This discussion is archived
2 Replies Latest reply: Dec 5, 2012 2:01 AM by 977852 RSS

long-term  retention backup strategy for Oracle 10g

977852 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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.

Legend

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