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