| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Query Standby databases ?
>On Wed, 3 Feb 1999 17:40:07 -0000, "Andrew Gilkes"
><andyg_at_kalamazoo.co.uk> wrote:
>
>>Hi,
>>
>>A friend has just confidently informed me that you can query a database
>>thats in standby mode. This doesn't appear to be the case according to the
>>Oracle 8.0 documentation that I have. Is this some Oracle 8i feature ? any
>>ideas ?
>
>Yes, read-only operations will be available on the standby database in
>Oracle8i. This is a totaly new feature, not available in current
>releases.
Allow me elaborate a little. this new feature is the ability to open the database in READ ONLY mode without breaking the redo chain. This will allow you to stop applying redo logs and open the database readonly. When you shutdown the database you can start applying them again.
So, while the database is open -- no redo is applied, it'll be queued. When the database is closed -- redo is applied but no queries are allowed.
Also new with this is the automatic shipping of redo for you (used to be manual, now done for you). also new is the automated application of redo logs (used to be manual, you had to script it).
>
>>Andrew Gilkes
>>Sr. Technical Support Specialist
>>Kalamazoo PLC
>>Andrew.Gilkes_at_NOTkalamazoo.co.uk <-- to reply, remove the obvious
>
>HTH,
>Jurij Modic <jmodic_at_src.si>
>Certified Oracle7 DBA (OCP)
>================================================
>The above opinions are mine and do not represent
>any official standpoints of my employer
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA
--
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Sat Feb 06 1999 - 16:21:24 CST
 |
 |