一、關閉數據庫(2個節點實例都要關閉)
srvctl stop database -d ora19c
二、多路徑控制文件
打開其中一個節點到nomount狀態
sqlplus / as sysdba
startup nomount;
[oracle@ora19c1:/home/oracle]$ rman target /
RMAN> restore controlfile to '+OCR' from '+DATA/ORA19C/CONTROLFILE/Current.257.1057568499';
---Current.257.1057568499這種格式必須用rman 導入。
三、修改spfile
create pfile='/home/oracle/pfile.ora' from spfile;
alter system set control_files='+DATA/ORA19C/CONTROLFILE/Current.257.1057568499','+OCR/ORA19C/CONTROLFILE/current.262.1116745615' scope=spfile;
四、重啟數據庫
shutdown immediate;
srvctl start database -d ora19c