Originally posted by badrinathn

Badrinath:
I am not sure how we can put the standby database in the read only mode. 'cos, you mount the database in 'standby mode', there is no where you will be able to mount it in 'read only ' mode.

Further as the database name is going to be the same it's logical that you cannot access the 'standby database'.

Sameer:
Now the question is can I keep standby db open in read only mode and apply logs on background using managed recovery

It is possible to mount standby database in read-only mode and access it.

While the standby database is in read-only mode, the site can still receive archived redo logs from the primary site. Nevertheless, Oracle does not apply these logs automatically, as in managed recovery.

So my option of keeping it in read-only mode and applying logs on background is now out....

One can achive this but in that case he must have two standby databases.. One will be in managed recovery mode and other will be in read-only mdoe.. He has to synchronize the readonly standby database periodically...

FYI

http://www.cs.rose-hulman.edu/docs/o...dbyr.htm#14723

If above link is not accessable pl. let me know I will copy paste the material..

http://otn.oracle.com/docs/products/...co.htm#1006255

Sameer