The Standby SID for each primary can be whatever you need. The Parameter DB_NAME would be the same on both, but DB_UNIQUE_NAME would be different.
DB_FILE_NAME_CONVERT=('/u01/app/oracle/oradata/RECOVER2', '/u01/app/oracle/oradata/RECLONE','/u01/oradata/RECOVER2','/u01/oradata/RECLONE') LOG_FILE_NAME_CONVERT=('/u01/app/oracle/flash_recovery_area/RECOVER2', '/u01/app/oracle/flash_recovery_area/RECLONE')
so on master side, nothing changes, just on standby side i need to use those new parameters?
You copy and rename the password file in Oracle 11
on oracle 11 i have to use the same passwd file for primary and standby so in this case all primary and all standby involved will need to have a copy of that passwd file right??
Just FAL_SERVER, FAL_CLIENT is not needed in Oracle 11.
do i need to use fal_client and fal_server parameters?
when i put the new standby in recover mode it tried to use the rlog in the primary database and primary database crashed. i have to switch standby to primary. so for some reason the parameter to convert datafile name and log names doesn´t work for redo logs.Can you share the log when primary database crashed? If you put standby in recovery mode why it will use the redo log of primary?
i created the standby redo logs before try to put the standby in recover mode, it created the files okay. but when put in recover it tried to use the files in the original path, and in this case was a production db running.If you have the same location of redo log files as primary and standby, After the duplication the standby redo log files created in same location until unless you modify LOG_FILE_NAME_CONVERT
*.db_file_name_convert='/disk/prod/2/oradata/prod','/disk/prod/DR/2/oradata/prodtur','/disk/prod/3/oradata/prod','/disk/prod/DR/3/oradata/prodtur'Even though you change the values LOG_FILE_NAME_CONVERT, they cannot be relocated automotically if they already created. You must drop and create with new location other than the primary location.
Even though you change the values LOG_FILE_NAME_CONVERT, they cannot be relocated automotically if they already created. You must drop and create with new location other than the primary location.so RLOGs created in the primary needs to be renamed or recreated on standby controlfile anyway even with the parameters above? only RLOG or any other files? so far all datafiles are okay as the standby gets aligned.