Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Backing up a data warehouse
Oracle's RMAN.
Pete's
"S. K." <askme_at_foo.com> wrote in message news:<a9j9tg$3mavd$1_at_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 - 08:44:19 CDT