Re: Oracle EE 12.1 standardize on bigfile tablespaces?

From: Chris Stephens <cstephens16_at_gmail.com>
Date: Mon, 20 Feb 2017 14:46:12 +0000
Message-ID: <CAEFL0szcizRuBKV5u4QN67R1ZyFxW_r0cv98jPGYXktUp06FiA_at_mail.gmail.com>



Weekly level 0, daily level 1, hourly archivelogs. We plan to include section size in our backup scripts.

On Mon, Feb 20, 2017 at 8:19 AM Niall Litchfield <niall.litchfield_at_gmail.com> wrote:

> What is your backup approach? The unit of backup is generally the data
> file. AFAIK RMAN parallel backup still doesn't automatically calculate
> section size in the absence of declaring it. If your bigfiles aren't really
> big, that's not a problem - but for terabyte-sized datafile backups to slow
> media it will be.
>
> On Mon, Feb 20, 2017 at 1:59 PM, Chris Stephens <cstephens16_at_gmail.com>
> wrote:
>
> We are in the process of building a new Exadata system that will host a
> relatively large number of 12.1 EE RAC databases. We are trying to keep
> everything as simple as possible and are currently planning on
> standardizing on bigfile tablespaces for all application data.
>
> Are there any downsides/reasons to not do this?
>
> Thanks,
> chris
>
>
>
>
> --
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info
>

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Feb 20 2017 - 15:46:12 CET

Original text of this message