ORA-01105 & ORA-01677 模擬2

節(jié)點(diǎn)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;

重啟節(jié)點(diǎn)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里面的參數(shù)和其它節(jié)點(diǎn)有什么不一樣，然后進(jìn)行在其它節(jié)點(diǎn)reset 一下該參數(shù)；


節(jié)點(diǎn)2：
alter system reset db_file_name_convert scope=spfile sid='*';
alter system reset log_file_name_convert scope=spfile sid='*';

節(jié)點(diǎn)1：
SQL> shutdown abort
ORACLE instance shut down.
SQL> startup

還原之前的修改，最后可以找停機(jī)時(shí)間，同時(shí)重啟兩節(jié)點(diǎn)：
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';