Maximum String Length on DbFileNameConvert Property - DataGuard Broker Config ?
edited Jul 8, 2013 7:32PM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 3 commentsAnswered
Hi Expert,
Oracle DB 11.2.0.3
I have 29 datafiles which should be converted on its paths from primary to standby as part of dataguard settings.
But, when enable configuration dgmgrl there is an warning :
{code}
DGMGRL> enable configuration;
Enabled.
DGMGRL> show configuration;
Configuration - GFMS
Protection Mode: MaxPerformance
Databases:
PFT - Primary database
PFTSTBY - Physical standby database
Warning: ORA-16809: multiple warnings detected for the database
Fast-Start Failover: DISABLED
Configuration Status:
WARNING
{code}
and hereby drcPFTSTBY.log said :
{code}
Property 'DbFileNameConvert' has inconsistent values:METADATA='/u14/oracle/PFT/apps_st/db/data/a_txn_ind21.dbf, /u15/oracle/PFT/apps_st/db/data/a_txn_ind21.dbf, /u14/oracle/PFT/apps_st/db/data/a_txn_ind22.dbf, /u15/oracle/PFT/apps_st/db/data/a_txn_ind22.dbf, /u14/oracle/PFT/apps_st/db/data/a_txn_ind23.dbf, /u15/oracle/PFT/apps_st/db/data/a_txn_ind23.dbf, /u14/oracle/PFT/apps_st/db/data/a_txn_ind24.dbf, /u15/oracle/PFT/apps_st/db/data/a_txn_ind24.dbf, /u14/oracle/PFT/apps_st/db/data/a_txn_ind25.dbf, /u15/oracle/PFT/apps_st/db/data/a_txn_ind25.dbf', SPFILE='/u14/oracle/PFT/apps_st/db/data/a_txn_ind21.dbf,/u15/oracle/PFT/apps_st/db/data/a_txn_ind21.dbf,/u14/oracle/PFT/apps_st/db/data/a_txn_ind22.dbf,/u15/oracle/PFT/apps_st/db/data/a_txn_ind22.dbf,/u14/oracle/PFT/apps_st/db/data/a_txn_ind23.dbf,/u15/oracle/PFT/apps_st/db/data/a_txn_ind23.dbf,/u14/oracle/PFT/apps_st/db/data/a_txn_ind24.dbf,/u15/oracle/PFT/apps_st/db/data/a_txn_ind24.dbf,/u14/oracle/PFT/apps_st/db/data/a_txn_ind25.dbf,/u15/oracle/PFT/apps_st/db/data/a_txn_ind25.dbf', DATABASE='/u14/oracle/PFT/apps_st/db/data/a_txn_ind21.dbf, /u15/oracle/PFT/apps_st/db/data/a_txn_ind21.dbf, /u14/oracle/PFT/apps_st/db/data/a_txn_ind22.dbf, /u15/oracle/PFT/apps_st/db/data/a_txn_ind22.dbf, /u14/oracle/PFT/apps_st/db/data/a_txn_ind23.dbf, /u15/oracle/PFT/apps_st/db/data/a_txn_ind23.dbf, /u14/oracle/PFT/apps_st/db/data/a_txn_ind24.dbf, /u15/oracle/PFT/apps_st/db/data/a_txn_ind24.dbf, /u14/oracle/PFT/apps_st/db/data/a_txn_ind25.dbf, /u15/oracle/PFT/apps_st/db/data/a_txn_ind25.dbf, /u17/oracle/PFT/apps_s'
Oracle DB 11.2.0.3
I have 29 datafiles which should be converted on its paths from primary to standby as part of dataguard settings.
But, when enable configuration dgmgrl there is an warning :
{code}
DGMGRL> enable configuration;
Enabled.
DGMGRL> show configuration;
Configuration - GFMS
Protection Mode: MaxPerformance
Databases:
PFT - Primary database
PFTSTBY - Physical standby database
Warning: ORA-16809: multiple warnings detected for the database
Fast-Start Failover: DISABLED
Configuration Status:
WARNING
{code}
and hereby drcPFTSTBY.log said :
{code}
Property 'DbFileNameConvert' has inconsistent values:METADATA='/u14/oracle/PFT/apps_st/db/data/a_txn_ind21.dbf, /u15/oracle/PFT/apps_st/db/data/a_txn_ind21.dbf, /u14/oracle/PFT/apps_st/db/data/a_txn_ind22.dbf, /u15/oracle/PFT/apps_st/db/data/a_txn_ind22.dbf, /u14/oracle/PFT/apps_st/db/data/a_txn_ind23.dbf, /u15/oracle/PFT/apps_st/db/data/a_txn_ind23.dbf, /u14/oracle/PFT/apps_st/db/data/a_txn_ind24.dbf, /u15/oracle/PFT/apps_st/db/data/a_txn_ind24.dbf, /u14/oracle/PFT/apps_st/db/data/a_txn_ind25.dbf, /u15/oracle/PFT/apps_st/db/data/a_txn_ind25.dbf', SPFILE='/u14/oracle/PFT/apps_st/db/data/a_txn_ind21.dbf,/u15/oracle/PFT/apps_st/db/data/a_txn_ind21.dbf,/u14/oracle/PFT/apps_st/db/data/a_txn_ind22.dbf,/u15/oracle/PFT/apps_st/db/data/a_txn_ind22.dbf,/u14/oracle/PFT/apps_st/db/data/a_txn_ind23.dbf,/u15/oracle/PFT/apps_st/db/data/a_txn_ind23.dbf,/u14/oracle/PFT/apps_st/db/data/a_txn_ind24.dbf,/u15/oracle/PFT/apps_st/db/data/a_txn_ind24.dbf,/u14/oracle/PFT/apps_st/db/data/a_txn_ind25.dbf,/u15/oracle/PFT/apps_st/db/data/a_txn_ind25.dbf', DATABASE='/u14/oracle/PFT/apps_st/db/data/a_txn_ind21.dbf, /u15/oracle/PFT/apps_st/db/data/a_txn_ind21.dbf, /u14/oracle/PFT/apps_st/db/data/a_txn_ind22.dbf, /u15/oracle/PFT/apps_st/db/data/a_txn_ind22.dbf, /u14/oracle/PFT/apps_st/db/data/a_txn_ind23.dbf, /u15/oracle/PFT/apps_st/db/data/a_txn_ind23.dbf, /u14/oracle/PFT/apps_st/db/data/a_txn_ind24.dbf, /u15/oracle/PFT/apps_st/db/data/a_txn_ind24.dbf, /u14/oracle/PFT/apps_st/db/data/a_txn_ind25.dbf, /u15/oracle/PFT/apps_st/db/data/a_txn_ind25.dbf, /u17/oracle/PFT/apps_s'
0