Wednesday, January 2, 2019

Physical standby redo log must be renamed

When creating standby database using database duplication it completed but received below standby redo error. This error will not stop the replication but user don’t want to see these ORA- errors.

Finished recover at 2019-02-12:15:02:32
ORACLE error from auxiliary database: ORA-19527: physical standby redo log must be renamed
ORA-00312: online log 1 thread 1: '/oracle/redo1/ORCL/ ORCL _1A.rdo'

RMAN-05535: warning: All redo log files were not defined properly.
ORACLE error from auxiliary database: ORA-19527: physical standby redo log must be renamed
ORA-00312: online log 2 thread 1: '/oracle/redo1/ORCL/ORCL _2A.rdo'

Though this didn't stop the data guard replication, the customer wanted to get-rid the message. Starting with v10g, this was an expected behavior to improve the switchover and failover. With v10g, when MRP is started, it will attempt to clear the online log files.

If PRIMARY and STANDBY has the same directory structure then you will see these errors. This is an expected behavior when you don’t set log_file_name_convert parameter. You can get rid-off the error message just setup dummy value

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

You should not see ORA messages any more in the alert.log file.

Satishbabu Gunukula, Oracle ACE


  1. شركة تنظيف والتي هي افضل شركات التنظيف علي الإطلاق ، والتي تقدم خدمات نظافة عامة ، خدمات شاملة للمنزل والفلل والبيوت ، سيدتي الفاضلة هل تعانين أثناء تنظيف المنزل من ضيق الوقت وعدم كفايتة نظراً لإنشغالك بامور اخري أو نظراً لانشغالك بعملك أو حتي لصعوبة تنظيف منزلك لكبر المنزل
    تقدم شركة ابرار خدمات التنظيف
    شركة تنظيف

  2. Really, I'm sad because I don't know about this! can i share your post It will be helpful for many people to read this article of yours. mapquest driving directions

  3. Telangana State Primary School Parents can use the Syllabus 2023 to Understand the Concepts and Prepare their Children for the Exam, Accordingly, The TS Board 1st, 2nd, 3rd, 4th, 5th Syllabus 2023 All Subject Chapter Wise Students Prepare for the Upcoming 1st, 2nd, 3rd, 4th, 5th Exam, TS 4th Class Curriculum Syllabus 2023 it is quite Essential that they have the Complete Knowledge of the TS 1st, 2nd, 3rd, 4th, 5th Class Latest Syllabus 2023 of All Relevant Subjects, Knowing the Details of Prescribed Topics and the weight age Allotted to Them Makes it easy to plan your Studies Meticulously so that you can make Effective Preparations for your Exam and obtain desired marks.