RE: storing blobs in database
- From: Jeff Chirco <JChirco@xxxxxxxxxx>
- To: Andy Klock <andy@xxxxxxxxxxxxxxx>, "Gsais@xxxxxxxxxxxxxxxxxxxx" <Gsais@xxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 17 Jan 2012 21:19:56 +0000
I am going to use SecureFiles, which is still a blob though. I forgot to
mention that our main production data is part of a physical data guard
environment so I am not sure if that changes anything. Also, we plan on
encrypting these blobs, which SecureFiles will come in handy. And I don't need
a new EE license since I plan on make the database on the same server as my
main production instance.
Also these pdf's will be static once they are created.
I will need regular backups of this blob data, we can't afford to loose it.
And I am not sure yet but it might need to be consistent with the backups on
our main production database because there will be a document ID value that
will be
used in other applications on our main database.
From: andyklock@xxxxxxxxx [mailto:andyklock@xxxxxxxxx] On Behalf Of Andy Klock
Sent: Tuesday, January 17, 2012 12:31 PM
To: Gsais@xxxxxxxxxxxxxxxxxxxx
Cc: Jeff Chirco; oracle-l@xxxxxxxxxxxxx
Subject: Re: storing blobs in database
I happen to think databases are a nice place to store documents. With 11.2 I'd
definitely recommend using SecureFiles over BLOBS. As for backup times, you'll
have to decide the impact or if there are other ways to speed up the rman
times. Static pdf files can be placed in a readonly tablespace, add more
parallel to your backups, or doing incrementals with block change tracking (to
name a few). By adding a new EE database you've added more license fees.
But definitely look into securefiles.
Andy
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
