Xref: alice comp.databases.oracle.misc:52343
Newsgroups: comp.databases.oracle.misc
Path: alice!news-feed.fnsi.net!netnews.com!newspeer1.nac.net!news1.radix.net!news.er.usgs.gov!news
From: Brian Peasland <peasland@edcmail.cr.usgs.gov>
Subject: Re: backup and recovery in data warehouse
Content-Type: text/plain; charset=us-ascii
Message-ID: <389839D7.D4D79E80@edcmail.cr.usgs.gov>
Sender: news@igsrsparc2.er.usgs.gov (Janet Walz (GD) x6739)
Content-Transfer-Encoding: 7bit
Organization: Raytheon Systems
X-Accept-Language: en
References: <877o0p$7kl$1@nnrp1.deja.com>
Mime-Version: 1.0
Date: Wed, 2 Feb 2000 14:06:15 GMT
X-Mailer: Mozilla 4.61 [en] (WinNT; U)
Lines: 27

If you are doing cold backups, then you should backup the entire
database. If you want to back up different tablespaces on different
nights, then use hot backups. Alternatively, you can also use exports.
To find information, check out Oracle8 Backup and Recovery from Oracle
Press. Or Oracle 24x7 also from Oracle Press.

HTH,
Brian


jeremycdba@my-deja.com wrote:
> 
> I'm looking for information on a backup and recovery strategy for a
> data warehouse. I'm thinking of using a combination of read-only
> tablespaces and incremental cold backups, ie backing up different
> tablespaces/datafiles each night. I can't find any case studies or
> specific examples of this method and would appreciate information or
> pointers to documents, articles or white papers etc.
> 
> I'm using Oracle 8i on Unix Solaris.
> 
> Thanks
> 
> Jeremy
> 
> Sent via Deja.com http://www.deja.com/
> Before you buy.