Oracle 10g 10.2.0.5 dataguard switchover
Hi,
Please advise me on the switch-over. is there any additional parameters i have to set? and please advise on the TNS as well.
database version - 10.2.0.5,PFILE.
PROD
db_name = PROD
db_unique_name=PROD
*.log_archive_dest_2='service=STBYPROD lgwr async optional'
*.log_archive_dest_state_2='enable'
*.fal_client='STBYPROD'
*.fal_server='PROD'
*.STANDBY_FILE_MANAGEMENT=AUTO
standby_archive_dest='/uprod/arch/PROD_%t_%s.arc'
STBYPROD
db_name = PROD
db_unique_name=STBYPROD
log_archive_dest_2='service=PROD lgwr async optional'
log_archive_dest_state_2=enable
log_archive_dest_1='location=/uprod/arch'
log_archive_format='PROD_%t_%s_%r.arc'
0