Backing up a data warehouse

From: S. K. <askme_at_foo.com>
Date: Wed, 17 Apr 2002 09:57:11 +0200
Message-ID: <a9j9tg$3mavd$1@ID-87429.news.dfncis.de>

Database: Oracle 8.1.6 Enterprise

How can one effectively backup a data warehouse containing historical data?

I was thinking about creating a consistent, self-containing time slice of the warehouse, whereby this time-slice contains everything from the previous month -- fact tables, dimension tables, indexes... and putting all those in a transportable tablespace.

This would involve the following:

if the main tablespace for my data is TS_DATA, I would create a new tablespace TS_DATA_<date>,
if a table in TS_DATA is called TABLEX, I would create a new table TABLEX_<date> in TS_DATA_<date> and transfer all the records from TABLEX to TABLEX_<date>.
I would then create indexes for TABLEX_<date> in TS_DATA_<date>
finally, I would create a transportable tablespace out of TS_DATA_<date>, and archive it. This transportable tablespace would then represent a time slice for the data warehouse, containing tables, indexes, etc. for the previous month.

Alternative suggestions?

SK Received on Wed Apr 17 2002 - 02:57:11 CDT