ORA-19527: physical standby redo log must be renamed

We have a standby server which has been rebuilt recently due to a storage failure. After that we have started to see the following errors in the alert.log on the standby server:

Tue Sep 29 15:06:39 2020
Errors in file /opt/oracle/diag/rdbms/prod2/PROD/trace/PROD_rfs_1605.trc:
ORA-19527: physical standby redo log must be renamed
ORA-00312: online log 6 thread 1: '/redoa/oracle/oradata/PROD/redo_stdby06a.log'

Didn’t find anything wrong other than the errors and searched the internet, it seems the solution is to set log_file_name_convert to dummy values when both primary and physical standby have the same disk layout and file structure.

Tried it and it worked. The error has gone since then.

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

System altered.

SQL> show parameter log_file_name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_file_name_convert                string
SQL> alter database recover managed standby database cancel;

Database altered.

SQL> shutdown immediate;
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area 9.6637E+10 bytes
Fixed Size                  4510496 bytes
Variable Size            2.9528E+10 bytes
Database Buffers         6.6840E+10 bytes
Redo Buffers              263921664 bytes
Database mounted.
SQL>  show parameter log_file_name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_file_name_convert                string      dummy, dummy

Reference:

ORA-19527 reported in Standby Database when starting Managed Recovery (Doc ID 352879.1)
ORA-19527: Physical Standby Redo Log Must Be Renamed…during switchover (Doc ID 2194825.1)

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 )

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