Error from data guard:
oracle@oric-dbserver01:[vegdb01]# dgmgrl / DGMGRL for Linux: Release 18.0.0.0.0 - Production on Thu Mar 12 08:02:54 2020 Version 18.9.0.0.0 Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved. Welcome to DGMGRL, type "help" for information. Connected to "vegdb01" Connected as SYSDG. DGMGRL> show configuration; Configuration - myConfig Protection Mode: MaxPerformance Members: vegdb01 - Primary database vegdb01_stby - Physical standby database Warning: ORA-16792: configurable property value is inconsistent with member setting Fast-Start Failover: DISABLED Configuration Status: WARNING (status updated 10 seconds ago) DGMGRL> show database vegdb01_stby Database - vegdb01_stby Role: PHYSICAL STANDBY Intended State: APPLY-ON Transport Lag: 0 seconds (computed 1 second ago) Apply Lag: 0 seconds (computed 1 second ago) Average Apply Rate: 143.00 KByte/s Real Time Query: OFF Instance(s): vegdb01 Warning: ORA-16714: the value of property LogFileNameConvert is inconsistent with the member setting Database Status: WARNING
Solved by setting the log_file_name_convert on the standby side.
Using dgmgrl:
edit DATABASE "vegdb01_stby" SET PROPERTY LogFileNameConvert = " "," ";Or set it by using sqlplus on the standby site, see this post for how to do that
No comments:
Post a Comment