节点1模拟修改操作: alter system set db_file_name_convert='+data/healdg/datafile/','+data/heal/datafile/' scope=spfile; alter system set log_file_name_convert='+data/healdg/tempfile/','+data/heal/tempfile/' scope=spfile; 重启节点1: startup force -- ORA-01105: mount is incompatible with mounts by other instances ORA-01677: standby file name conversion parameters differ from other instance SQL> create pfile='/tmp/1.txt' from spfile; vi /tmp/1.txt --分析1.txt里面的参数和其它节点有什么不一样,然后进行在其它节点reset 一下该参数; 节点2: alter system reset db_file_name_convert scope=spfile sid='*'; alter system reset log_file_name_convert scope=spfile sid='*'; 节点1: SQL> shutdown abort ORACLE instance shut down. SQL> startup 还原之前的修改,最后可以找停机时间,同时重启两节点: alter system set db_file_name_convert='+data/healdg/datafile/','+data/heal/datafile/' scope=spfile sid='orcl1'; alter system set db_file_name_convert='+data/healdg/datafile/','+data/heal/datafile/' scope=spfile sid='orcl2'; |