Re: Question on bigfiles
- From: Robert Freeman <robertgfreeman@xxxxxxxxx>
- To: piontekdd@xxxxxxxxx, surachart@xxxxxxxxx
- Date: Mon, 26 Oct 2009 09:08:42 -0700 (PDT)
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@xxxxxxxxx>
To: surachart@xxxxxxxxx
Cc: achoto@xxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxx> 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@xxxxxxxxxxxx> 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!
>>
>
Other related posts:
