Database Administration (MOSC)

MOSC Banner

Oracle 10g 10.2.0.5 dataguard switchover

edited Oct 2, 2013 5:10AM in Database Administration (MOSC) 5 commentsAnswered
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'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center