parameterfiles in switchover [message #74527] |
Sun, 26 December 2004 21:17 |
ramya
Messages: 87 Registered: August 2002
|
Member |
|
|
hi experts
When i doing the switchover whether i have to keep 2 parameter files in production and standby dbs (For primary and secondary role) or i have to keep one parameter contains all these values.When i have to do this switchover i have to comment the log_Archive_Dest_2 .Am i correct or no.pls hlp
with regards
ramya
|
|
|
Re: parameterfiles in switchover [message #74530 is a reply to message #74527] |
Tue, 28 December 2004 01:32 |
Frank Naude
Messages: 4580 Registered: April 1998
|
Senior Member |
|
|
Hi,
Quite correct. If you don't want to make parameter changes after failing or switching over, you can use a different parameter file for each of the database roles (primary and standby).
Alternatively, consider using the new syntax introduced in 10g:
LOG_ARCHIVE_DEST_x = "... VALID_FOR=database_role"
Best regards.
Frank
|
|
|