Re: Backup setup sane?
From: joel garry <joel-garry_at_home.com>
Date: Fri, 16 Oct 2009 09:52:20 -0700 (PDT)
Message-ID: <a233327c-1621-4238-8f82-f99a1bd1fc7a_at_h14g2000pri.googlegroups.com>
On Oct 16, 1:39 am, Robert Klemme <shortcut..._at_googlemail.com> wrote:
> I set these non default settings
> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 10 DAYS;
I can't remember why, but every time I investigate it it becomes obvious this should be much longer. Something like, if you are keeping the information in the control file, then you are going to have to tell RMAN about what is actually available on disk with cross reference and delete obsolete commands and the like. So if you are going to make things on disk appear and disappear "behind RMAN's back" it is much easier with a longer retention policy. There are some things you can do with catalogs to tell RMAN about things that you can't do with nocatalog, though off the top of my head I can't recall what they are, and there are version dependencies.
Date: Fri, 16 Oct 2009 09:52:20 -0700 (PDT)
Message-ID: <a233327c-1621-4238-8f82-f99a1bd1fc7a_at_h14g2000pri.googlegroups.com>
On Oct 16, 1:39 am, Robert Klemme <shortcut..._at_googlemail.com> wrote:
>
> I set these non default settings
> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 10 DAYS;
I can't remember why, but every time I investigate it it becomes obvious this should be much longer. Something like, if you are keeping the information in the control file, then you are going to have to tell RMAN about what is actually available on disk with cross reference and delete obsolete commands and the like. So if you are going to make things on disk appear and disappear "behind RMAN's back" it is much easier with a longer retention policy. There are some things you can do with catalogs to tell RMAN about things that you can't do with nocatalog, though off the top of my head I can't recall what they are, and there are version dependencies.
At least retention policy even hurts the RMAN book authors head: http://www.freelists.org/post/oracle-l/RMAN-retention-policy,1
jg
-- _at_home.com is bogus. http://infoworld.com/d/developer-world/sad-state-mobile-web-gets-even-sadder-022Received on Fri Oct 16 2009 - 11:52:20 CDT