Querying a standby database

[mewa]

Hi All,
I'd like to know if it is possible to query the standby database when it works in managed or manual recovery mode.
I know it is possible when the db works in read-only mode, but still need the definite answer if it is possible or not when db is recovering. It's Oracle 8.1.6.

Thanks a lot!

mewa

 

[MikeLacey]

I thought that the SB DB was not actually "open" when it was recovering, which would be all of the time. If it's not open you won't be able to query it surely. Mike
________________________________________________________________

"Experience is the comb that Nature gives us, after we are bald."

Is that a haiku?
I never could get the hang
of writing those things.

 

[ThomVF]

From technet:

Using a standby database for queries makes it unavailable for managed recovery. At some point, you need to run a recovery operation against the standby database to resynchronize it with the primary database. This action limits the role of the standby database as a disaster recovery database.

If you need the standby database both for disaster prevention and reporting, then you can maintain multiple standby databases, some read-only and some in managed recovery mode. You will need to resynchronize the read-only database, but the recovery mode databases give you protection against disaster.
=================================
Thomas V. Flaherty Jr.
Birch Hill Technology Group, Inc.

http://www.birchhillgroup.com