Re: Standby database as a reporting database ?

empete2000_at_yahoo.com (Pete's) wrote in message news:<6724a51f.0110010449.ecd9fe1_at_posting.google.com>...
> 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).

OK, thanks a lot. But is this really an option in real life ? That you only have the reporting database open some hours, and then close it, apply some new archived logs, close it and then open it again for reporting. This must mean that the users must be aware that between the time X and Y you can access the database.

I have no real experience with questions like this, so I am sorry if these are "stupid questions" from my side.

>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
>
Received on Tue Oct 02 2001 - 04:32:54 CDT