Re: Question on bigfiles
Date: Mon, 26 Oct 2009 09:08:42 -0700 (PDT)
You can also use multi-section backups for normal datafiles too.
Robert G. Freeman
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
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.
"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.
>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?
>>>>Ana E. Choto
>>>>Senior Oracle Database Administrator
>>>>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!