Tag Archives: log_file_name_convert

ORA-19527: physical standby redo log must be renamed

ORA-19527: physical standby redo log must be renamed

Error:

ORA-19527: physical standby redo log must be renamed
ORA-00312: online log 7 thread 0: 'G:\ORACLE\ORADATA\STANDBY05.LOG'

At DR site, we got the error which describe us to rename the standby redo log. But on checking the both DR primary and Standby has same physical location.
It did not harm the data guard replication service but we need to get rid of this error message. It seems to be false alarm in DR alert log.

Solution:
To get rid of this error message in alert log. You need to set the dummy value of parameter log_file_name_convert.
If physical structure has same directories in both Primary & Standby. you can set the dummy value of this parameter as follows:

DR> ALTER SYSTEM SET log_file_name_convert='dummy','dummy';

After the parameter was set, the ORA message was no longer seen in the alert.log

Advertisements