ORA-19808

来源：互联网发布：软件服务增值税编辑：程序博客网时间：2024/06/15 13:23

RAC 启动时发现 ORA-19808

total System Global Area 3.5409E+10 bytes

Fixed Size 2235568 bytes

Variable Size 5905580880 bytes

Database Buffers 2.9394E+10 bytes

Redo Buffers 107405312 bytes

ORA-01105: mount is incompatible with mounts by other instances

ORA-19808: recovery destination parameter mismatch

（1）

[oracle@fps-ordb01 ~]$ oerr ora 19808

19808, 00000, "recovery destination parameter mismatch"

// *Cause: The value of parameters DB_RECOVERY_FILE_DEST and

// DB_RECOVERY_FILE_DEST_SIZE must be same in all instances.

// instance. All databases must have same recovery destination

// parameters.

// *Action: Check DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE

// values in all instances.

[oracle@fps-ordb01 ~]$

（2）分别在各自节点上检查参数 DB_RECOVERY_FILE_DEST

SQL> show parameter DB_RECOVERY_FILE_DEST

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

db_recovery_file_dest string +FRADG

db_recovery_file_dest_size big integer 30G

真的发现db_recovery_file_dest_size 有一个试20G一个是30G

（3) 修改其中的一个节点为一致的大小

Alter system set db_recovery_file_dest_size = 30G scope=both;

(4) 重启服务！正常了

0 0