Re: Standby database as a reporting database ?

You should be able to do this with 8i. I had to look into Standy by DB's 6 montsh ago for a 734 db, but, found a lot of info on 817 db's. With 8i, you should be able to do your standby recovery, then open it for read only or take it out of recovery mode(I don't remember what the exact steps were). Then if you needed to apply more archives, you had to put it back into recovery mode, apply the logs and then you could take it out of recovery mode again.

HTH,
Pete's

Trifon Anguelov <trifona_at_pacbell.net> wrote in message news:<3BB501CB.C0C43797_at_pacbell.net>...
> Christian Svensson wrote:
>
> > Greetings !
> >
> > I am studying for the Backup & Recovery certification (Oracle 8i) and
> > wonder if there are any means to make a standby database as a
> > reporting database.
> >
> > What I have read so far is that if you open the standby db, it gets
> > out of sync from the production db and will not apply the archived
> > redo logs anymore.
> >
> > I cant be the only person thinking this is a waste of resources. There
> > must be some ways to accomplish this. How is it in Oracle 9i ?
> >
> > Thanks for any ideas.
> >
> > /Christian Svensson
>
> Christian,
>
> The other way is replication which in most cases is used for replicating
> subset or the whole database to reporting db.
>
> In Oracle 9i there is Data Guard 9i which makes easy to fail over to
> standby db. In most cases standby db is used as HA solution instead of
> read-only db.
>
> Also on the market are Veritas Replication and Quest Shareplex - check
> them out. Great products.
>
> Hope that helps.
>
> Trifon Anguelov
> Senior Oracle DBA
>
> www.dbaclick.com
Received on Mon Oct 01 2001 - 07:49:04 CDT