Re: Question on bigfiles

From: Robert Freeman <robertgfreeman_at_yahoo.com>
Date: Mon, 26 Oct 2009 09:08:42 -0700 (PDT)
Message-ID: <264818.6436.qm_at_web113212.mail.gq1.yahoo.com>

You can also use multi-section backups for normal datafiles too.

 Robert G. Freeman
Oracle ACE
Ask me about on-site Oracle Training! RMAN, DBA, Tuning, you name it! Author:
Oracle Database 11g RMAN Backup and Recovery (Oracle Press) - ON IT'S WAY SOON! OCP: Oracle Database 11g Administrator Certified Professional Study Guide (Sybex) Oracle Database 11g New Features (Oracle Press) Oracle Database 10g New Features (Oracle Press) Other various titles
Blog: http://robertgfreeman.blogspot.com

---

From: Bradd Piontek <piontekdd_at_gmail.com> To: surachart_at_gmail.com
Cc: achoto_at_american.edu; oracle-l_at_freelists.org Sent: Mon, October 26, 2009 9:55:31 AM
Subject: Re: Question on bigfiles

One small caveat. In 11g or greater, RMAN can now use "SECTION"s to backup a BIGFILE tablespace with more than one process.

Bradd Piontek
  "Next to doing a good job yourself,

        the greatest joy is in having someone 
        else do a first-class job under your  
        direction."

• William Feather

On Mon, Oct 26, 2009 at 10:50 AM, Surachart Opun <surachart_at_gmail.com> wrote:

>
>
>If you use big tablespace with ASM, that perfect with VLDB...
>Bigfile will reduce number datafiles. Improve checkpointing, and database opens faster...
>reduce overhead to manage large number of datafiles.
>
>
>with Bigfile tablespaces... RMAN will use only ONE channel to backup a bigfile.
>
>
>
>Surachart Opun
>http://surachartopun.com
>
>
>
>
>On Mon, Oct 26, 2009 at 10:31 PM, Ana Choto <achoto_at_american.edu> wrote:
>
>>>
>>
>>I'm trying to decide whether to use bigfiles for some of our datawarehouse tablespaces. What are the advantages/disadvantages of using bigfiles instead of several, say 2GB datafiles?
>>
>>>>Thank you
>>
>>>>Ana
>>
>>>>---------------------------------------------------------
>>>>Ana E. Choto
>>>>Senior Oracle Database Administrator
>>>>American University
>>>>Office of Information Technology
>>>>Phone (202) 885-2275
>>>>Fax (202) 885-2224
>>
>>>>** AU IT will never ask for your password via e-mail.
>>>>Don't share your password with anyone!
>>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Oct 26 2009 - 11:08:42 CDT