Property 'DbFileNameConvert' has inconsistent values: METADATA='/data1/oradata/SALES, /data1_tstb/oradata/SALES, /data2/oradata/SALES, /data2_tstb/oradata/SALES', SPFILE= '/data1/oradata/SALES, /data1_tstb/oradata/SALES, /data2/oradata/SALES, /data2_tstb/oradata/SALES', DATABASE='/data1/oradata/SALES/, /data1_tstb/oradata/SALES/, /data2/oradata/SALES/, /data2_tstb/oradata/SALES/'Note that the metadata and spfile is missing the trailing slash character /.
To fix this incorrect setup:
dgmgrl / as sysdba show configuration; Configuration - SALES Protection Mode: MaxPerformance Members: SALES - Primary database SALES_STB - Physical standby database SALES_TSTB - Physical standby database (receiving current redo) SALES_RO - Physical standby database Fast-Start Failover: DISABLED Configuration Status: SUCCESS (status updated 20 seconds ago)Check the current setting:
show database 'SALES_TSTB' DbFileNameConvert DbFileNameConvert = '/data1/oradata/SALES, /data1_tstb/oradata/SALES, /data2/oradata/SALES, /data2_tstb/oradata/SALES'Update the property:
DGMGRL> edit database 'SALES_STB' set property DbFileNameConvert='/data1/oradata/SALES/,/data1_stb/oradata/SALES/, /data2/oradata/SALES/, /data2_stb/oradata/SALES/'; Warning: ORA-16675: database instance restart required for property value modification to take effect Property "dbfilenameconvert" updatedVerify the new setting:
show database 'SALES_TSTB' DbFileNameConvert DbFileNameConvert = '/data1/oradata/SALES/, /data1_tstb/oradata/SALES/, /data2/oradata/SALES/, /data2_tstb/oradata/SALES/'
Restart your physical database, and the issue is fixed.
No comments:
Post a Comment