Re: storing blobs in database

From: Brent Day <coloradodba_at_gmail.com>
Date: Tue, 17 Jan 2012 11:59:18 -0700
Message-ID: <CAEz8shy0pKwb5BNBtu3RF+bruG37v7EGKV1yhMLORhGrT+_NKg_at_mail.gmail.com>

If backup time is that critical you could store them in the same database using a dedicated tablespace for the LOB data. Then exclude that tablespace from your standard backup and create a backup process to backup the LOB tablespace.
To exclude the tablespace use the following RMAN command "CONFIGURE EXCLUDE FOR TABLESPACE <LOB TABLESPACE NAME>;

Brent

On Tue, Jan 17, 2012 at 11:47 AM, Jeff Chirco <JChirco_at_innout.com> wrote:

> We are working on an application that will store images, well actualy
> pdf's in our database. We are debating on storing the blobs in our main
> production database or creating a separate database just for these images.
> We have applications running on our main production database that will
> need to pull these across to display. I am thinking a second database is
> the best idea since this database will get rather large very quickly and I
> don't want to slow down the backup of my main production database. Does
> anybody else do something similar to this and can provide your experiences.
> We are running 11.2.0.2 Enterprise Edition on Windows Server 20003 R2,
> soon to be 2008.
> Thanks.
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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

Received on Tue Jan 17 2012 - 12:59:18 CST