Oracle Database Discussions

Hi,

I am in process of setting up physical standby database on 9.2. I want to log shipping from LGWR, and I want database protection mode should be maximum availability.

So in log_archive_dest_2 of primary database I have set following parameters

log_archive_dest_2 string SERVICE=stndby LGWR SYNC AFFIRM

So I belive whatever I do changes should "shipped" to standby site by redo data. ( I have created standb redo logs on standby database )

But on primary database if I do changes in tables and commit, These changes are not getting applied to standby database after I open it as read only. In alerts ( production + standby ) it does not show me anything wrong.

On standby site it shows me

log_archive_dest_1 it shows me ora-00354 corrupt redo block header

My questions regarding this

Q1/ How do I correct this error ?
Q2/ If I setup log shipping thru LGWR SYNC AFFIRM how logs will get applied to standby ? If I do changes in table on primary ( very small change ) and if I open standby database can I see changes immediately ? ( assume that there is no network issue ) am I correct ?

thanks & regards
PJP