Re: Creating an Oracle Reporting Server

Sybrand Bakker wrote:

> On Wed, 18 Jun 2003 00:11:51 +0200, "Anton Buijs"
> <remove_aammbuijs_at_xs4all.nl> wrote:
>
> >
> >Joseph C. Henning <jchenning_at_yahoo.com> schreef in berichtnieuws
> >685bef7f.0306171330.77a2a699_at_posting.google.com...
> >| I have a question on the number of ways you can replicate a production
> >| database to a reporting server (data warehouse). Can this be done by
> >| hot backups? Can this be done on a transaction basis? Just looking
> >| for different ideas on how to do this task. Any help would be great.
> >|
> >| Regards,
> >| Joe
> >
> >Make a standby database that is constantly fed by the archives of the
> >orgininal database.
> >That standby database can be opened for read only.
> >Always forget in which version a feature becomes available but I think it is
> >9.0 in this case.
> >
>
> This feature came available as standby database in 8i, and is renamed
> to dataguard in 9i
>

Expanding on Sybrand's comment -

The standby feature started in Oracle7.3 as the "standby database" (virtually unknown and very tricky), floundered through 8.0 and was semi-solid in Oracle8i. People started scripting the standby around 8.0 and Dataguard was introduced around 8.1.6 to provide a supported set of scripts. Early 9i (9.0) Dataguard was enhanced with a GUI, was available for download and was able to support both 8.1.7 & 9.0.

The 8.1.7 variant is well documented in Standby Database Concepts and Administration manual at http://docs.oracle.com (PDF is http://otn.oracle.com/pls/tahiti/tahiti.to_pdf?partno=a76995&remark=docindex)

Oracle9i R2, togther with the relevant Dataguard and OEM includes logical standby as well as physical. Many improvements ..... Received on Wed Jun 18 2003 - 10:55:15 CDT