ORA-00220: control file not mounted by first instance

Problem

RMAN> alter database mount;
 RMAN-00571: ===========================================================
 RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
 RMAN-00571: ===========================================================
 RMAN-03002: failure of sql statement command at 08/14/2018 12:28:18
 ORA-00220: control file not mounted by first instance, check alert log for more info
 ORA-00202: control file: '+FRA2/ORCL/CONTROLFILE/control04.ctl'

Analyse

NODE1

SQL> show parameter control
 NAME TYPE VALUE
 ------------------------------------ ----------- ----------------
 control_files string
 +DATA/ORCL/CONTROLFILE/control03.ctl,
 +FRA2/ORCL/CONTROLFILE/control04.ctl,
 +REDO/ORCL/CONTROLFILE/control01.ctl

NODE2

SQL> show parameter control
 NAME TYPE VALUE
 ------------------------------------ ----------- ----------------
 control_files string
 +DATA/ORCL/CONTROLFILE/control03.ctl,
 +FRA/ORCL/CONTROLFILE/control04.ctl,
 +REDO/ORCL/CONTROLFILE/control01.ctl

Solution

SQL> alter system set control_files='+DATA/ORCL/CONTROLFILE/control03.ctl', '+FRA/ORCL/CONTROLFILE/control02.ctl', '+REDO/ORCL/CONTROLFILE/control01.ctl' scope=spfile sid='*';
 System altered.

Komentáře