Re: long term archivelog retention
From: Guillermo Alan Bort <cicciuxdba_at_gmail.com>
Date: Tue, 23 Apr 2013 09:27:32 -0300
Message-ID: <CAJ2dSGS686ah34FALjKJ10FOoHNOEMqV5LpHJoKkkNErJ=cYRg_at_mail.gmail.com>
I think you need a data warehouse. If you actually want to access this information quickly, you need an online database. Otherwise depending on the size of the database and your experience doing it, restore and recovery to a different server (because you won't be able to use the same one) will take you a day or two.
hth
Date: Tue, 23 Apr 2013 09:27:32 -0300
Message-ID: <CAJ2dSGS686ah34FALjKJ10FOoHNOEMqV5LpHJoKkkNErJ=cYRg_at_mail.gmail.com>
I think you need a data warehouse. If you actually want to access this information quickly, you need an online database. Otherwise depending on the size of the database and your experience doing it, restore and recovery to a different server (because you won't be able to use the same one) will take you a day or two.
hth
Alan.-
On Tue, Apr 23, 2013 at 4:27 AM, Ls Cheng <exriscer_at_gmail.com> wrote:
> Hi Guillermo
>
> We have this requirement because it contains very sensitive data used for
> legal situations. There are some sort of checkpoint happening in the
> application several times per day and they are used for these situations.
>
> Thanks
>
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Apr 23 2013 - 14:27:32 CEST