Dear All,

I have configured oracle physical standby database for Quality server for testing

I have done one transaction on primary server. I have saved the transaction. On another screen I have ready with
command "ALTER DATABASE RECOMVER MANAGED STANDBY DATABASE CANCEL".

As soon as I received a document number generated by transaction complition on primary server. I execute the command on next screen realted to cancel managed recover. I have checked in relavant table but transaction is no applied on standby database.

In tesing of some cases it is saved in standby DB.

What to do for real time apply.

I have created standby redolog files on standby database. Standby database is in managed recovery mode.

Part of the initilization parameter relavant to standby configuration are as below:

*********************************
Primary :

--------------------------------------------------------------------------------
log_archive_dest_state_1=enable
log_archive_dest_1='LOCATION=/softdump/oraarch/'
log_archive_dest_state_2=ENABLE
LOG_ARCHIVE_DEST_2='SERVICE=QASST LGWR SYNC AFFIRM'
SERVICE_NAMES=QASPR
FAL_SERVER=QASPR
FAL_CLIENT=QASST

***********************************************

*********************************
Standby :



--------------------------------------------------------------------------------
log_archive_dest='/oracle/PRD/sapdata4/QAS/stby'
STANDBY_ARCHIVE_DEST='/oracle/PRD/oraarch'
FAL_SERVER=QASPR
FAL_CLIENT=QASST
STANDBY_FILE_MANAGEMENT=auto
*********************************

Regards,

Nirav