| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 8.05 Backing up Datawarehouse
Jonathan Lewis wrote:
>
> I have often found that large databases used
> for 'warehouse' purposes end up with a very
> large section of read-only data. (Typically
> data ceases to change after it is a few weeks
> or months old).
>
> If this is the case, you can design the database
> so that the relevant tablespaces become read
> only, and need just a single backup after the
> switch. This reduces the volume of data
> needed by a hot backup.
>
> Secondly - if you have time to do a cold backup
> then you must have some time when the database
> (insert/update) activity is low. This is the point at
> which to do a hot backup. (BTW - in many cases,
> a 'data warehouse' suffers a large batch load overnight,
> and very little change during the day - in these cases
> there is little problem in doing a hot backup during
> the working day).
>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: www.jlcomp.demon.co.uk
>
> sparik_at_my-deja.com wrote in message <7n9hsd$jrl$1_at_nnrp1.deja.com>...
> >We currently have a 500Gb datawarehouse running on Unix4E and Oracle
> >8.0.5.1. Previously we have been runing cold backups to backup the
> >database.
> >
> >I would be interested to know of other methods people use to backup
> >VLDB's.
> >
Hello Johnathon,
Have you used the RMAN incremental backup at all ? If so, any comments ?
--
"Some days you're the pigeon, and some days you're the statue." Received on Fri Jul 23 1999 - 04:06:19 CDT
 |
 |