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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.