Standby Database

[bhattnirav]

Dear All,

I have configured Oracle Standby database. Oracle version is 10.2.0.2.


I have done some testing.

e.g.

1. I have made on transaction on primary DB and after that I have cancelled the managed recovery on standby, open the standby DB in readonly. Check the transaction details on standby database. It was perfectly applied on standby database.

2. After that onces again I have tried the same scenari but this time redo was not appllied to standby database.

What are the possible reason for the same ?

Regards,

Nirav

[bhattnirav]

I have configured the archive destination parameter as below :

LOG_ARCHIVE_DEST_2='SERVICE=QASST LGWR SYNC AFFIRM'

[vnktummala]

if you want to check whether the particular log is applied or not you need to query from v$archived_log (APPLIED column). If you open physical standby in read only then you need to rebuild it.

you can do that from 11g R2 onwards using either active standby or snapshot standby techniques.

Regards,