Re: Turning Off Archive Logging for Dev, Test Systems
Date: Mon, 7 Apr 2008 07:24:44 -0700 (PDT)
Message-ID: <b1e0d32b-c6a0-4c00-b48b-05fda7c65cdf@s8g2000prg.googlegroups.com>
On Apr 7, 4:15 pm, "if_inves..._at_yahoo.com"
<basis_consult..._at_hotmail.com> wrote:
> Hi,
>
> We are running a few SAP/Ora9i/10g Windows systems in which point-in-
> time
> recovery is not needed. (Some of these systems can easily be rebuilt,
> and
> others can be restored from a regular cold backup). The systems are
> combined
> OLTP/DS.
>
> Thus, I am thinking of turning off archive logging for these systems.
> What
> are some of the other drawbacks to turning off archive logging?
>
> Thanks,
> BASIS Consultant
If you want REAL test it is better that your test environment is equal
to production system.
Performance can be slightly different.
The problem are archived logs, but you can schedule an rman script
that regularly deletes
archived logs
Regards,
Cristian Cudizio
http://oracledb.wordpress.com
http://cristiancudizio.wordpress.com
Received on Mon Apr 07 2008 - 09:24:44 CDT