请教一下，RAC的同一个节点频繁因ORA-00227宕机

lfree · 发表于 2019-11-26 12:06

然后修改spfile.

十窝羊 · 发表于 2019-11-26 12:12

lfree 发表于 2019-11-26 12:05
应该是这样restore controlfile to '+CTL' from +FRA/xxxdb/controlfile/current.256.931801685';

是的，只需要指定目录，具体的控制文件是在asm里查看到的，spfile文件也已修改。

lovehewenyu · 发表于 2019-11-26 16:18

col CHECKPOINT_CHANGE# for 9999999999999999
select CHECKPOINT_CHANGE# from v$database;

select file#,checkpoint_change# from v$datafile;

十窝羊 · 发表于 2019-11-26 18:38

lovehewenyu 发表于 2019-11-26 16:18
col CHECKPOINT_CHANGE# for 9999999999999999select CHECKPOINT_CHANGE# from v$database;select file#,ch ...

SQL> col CHECKPOINT_CHANGE# for 9999999999999999
SQL> select CHECKPOINT_CHANGE# from v$database;

CHECKPOINT_CHANGE#
------------------
      1825867511

SQL> select file#,checkpoint_change# from v$datafile;

      FILE# CHECKPOINT_CHANGE#
--------------- ------------------
            1       1825867511
            2       1825867511
            3       1825867511
            4       1825867511
            5       1825867511
            6       1825867511
            7       1825867511
            8       1825867511
            9       1825867511

9 rows selected.