846422 wrote:That's fine. Why you always missing something?
How do I judge?
I checked alert log, the logfile errors are all gone and I compared os asm logfiles with db logfiles , they match.
However there has been none any entry in alert log on standby side since I brought them to recovery mode.
Error 16047 02-JUL-2012 21:52:15 PING[ARC2]: Heartbeat failed to connect to standby 'prds'. Error is 16047.ORA-16047:
1 VALID OPEN ARCH IDLE MAXIMUM PERFORMANCE 0 0 900SQL> alter system set log_archive_dest_state_2='defer';
2 DISABLED UNKNOWN LGWR IDLE MAXIMUM PERFORMANCE 0 0 0
log_archive_dest_2 string service="prds", LGWR ASYNC NOAFFIRM delay=0 optional compression=disable max_failure=0 max_connections=1 reopen=300 db_unique_name="prds" net_timeout=30, valid_for=(all_logfiles,primary_role)Its not necessary to put Service name & DB_UNIQUE_NAME in double quotes, set again properly(trial)
And in your Standby INIT you should have
log_archive_dest_2='SERVICE=STANDBY LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=STANDBY'
ORA-16047 is a mismatch between destination setting and standby. Yes, make sure they are the same case too. LOG_ARCHIVE_CONFIG if set can cause this too.
This will cause the error!!
db_unique_name string PRDS