An Issue of
Oracle DataGuard Broker
最近一直在研究用Broker搭建Data Guard,以前一直都很顺利，这两天突然发现一个奇怪的问题，自己确认配置的步骤是没有问题的，但是show configuration的时候，就是老出如下错误提示：
DGMGRL> show configuration;
Configuration
Name: dgmgrl_1
Enabled: YES
Protection Mode: MaxPerformance
Fast-Start Failover: DISABLED
Databases:
prod - Primary database
sbdb - Physical standby database
Current status for "dgmgrl_1":
Warning: ORA-16608: one or more databases have warnings
DGMGRL> show database 'prod' statusreport;
STATUS REPORT
INSTANCE_NAME SEVERITY ERROR_TEXT
DGMGRL> show database 'sbdb' statusreport;
STATUS REPORT
INSTANCE_NAME SEVERITY ERROR_TEXT
* WARNING ORA-16707: the value of the property DbFileNameConvert is invalid, valid values are pairs of file specifications
SBDB WARNING ORA-16714: the value of property DbFileNameConvert is inconsistent with the database setting
从这个错误提示可以看出，是standby 库SBDB 的db_file_name_convert有问题,于是我做了如下的操作，终于发现问题的所在，下面红色的字体部分，竟然被截断了一部分。
DGMGRL> show database verbose SBDB
Database
Name: sbdb
Role: PHYSICAL STANDBY
Enabled: YES
Intended State: ONLINE
Instance(s):
SBDB
Properties:
InitialConnectIdentifier = 'sbdb'
LogXptMode = 'ASYNC'
Dependency = ''
DelayMins = '0'
Binding = 'OPTIONAL'
MaxFailure = '0'
MaxConnections = '1'
ReopenSecs = '300'
NetTimeout = '180'
LogShipping = 'ON'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyParallel = 'AUTO'
StandbyFileManagement = 'AUTO'
ArchiveLagTarget = '0'
LogArchiveMaxProcesses = '2'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = '/u01/app/oracle/oradata/PROD/Disk1, /u01/app/oracle/oradata/SBDB, /u01/app/oracle/oradata/PROD/Disk2, /u01/app/oracle/oradata/SBDB, /u01/app/oracle/oradata/PROD/Disk3, /u01/app/oracle/oradata/SBDB, /u01/app/oracle/oradata/PROD/Disk4, /u01/app/oracle/oradata/SBDB, /u01/app/oracle/oradata/PROD/Disk5, /u01/app/oracle/oradata/SBDB, /u01/app/oracle/oradata/PROD/Disk6, /u01/app/oracle/oradata/SBDB, /u01/app/oracle/oradata/PROD/Disk7, /u01/app/oracle/oradata/SBDB, /u01/app/oracle/oradata/PROD/Disk8'
LogFileNameConvert = '/u01/app/oracle/oradata/PROD/Disk1, /u01/app/oracle/oradata/SBDB, /u01/app/oracle/oradata/PROD/Disk2, /u01/app/oracle/oradata/SBDB, /u01/app/oracle/oradata/PROD/Disk3, /u01/app/oracle/oradata/SBDB'
FastStartFailoverTarget = ''
StatusReport = '(monitor)'
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
HostName = 'even.oracle.com'
SidName = 'SBDB'
LocalListenerAddress = '(ADDRESS=(PROTOCOL=tcp)(HOST=even.oracle.com)(PORT=1521))'
StandbyArchiveLocation = '/u01/app/oracle/bak/arch1'
AlternateLocation = ''
LogAr