oracle 11g RAC ORA-19808: recovery destination parameter mismatch

来源：互联网发布：德州扑克知乎编辑：程序博客网时间：2024/05/06 01:12

RAC上的node2, instance起不来。手工启动试试：

SQL> startup
ORACLE instance started.

Total System Global Area 8551575552 bytes
Fixed Size                  2270360 bytes
Variable Size            6073355112 bytes
Database Buffers         2466250752 bytes
Redo Buffers                9699328 bytes
ORA-01105: mount is incompatible with mounts by other instances
ORA-19808: recovery destination parameter mismatch

SQL>

检查一下配置信息：

SQL> col name for a30
SQL> col value for a30
SQL> select name ,value,inst_id from gv$system_parameter where name like '%db_recovery%';

NAME                           VALUE                             INST_ID
------------------------------ ------------------------------ ----------
db_recovery_file_dest                                                  2
db_recovery_file_dest_size     0                             2
db_recovery_file_dest          +DG_DD_DD                              1
db_recovery_file_dest_size     83886080000                             1

SQL>

修复方法如下：

alter system set db_recovery_file_dest_size=83886080000 scope=both;
alter system set db_recovery_file_dest='+DG_DDD_DD' scope=both;

参考URL如下：

http://www.askmaclean.com/archives/ora-19808%E9%94%99%E8%AF%AF%E4%B8%80%E4%BE%8B.html

下次改成共享的spfile。

0 0