Saturday, 6 May 2017

ORA-19527: physical standby redo log must be renamed on Standby Database

After Setup Standby Database some times you might see below error in Standby Alert log .  Because of you are not set it up log_file_name_convert parameter on Standby Database.


Errors in standby alert log  -

ORA-19527: physical standby redo log must be renamed
ORA-00312: online log 9 thread 1: '+DATA/XXXX/ONLINELOG/group_9.456.942941005'

Solution :-

Solution for this Error is so Simple , This Problem Occur when Database parameter "log_file_name_convert" is not set.

ALTER SYSTEM SET LOG_FILE_NAME_CONVERT='+DATA/XXXXXX','+DATA/XXXXXX','+REDO/XXXXXX','+REDO/XXXXX' SCOPE= BOTH;


No comments:

Post a Comment