ORA-19527: physical standby redo log must be renamed

Blog Posts
1

Mar 8, 2018 2:59:00 PM by Syed Jaffar Hussain

This is a companion discussion topic for the original entry at https://blog.toadworld.com/2018/03/08/ora-19527-physical-standby-redo-log-must-be-renamed
2

Hi Syed,

Thanks for the article. I was facing the issue and searched google and found your article which helped me resolve the issue. Would like to add some more on this.
If we have broker configuration, then we may need some more changes.

Status of DGMGRL after parameter change

oracle@xldn30311tor::trace > dgmgrl /
DGMGRL for Linux: Release 18.0.0.0.0 - Production on Mon Feb 8 08:31:03 2021
Version 18.8.0.0.0

Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved.

Welcome to DGMGRL, type "help" for information.
Connected to ""
Connected as SYSDG.
DGMGRL> show configuration;

Configuration - dg_config

Protection Mode: MaxPerformance
Members:
- Primary database
- Physical standby database
Warning: ORA-16792: configurable property value is inconsistent with member setting

Fast-Start Failover: DISABLED

Configuration Status:
WARNING (status updated 18 seconds ago)

DGMGRL>

DGMGRL> show database 'InconsistentProperties'
INCONSISTENT PROPERTIES
INSTANCE_NAME PROPERTY_NAME MEMORY_VALUE SPFILE_VALUE BROKER_VALUE
LogFileNameConvert dummy, dummy dummy,dummy

DGMGRL> EDIT DATABASE set property LogFileNameConvert ='dummy,dummy';
Warning: ORA-16675: database instance restart required for property value modification to take effect

Property "logfilenameconvert" updated
DGMGRL>

Restart DB:

oracle@xldn30311tor::trace > srvctl stop db -d
oracle@xldn30311tor::trace > srvctl start db -d -o mount

Status of DGMGRL

oracle@xldn30311tor::trace > dgmgrl /
DGMGRL for Linux: Release 18.0.0.0.0 - Production on Mon Feb 8 08:40:19 2021
Version 18.8.0.0.0

Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved.

Welcome to DGMGRL, type "help" for information.
Connected to ""
Connected as SYSDG.
DGMGRL> show configuration;

Configuration - dg_config

Protection Mode: MaxPerformance
Members:
- Primary database
- Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS (status updated 32 seconds ago)

DGMGRL>

Regards,
Santosh Kumar

3

Hi Santu, Thanks for replying to the blog article and adding to it. Your response helps others. As editor of the Toad World blogs, I wanted to thank you. We appreciate your feedback and contribution to the community!